if (isset($_GET['id'])) { $id = urldecode($_GET['id']); require_once 'form_data_eval_hdr.php'; } elseif (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_delete']); require 'components/query_string_standard.php'; if ($_POST['btn_cancel']) { log_action('Pressed cancel button', $_SERVER['PHP_SELF']); redirect("listview_eval_hdr.php?{$query_string}"); } elseif ($_POST['btn_delete']) { log_action('Pressed delete button', $_SERVER['PHP_SELF']); require_once 'subclasses/eval_hdr.php'; $dbh_eval_hdr = new eval_hdr(); $object_name = 'dbh_eval_hdr'; require 'components/create_form_data.php'; $dbh_eval_hdr->del($arr_form_data); require_once 'subclasses/eval_dtl.php'; $dbh_eval_hdr = new eval_dtl(); $dbh_eval_hdr->del($arr_form_data); redirect("listview_eval_hdr.php?{$query_string}"); } } require 'subclasses/eval_hdr_html.php'; $html = new eval_hdr_html(); $html->draw_header('Delete Eval Hdr', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('id'); $html->detail_view = TRUE; $html->draw_controls('delete'); $html->draw_footer();
redirect("listview_eval_hdr.php?{$query_string}"); } if ($_POST['btn_submit']) { log_action('Pressed submit button', $_SERVER['PHP_SELF']); $message .= $dbh_eval_hdr->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_eval_hdr->check_uniqueness_for_editing($arr_form_data)->is_unique) { //Good, no duplicate in database } else { $message = "Record already exists with the same primary identifiers!"; } if ($message == "") { $dbh_eval_hdr->edit($arr_form_data); require_once 'subclasses/eval_dtl.php'; $dbh_eval_hdr = new eval_dtl(); $dbh_eval_hdr->del($arr_form_data); for ($a = 0; $a < $eval_dtl_count; $a++) { $param = array('id' => $id, 'questionnaire_id' => $cf_eval_dtl_questionnaire_id[$a], 'eval_hdr_id' => $id, 'response_rating' => $cf_eval_dtl_response_rating[$a], 'response_detail' => $cf_eval_dtl_response_detail[$a]); $dbh_eval_hdr->add($param); } redirect("listview_eval_hdr.php?{$query_string}"); } } } require 'subclasses/eval_hdr_html.php'; $html = new eval_hdr_html(); $html->draw_header('Edit Eval Hdr', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('id'); $html->draw_controls('edit'); $html->draw_footer();
<?php //****************************************************************** //This file was generated by Cobalt, a rapid application development //framework developed by JV Roig (jvroig@jvroig.com). // //Cobalt on the web: http://cobalt.jvroig.com //****************************************************************** require 'path.php'; init_cobalt('View eval hdr'); if (isset($_GET['id'])) { $id = urldecode($_GET['id']); require 'form_data_eval_hdr.php'; } if (xsrf_guard()) { init_var($_POST['btn_back']); if ($_POST['btn_back']) { log_action('Pressed cancel button'); require 'components/query_string_standard.php'; redirect("listview_eval_hdr.php?{$query_string}"); } } require 'subclasses/eval_hdr_html.php'; $html = new eval_hdr_html(); $html->draw_header('Detail View: Eval Hdr', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->detail_view = TRUE; $html->draw_controls('view'); $html->draw_footer();
$hostname = "localhost"; //connection to the database $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); //echo "Connected to MySQL<br>"; //select a database to work with $selected = mysql_select_db("apc-cpo", $dbhandle) or die("Could not select examples"); //execute the SQL query and return records $result = mysql_query("SELECT count(question) as count FROM questionnaire WHERE type = 'Resume'"); $questions = mysql_query("SELECT question,id FROM questionnaire WHERE type = 'Resume'"); //fetch tha data from the database while ($row = mysql_fetch_array($result)) { $i = $row['count']; } while ($row = mysql_fetch_array($questions)) { $z = $row['question']; $r = $row['id']; $m = $r - 1; //echo '<!DOCTYPE html><meta charset="UTF-8"><html><body>'; // echo '<input type=text name="cf_eval_dtl_questionnaire[' . $r . ']" placeholder="' . $z . '" >'; // echo '<input type=hidden name="cf_eval_dtl_questionnaire_id[' . $m .']" value="' . $r . '">'; $cf_eval_dtl_question[$m] = $z; $cf_eval_dtl_questionnaire_id[$m] = $r; //echo '</body></html>'; } //close the connection mysql_close($dbhandle); //echo $result; $eval_dtl_count = $i; $num_eval_dtl = $i; $html->draw_controls('add'); $html->draw_footer();