';
echo ' |
';
}
function cet_href($action, $text, $key_value) {
echo '';
echo "";
echo "$text";
}
// Expected parameters:
//
function cet_insert($ary) {
$table_name = $ary['table_name'];
$dbname = $ary['dbname'];
$id_link = $ary['id_link'];
$name = $ary['name'];
$phone = $ary['phone'];
$current_date = date('Y-m-d H:i:s');
$str_sql = "
insert into
$table_name
(
dte_created
,dte_updated
,name
,phone
)
values
(
'$current_date'
,'$current_date'
,'$name'
,'$phone'
)
";
$result = mysql_db_query($dbname, $str_sql, $id_link);
if (! $result) {
affy_error_exit("SQL Insert Execution has failed.
$str_sql
");
}
}
function cet_update($ary) {
$table_name = $ary['table_name'];
$dbname = $ary['dbname'];
$id_link = $ary['id_link'];
$key_value = $ary['key_value'];
$name = $ary['name'];
$phone = $ary['phone'];
$current_date = date('Y-m-d H:i:s');
$str_sql = "
update
$table_name
set
name = '$name'
,phone = '$phone'
,dte_updated = '$current_date'
where
key_$table_name = $key_value
";
$result = mysql_db_query($dbname, $str_sql, $id_link);
if (! $result) {
affy_error_exit("SQL Update Execution has failed.
$str_sql
");
}
}
// Expected parameters:
// dbname - the database name.
// table_name - the database table name.
// key_value - the key for the needed record.
// id_link - the connection id for the database.
//
function cet_read($ary) {
$table_name = $ary['table_name'];
$key_value = $ary['key_value'];
$str_sql = "
select *
from $table_name
where key_$table_name = $key_value
";
$result =
mysql_db_query(
$ary['dbname'], $str_sql, $ary['id_link']);
if (! $result) {
affy_error_exit("SQL Select Execution failed.
$str_sql
");
}
$record = @mysql_fetch_object($result);
return($record);
}
// All of the PHP functions are now defined,
// it's time to perform the actions and
// display the page.
?>
cet: Concurrent Edit Test
Concurrent Edit Test
$str_sql
");
}
echo 'The record has been deleted.
';
echo "Click Here ";
echo 'for Further Table Maintenance.
';
exit();
}
if ($arr_request['action'] == 'update') {
$record = cet_update(array(
dbname => $dbname
,table_name => $table_name
,id_link => $id_link
,key_value => $arr_request['key_value']
,'name' => $arr_request['name']
,'phone' => $arr_request['phone']
));
echo 'The record has been updated.
';
echo "Click Here ";
echo 'for Further Table Maintenance.
';
exit();
}
if ($arr_request['action'] == 'edit') {
$record = cet_read(array(
dbname => $dbname
,table_name => $table_name
,key_value => $arr_request['key_value']
,id_link => $id_link
));
cet_display_form(array(
'key_value' => $arr_request['key_value']
,'name' => $record->name
,'phone' => $record->phone
,'bgcolor' => 'yellow'
,'button' => 'Save Changes'
,'next_action' => 'update'
));
exit();
}
if ($arr_request['action'] == 'insert') {
cet_insert(array(
'table_name' => $table_name
,'dbname' => $dbname
,'id_link' => $id_link
,'name' => $arr_request['name']
,'phone' => $arr_request['phone']
));
echo 'The record has been inserted.
';
echo "Click Here ";
echo 'for Further Table Maintenance.
';
exit();
}
$str_sql = "select * from $table_name";
$result = mysql_db_query($dbname, $str_sql, $id_link);
if (! $result) {
affy_error_exit('SQL Select Execution has failed.');
}
$number_of_records = @mysql_num_rows($result);
?>
""
,"phone" => ""
,'next_action' => 'insert'
,'button' => 'Add a Record'
));
?>
There are no records in this table.';
}
else {
echo '';
echo 'Actions | ';
echo 'Name | Phone |
';
for ($iindex = 0;
$iindex < $number_of_records;
$iindex++) {
$record = @mysql_fetch_object($result);
echo '';
cet_href('edit', 'Edit', $record->key_concurrent);
echo ' ';
cet_href('delete', 'Delete', $record->key_concurrent);
echo ' | ';
echo $record->name;
echo ' | ';
echo $record->phone;
echo ' |
';
}
echo '
';
}
?>