.Hello! I cannot save the row back to my Database upon pressing enter, following the in-line row editing example. Is the server side code wrong? I am referring to this file via the editurl option.
require_once("JSON.php");
//Create JSON Service (PHP0 ) {
$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)
//$joomla_user =& JFactory::getUser();
//$userid = $joomla_user->get('id');
//obviously I am looking to integrate it to Joomla!
$SQL = "UPDATE guestlist SET name='$name', at_ceremony='$at_ceremony',
at_party='$at_party', table_no='$table_no', affiliation='$affiliation',
registrar='$registrar' WHERE userid='Administrator' AND id_number='$id'";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());
$response->page = $page;
$response->total = $total_pages;
$response->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$response->rows[$i]=$row[id];
$response->rows[$i]=array($row,$row,$row,$row,$row,$row,$row);
$i++;
}
echo json_encode($response);
}
?>
Ioannis Thomopoulos
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
