function store_data_in_db()
{
### NOT A DUP
process_parameters();
validate_data($_POST);
$db = get_db_handle();
$params = $_POST;
// insert parent info
$parent_fname = $params['fname'];
$parent_mname = $params['mname'];
$parent_lname = $params['lname'];
$parent_address = $params['address'];
$parent_address1 = $params['address1'];
$parent_hphone = $params['home_area_phone'] . $params['home_prefix_phone'] . $params['home_phone'];
$parent_cphone = $params['cell_area_phone'] . $params['cell_prefix_phone'] . $params['cell_phone'];
$parent_city = $params['city'];
$parent_state = $params['state'];
$parent_zip = $params['zip'];
$parent_email = $params['email'];
$sql = "INSERT INTO parent (first_name, middle_name, last_name, address1, address2, city, state, zip, primary_phone, secondary_phone, email)" . "VALUES('{$parent_fname}','{$parent_mname}','{$parent_lname}','{$parent_address}','{$parent_address1}','{$parent_city}', '{$parent_state}','{$parent_zip}', '{$parent_hphone}', '{$parent_cphone}', '{$parent_email}' );";
mysqli_query($db, $sql);
$how_many = mysqli_affected_rows($db);
if ($how_many == 1) {
} else {
$msg = "A critical error occurred in parent insertion. <br />";
write_form_error_page($msg);
exit;
}
//echo $sql;
// insert child info
$parent_id = 0;
$parent_phone = $params['home_area_phone'] . $params['home_prefix_phone'] . $params['home_phone'];
$sql = "SELECT id from `parent` where primary_phone='{$parent_phone}';";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_array($result);
$parent_id = $row[0];
}
$child_relation = $params['relation'];
$child_fname = $params['cfname'];
$child_lname = $params['clname'];
$child_mname = $params['cmname'];
$child_bday = $params['bday'];
$child_gender = $params['gender'][0];
$child_ifile = $params['cfname'] . "_" . $_FILES['fileUpload']['name'];
$child_nickname = $params['goesby'];
$child_conditions = $params['conditions'];
$child_diet = $params['diet'];
$child_emname = $params['emeContactname'];
$child_emphone = $params['area_phone'] . $params['prefix_phone'] . $params['phone'];
$sql = "INSERT INTO child(parent_id, relation, first_name, middle_name, last_name, nickname, image_filename, gender, birthdate, conditions, diet, emergency_name, emergency_phone) " . "VALUES ('{$parent_id}','{$child_relation}','{$child_fname}','{$child_mname}','{$child_lname}','{$child_nickname}','{$child_ifile}','{$child_gender}',STR_TO_DATE('{$child_bday}','%d/%m/%Y'),'{$child_conditions}','{$child_diet}','{$child_emname}','{$child_emphone}');";
mysqli_query($db, $sql);
$how_many = mysqli_affected_rows($db);
if ($how_many == 1) {
} else {
$msg = "A critical error occurred in child insertion. <br />";
write_form_error_page($msg);
exit;
}
// echo $sql;
// insert enrollment
$child_id = 0;
$sql = "SELECT id from `child` where parent_id = '{$parent_id}' and first_name = '{$child_fname}'";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_array($result);
$child_id = $row[0];
}
$enrollment = 0;
$program = $_POST['program'];
for ($i = 0; $i < count($program); $i++) {
$program_id = get_program_id($program[$i]);
$sql = "INSERT INTO `enrollment`(`program_id`, `child_id`) VALUES ({$program_id}, {$child_id});";
mysqli_query($db, $sql);
$how_many = mysqli_affected_rows($db);
// echo $sql;
if ($how_many == 1) {
} else {
$msg = "A critical error occurred in enrollment insertion.";
write_form_error_page($msg);
exit;
}
}
mysqli_close($db);
}
* This page allows for the tagging of program objectives to course objectives.
*/
global $PAGE, $CFG, $DB, $USER;
require_once '../../config.php';
require_once 'lib.php';
// Check that they can access
require_login();
// TODO: Get permissions working
//require_capability('local/metadata:ins_view', $context);
require_once $CFG->dirroot . '/local/metadata/tag_form.php';
$categoryId = get_category_id();
$PAGE->set_category_by_id($categoryId);
$courseId = get_course_id();
$objectiveId = get_objective_id();
$groupId = get_group_id();
$programId = get_program_id();
$course = $DB->get_record('course', array('id' => $courseId), '*', MUST_EXIST);
// Set up page information
$PAGE->set_context(context_coursecat::instance($categoryId));
$PAGE->set_pagelayout('standard');
$PAGE->set_title(get_string('ins_pluginname', 'local_metadata'));
$heading = 'Program Learning Objectives: ' . $course->shortname . ': ' . $course->fullname;
$PAGE->set_heading($heading);
// Create url
$base_url = new moodle_url('/local/metadata/admview_tag.php', array('categoryid' => $categoryId, 'id' => $courseId, 'program' => $programId, 'obj' => $objectiveId, 'grp' => $groupId));
$knowledge_url = create_manage_url('knowledge', $categoryId);
$policy_url = create_manage_url('policy', $categoryId);
$tag_url = create_manage_url('course', $categoryId);
$exclude_url = create_manage_url('exclude', $categoryId);
$reporting_url = create_manage_url('reporting', $categoryId);
$categories_url = create_manage_url('categories', $categoryId);
