alphasil Posted January 18, 2015 Share Posted January 18, 2015 Hi I have another problem with my code I have records in my database and i want to put them in Jgrid but no records are show. This is my php <?php error_reporting(0); require_once 'database_connection.php'; $page = $_GET['page']; // get the requested page $limit = $_GET['rows']; // get how many rows we want to have into the grid $sidx = $_GET['sidx']; // get index row - i.e. user click to sort $sord = $_GET['sord']; // get the direction if(!$sidx) $sidx =1; // connect to the database $result = mysql_query("SELECT COUNT(*) AS count FROM utilizador"); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; // do not put $limit*($page - 1) $SQL = "SELECT * FROM utilizador ORDER BY $sidx $sord LIMIT $start , $limit"; $result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[idutilizador]; $responce->rows[$i]['cell']=array($row[idutilizador],$row[nome],$row[utilizador],$row[telefone],$row[email]); $i++; } echo json_encode($responce); ?> And this is the Jgrid <html> <head> <title>jQGrid example</title> <!-- Load CSS--><br /> <link rel="stylesheet" href="css/ui.jqgrid.css" type="text/css" media="all" /> <!-- For this theme, download your own from link above, and place it at css folder --> <link rel="stylesheet" href="css/jquery-ui-1.9.2.custom.css" type="text/css" media="all" /> <!-- Load Javascript --> <script src="js/jquery_1.5.2.js" type="text/javascript"></script> <script src="js/jquery-ui-1.8.1.custom.min.js" type="text/javascript"></script> <script src="js/i18n/grid.locale-pt.js" type="text/javascript"></script> <script src="js/jquery.jqGrid.min.js" type="text/javascript"></script> </head> <body> <table id="datagrid"></table> <div id="navGrid"></div> <p><script language="javascript"> jQuery("#datagrid").jqGrid({ url:'example.php', datatype: "json", colNames:['Idutilizador','Nome', 'Utilizador', 'Telefone','Email'], colModel:[ {name:'idutilizador',index:'idutilizador', width:55,editable:false,editoptions:{readonly:true,size:10}}, {name:'nome',index:'nome', width:80,editable:true,editoptions:{size:10}}, {name:'idutilizador',index:'idutilizador', width:90,editable:true,editoptions:{size:25}}, {name:'telefone',index:'telefone', width:60, align:"right",editable:true,editoptions:{size:10}}, {name:'email',index:'email', width:60, align:"right",editable:true,editoptions:{size:10}} ], rowNum:10, rowList:[10,15,20,25,30,35,40], pager: '#navGrid', sortname: 'idutilizador', sortorder: "asc", height: 500, width:900, viewrecords: true, caption:"Atividades Registadas" }); jQuery("#datagrid").jqGrid('navGrid','#navGrid',{edit:true,add:true,del:true}); </script> </body> </html> Anything wrong with the code? Regards Quote Link to comment https://forums.phpfreaks.com/topic/294028-blank-jgrid-table-with-jsonphpmysql/ Share on other sites More sharing options...
ginerjm Posted January 18, 2015 Share Posted January 18, 2015 You thought of php error reporting but you didn't do it right. Try turning it ON, not off. See my signature. Quote Link to comment https://forums.phpfreaks.com/topic/294028-blank-jgrid-table-with-jsonphpmysql/#findComment-1503321 Share on other sites More sharing options...
alphasil Posted January 18, 2015 Author Share Posted January 18, 2015 Hi Thank you my server.php is now <?php error_reporting(E_ALL | E_NOTICE); ini_set('display_errors', '1'); require_once 'database_connection.php'; $page = $_GET['page']; // get the requested page $limit = $_GET['rows']; // get how many rows we want to have into the grid $sidx = $_GET['sidx']; // get index row - i.e. user click to sort $sord = $_GET['sord']; // get the direction if(!$sidx) $sidx =1; // connect to the database $result = mysql_query("SELECT COUNT(*) AS count FROM utilizador"); $row = mysql_fetch_array($result,MYSQL_ASSOC); $count = $row['count']; if( $count >0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; } if ($page > $total_pages) $page=$total_pages; $start = $limit*$page - $limit; // do not put $limit*($page - 1) $SQL = "SELECT * FROM utilizador ORDER BY $sidx $sord LIMIT $start , $limit"; $result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); $responce->page = $page; $responce->total = $total_pages; $responce->records = $count; $i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $responce->rows[$i]['id']=$row[idutilizador]; $responce->rows[$i]['cell']=array($row[idutilizador],$row[nome],$row[utilizador],$row[telefone],$row[email]); $i++; } echo json_encode($responce); ?> I have put the error reporting and when i run only server.php i have this Notice: Undefined index: page in C:\xampp\htdocs\login\server.php on line 5Notice: Undefined index: rows in C:\xampp\htdocs\login\server.php on line 6Notice: Undefined index: sidx in C:\xampp\htdocs\login\server.php on line 7Notice: Undefined index: sord in C:\xampp\htdocs\login\server.php on line 8Warning: Division by zero in C:\xampp\htdocs\login\server.php on line 16Couldn t execute query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 But i'm following this tutorial http://www.trirand.com/blog/jqgrid/jqgrid.html Quote Link to comment https://forums.phpfreaks.com/topic/294028-blank-jgrid-table-with-jsonphpmysql/#findComment-1503322 Share on other sites More sharing options...
ginerjm Posted January 18, 2015 Share Posted January 18, 2015 Following the tutorial is no excuse for not addressing the errors you are clearly seeing. You are going to get those errors if you blindly go trying to capture input values that don't exist yet. You need to do some checking to see if you have any input yet or if this is the initial execution of this script. Also - where is this apparent "input" coming from? Another script that should precede this one? Is that script actually sending input via a GET or should you be receiving a POST array? If you don't understand this then you need to do some reading on how data is handled by a browser and delivered to a php script. It would be a good learning experience regardless. Quote Link to comment https://forums.phpfreaks.com/topic/294028-blank-jgrid-table-with-jsonphpmysql/#findComment-1503327 Share on other sites More sharing options...
alphasil Posted January 18, 2015 Author Share Posted January 18, 2015 Ok Almost everything fixed but now i having this problem The Jgrid gives me this url Request URL:http://localhost/login/server.php?_search=false&rows=20&page=1&sidx=&sord=asc And nothing is show but if i put this url manually i have records http://localhost/login/server.php?_search=false&page=1&rows=3&sidx=1&sord=asc So how can i change the Jgrid url? regards Quote Link to comment https://forums.phpfreaks.com/topic/294028-blank-jgrid-table-with-jsonphpmysql/#findComment-1503338 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.