str_month_name; } function display_form($key, $str_month_name, $action) { global $PHP_SELF; echo "
'; echo '"; echo '"; echo ''; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; echo '
Month Name:'; echo ' "; echo '
'; echo ' '; echo '
'; echo '
'; echo "
'; echo ' '; echo '
'; } function display_heading($table_name, $key, $activity) { echo "

Record Maintenance:  $table_name

$activity Record:  $key

"; } if ($arr_request['action'] == 'clone_record') { get_record_info(); display_heading($table_name, $key, "Cloning"); display_form($key, $str_month_name, "insert"); exit(); } if ($arr_request['action'] == 'edit_record') { get_record_info(); display_heading($table_name, $key, "Editing"); display_form($key, $str_month_name, "update"); exit(); } if ($arr_request['action'] == 'update') { $key = $arr_request['key']; $str_month_name = $arr_request['str_month_name']; $current_date = date('Y-m-d H:i:s'); $str_sql = " update $table_name set str_month_name = '$str_month_name' ,dte_updated = '$current_date' where key_$table_name = $key "; $result = mysql_db_query($dbname, $str_sql, $id_link); if (! $result) { affy_error_exit('SQL Delete Execution has failed.'); } echo '

The row has been updated.

'; echo "

Click Here "; echo 'for Further Table Maintenance.

'; exit(); } if ($arr_request['action'] == 'delete_record') { $key = $arr_request['key']; $str_sql = " delete from $table_name where key_$table_name = $key "; $result = mysql_db_query($dbname, $str_sql, $id_link); if (! $result) { affy_error_exit('SQL Delete Execution has failed.'); } echo '

The row has been deleted.

'; echo "

Click Here "; echo 'for Further Table Maintenance.

'; exit(); } if ($arr_request['action'] == 'set_sort_field') { $sort_field = $arr_request['sort_field']; $sort_direction = $arr_request['sort_direction']; } if ($arr_request['action'] == 'insert') { // Determine the current date & time in // YYYY-MM-DD HH:MM:SS format using a // 24 hour clock. $current_date = date('Y-m-d H:i:s'); // Dynamically create the SQL needed to // insert the record. The values for // the key field will be automatically // generated by MySQL. And the value for // flg_deleted has a default of 'N' so // it does not need to be specified. $str_sql = " insert into $table_name ( dte_created ,dte_updated ,str_month_name ) values ( '$current_date' ,'$current_date' ,'" . $arr_request['str_month_name'] . "' ) "; $result = mysql_db_query($dbname, $str_sql, $id_link); if (! $result) { affy_error_exit('SQL Insert Execution has failed.'); } echo '

The row has been inserted.

'; echo "

Click Here "; echo 'for Further Table Maintenance.

'; exit(); } ?>