Greetings. Thank you for providing this wonderful project. However, I’m having difficulties updating my MySql table using the various update programs in the /dhtmlxGrid/samples/ folder. Firstly, I could not find the “sample_grid” dump.sql file anywhere and therefore substituted my own table. The Grid populates correctly but to no avail after several days, it does not update OR delete row. My initial intent is to provide the grid to users to enable a quick update of several records. Below, please find sample code: I look forward to your prompt reply.
1. get.php
error_reporting(E_ALL ^ E_NOTICE);
//include db connection settings
//change this setting according to your environment
require_once(‘…/…/common/config.php’);
require_once(‘…/…/common/config_dp.php’);
//include XML Header (as response will be in xml format)
header(“Content-type: text/xml”);
//encoding may be different in your case
echo(‘<?xml version="1.0" encoding="utf-8"?>’);
//start output of data
echo ‘’;
//output data from DB as XML
//$sql = “SELECT * from samples_grid”;
$sql = “SELECT recid, year(curdate())-year(memberraiseddate) - (right(curdate(),5) < right(memberraiseddate,5)) as ‘serviceyears’, lodge_name, CONCAT(memberlastname, ', ', memberfirstname ) AS membername, membermobilephone, memberemail, memberstatus, memberseatoffice, memberrank, membersecretary, duespaid, CONCAT(memberaddress, ’ ', membercity, ’ ', memberstate) AS ‘MemberHomeAddress’, memberzip, memberraiseddate FROM sublodges WHERE lodge_name = ‘Western Knights’ AND memberlastname IS NOT NULL AND memberstatus != ‘Deceased’ AND memberstatus != ‘Suspended’ AND memberstatus != ‘Expelled’ AND memberlastname != ‘Record’ ORDER BY memberlastname ASC”;
$res = mysql_query ($sql);
if($res){
while($row=mysql_fetch_array($res)){
//create xml tag for grid’s row
echo (“<row id='”.$row[‘recid’].“'>”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
print(“”);
}
}else{
//error occurs
echo mysql_errno().“: “.mysql_error().” at “.LINE.” line in “.FILE.” file
”;
}
echo ‘’;
?>
2. dhtmlxGrid/samples/04_dataprocessor/02_all_at_once.html :
…
Update few rows and press "update" button - all rows will be updated by single AJAX request
3… update_names.php
<?php //code below is simplified - in real app you will want to have some kins session based autorization and input value checking error_reporting(E_ALL ^ E_NOTICE); //include db connection settings require_once('../../common/config.php'); require_once('../../common/config_dp.php'); function update_row(){ $sql = "UPDATE sublodges SET membermobilephone='".$_GET["membermobilephone"]."', memberemail= '".addslashes($_GET["memberemail"])."', memberrank= '".addslashes($_GET["memberrank"])."', memberstatus= '".$_GET["memberstatus"]."', duespaid= '".$_GET["duespaid"]."', WHERE recid=".$_GET["recid"]; $res = mysql_query($sql); return "update"; } function delete_row(){ $d_sql = "DELETE FROM sublodges WHERE recid=".$_GET["gr_id"]; $resDel = mysql_query($d_sql); return "delete"; }