dropdown, file-upload and Master detail

Questionsdropdown, file-upload and Master detail
fmaymar asked 10 years ago

Hi, firstly, sorry for my bad english.

I´m a beginner in programming and with your great phpGrid. I installed the software with the demos and it works fine but, i have problems with three features:

Q1: DROP DOWN. I think i reproduced your dropdown examples exactly as them in my app but they don´t work. I tried both examples but muy page looks blank when i executed it. is it necesary to do the query with INNER JOIN like the example?

Q2.- FILE UPLOAD: When i select an image I receive this message: Unable to move to desired folder temp/image.png.

Q3.-MASTER DETAIL: all the demo app woks fine but, with demos in Master-Detail directory show me this message:
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO

Can you help me please?

Thank you very much.

5 Answers
Abu Ghufran answered 10 years ago

1) Please check error log for possible fatal errors. Make sure you are calling $g->get_dropdown() function after the object creation $g=new jqgrid(); Error log of apache will show exact reason of blank page.

2) Most likely, the upload_dir path does not exist and php has not enough rights to create folder.

3) You can use mysqli extension using database layer. See this faq.

Q) How to use mysqli extension?

Here is the config settings.

$db_conf = array();
$db_conf["type"] = "mysqli";
$db_conf["server"] = "localhost"; // or you mysql ip
$db_conf["user"] = "root"; // username
$db_conf["password"] = "test"; // password
$db_conf["database"] = "griddemo"; // database

// include and create object
$base_path = strstr(realpath("."),"demos",true)."lib/";
include($base_path."inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);

fmaymar answered 10 years ago

I fixed the three problems with your solutions! Thank you very much!

Sjaak answered 9 years ago

Q2

How to find out or debug what is wrong.
I can't get it to work.
I allways get the messages "Unable to move to desired folder /Image.
Directory excist and has 777 permission

Abu Ghufran answered 9 years ago

This message is pushed when move_uploaded_file function returns FALSE inside lib (jqgrid_dist.php)

By documentation:
If filename is not a valid upload file, then no action will occur, and move_uploaded_file() will return FALSE.
If filename is a valid upload file, but cannot be moved for some reason, no action will occur, and move_uploaded_file() will return FALSE. Additionally, a warning will be issued.

To get the warning error:
Edit jqgrid_dist.php and search for move_uploaded_file and remove @ sign.

if ( @move_uploaded_file($tmp_name, "$uploads_dir/$name") )
{
$msg = "$uploads_dir/$name";
}
else
$error = "Unable to move to desired folder $uploads_dir/$name";

germanmary answered 9 years ago

how to fix this issue sir

Your Answer

12 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?