save_sg_table.php

Here is the DHTML tree example with full source code

<?php

	include('sc_config.inc.php');

	$pm_charset = 'iso-8859-1';

	session_start();


// Ajax config code
if (!defined("PATH_SEPARATOR"))
  define("PATH_SEPARATOR", getenv("COMSPEC")? ";" : ":");
ini_set("include_path", ini_get("include_path").PATH_SEPARATOR.dirname(__FILE__));
// Ajax config code


	require_once('class/class.dynaimage.php');
	require_once('class/class.query.php');


// Declare Ajax lib
require_once 'ajax/JsHttpRequest.php';

// Create main library object
// Set page encoding. Important!
$JsHttpRequest =& new JsHttpRequest($pm_charset);
// Get query


$row_id = @$_POST['row_id'];
$folder0 = @$_POST['folder0'];
$name = @$_POST['name'];
$surname = @$_POST['surname'];
$level = @$_POST['level'];
$chairman = @$_POST['chairman'];
$time = @$_POST['time'];
$description = @$_POST['description'];
$status = @$_POST['status'];
$amount = @$_POST['amount'];
$created = @$_POST['created'];

$action = @$_GET['action'];
$row_id_list = @$_GET['row_id_list'];


	switch ($action) {

		case 'delete':

			$id_array = explode('|', $row_id_list);
			if ($id_array) {
				// delete images
				foreach ($id_array as $key=>$image_id) {
					$pict = new dynaimage($image_id, $folder0, 0, $parent_folder);
					$pict->delete($pict->file());
				}

				$sql_id_str = '('.implode(',', $id_array).')';

				$query = '
delete from sg_table where id in '.$sql_id_str.'
				';

				$q = new query($query);

				if (!$q->exec()) {
					$error = 'Cannot delete rows selected!';
				}
			} else {
				$error = 'No rows to delete!';
			}

			break;

		case 'add':

			
			if ($chairman) {
	$query = '
update sg_table set chairman = "0"
	';

	$q = new query($query);
	$q->update();
			}


			$query = '
insert into sg_table
(name,surname,level,chairman,time,description,status,amount,created)
	values
("'.mysql_real_escape_string($name).'",
"'.mysql_real_escape_string($surname).'",
"'.mysql_real_escape_string($level).'",
"'.mysql_real_escape_string($chairman).'",
"'.mysql_real_escape_string($time).'",
"'.mysql_real_escape_string($description).'",
"'.mysql_real_escape_string($status).'",
"'.mysql_real_escape_string($amount).'",
"'.mysql_real_escape_string($created).'")
			';

			$q = new query($query);
			$new_row_id = $q->insert();

			if (!$new_row_id) {
				$error = $query.'Cannot save new row in DB!';
			} else {
				// read the DB row as some data (ie dates) could
				// be changed by DB
				$query = '
SELECT *
	FROM sg_table
WHERE id = "'.mysql_real_escape_string($new_row_id).'"
				';

				$q = new query($query);
				$row_data = $q->select1();
			}

			break;

		default:

			
			if ($chairman) {
	$query = '
update sg_table set chairman = "0"
	';

	$q = new query($query);
	$q->update();
			}


			$query = '
update sg_table set
name = "'.mysql_real_escape_string($name).'",
surname = "'.mysql_real_escape_string($surname).'",
level = "'.mysql_real_escape_string($level).'",
chairman = "'.mysql_real_escape_string($chairman).'",
time = "'.mysql_real_escape_string($time).'",
description = "'.mysql_real_escape_string($description).'",
status = "'.mysql_real_escape_string($status).'",
amount = "'.mysql_real_escape_string($amount).'",
created = "'.mysql_real_escape_string($created).'"
where id = "'.mysql_real_escape_string($row_id).'"
			';
			$q = new query($query);

			$result = $q->update();

			if (!$result) {
				$error = 'Cannot save the row changed in DB!';
			} else {
				// read the DB row as some data (ie dates) could
				// be changed by DB
				$query = '
SELECT *
	FROM sg_table
WHERE id = "'.mysql_real_escape_string($row_id).'"
				';

				$q = new query($query);
				$row_data = $q->select1();

			}

			break;
	}


// Prepare result as a PHP array
$_RESULT = array(
	'status' => isset($error)?$error:'ok',
	'new_row_id' => @$new_row_id?$new_row_id:'',
'cell_value0' => @$new_row_id,
'cell_value1' => htmlspecialchars(@$row_data['name']),
'cell_value2' => htmlspecialchars(@$row_data['surname']),
'cell_value3' => htmlspecialchars(@$row_data['level']),
'cell_value4' => htmlspecialchars(@$row_data['chairman']),
'cell_value5' => substr(@$row_data['time'], 0, 5),
'cell_value6' => htmlspecialchars(@$row_data['description']),
'cell_value7' => htmlspecialchars(@$row_data['status']),
'cell_value8' => htmlspecialchars(@$row_data['amount']),
'cell_value9' => htmlspecialchars(@$row_data['created'])
);

?>