<?php include 'db_connect.php'; if (isset($_GET['state'])) { getDatabyState(); } elseif (isset($_GET['birth_id'])) { searchById(); } elseif ($_POST['action'] == "new") { insert_child(); } elseif ($_POST['action'] == "vaccinate") { vaccinate(); } elseif ($_POST['action'] == "edit") { edit_child(); } else { insert_child(); } function getDataByState() { $state = $_GET['state']; $sql_query = "SELECT COUNT(*) AS count FROM child where state = '" . $state . "'"; $con = open_connection(); if ($result = mysqli_query($con, $sql_query)) { if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_assoc($result); $response['count'] = $row['count']; } } } function searchById() { $uniqueId = $_GET['birth_id'];
function store_data_in_db($params) { $db = get_db_handle(); $sql = "select * from parent where first_name='{$params['0']}' and secondary_phone='{$params['36']}' and email='{$params['15']}';"; $result = mysqli_query($db, $sql); if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_array($result); $parent_id = $row[0]; $sql = "select * from child where parent_id='{$parent_id}' and first_name='{$params['16']}' and birthdate='{$params['22']}' ;"; //echo "parent_id".$parent_id; $result = mysqli_query($db, $sql); if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_array($result); $child_id = $row[0]; $enrollment = 0; $program = camps($params); for ($i = 0; $i < count($program); $i++) { $sql = "select * from enrollment where program_id='{$program[$i]}' and child_id='{$child_id}';"; $result = mysqli_query($db, $sql); if (mysqli_num_rows($result) > 0) { $row = mysqli_fetch_array($result); $enrollment = 1; } } if ($enrollment == 1) { write_error_page('The child is already registered for the program selected.Click<a href="Enrollment.html"> here </a> to go back to the previous screen'); exit; } else { insert_enrollment($child_id, $params, $db); } } else { insert_child($parent_id, $params, $db); } } else { ### NOT A DUP // $sql = "Insert into parent(first_name,middle_name,last_name,address1,address2,city,state,zip,primary_phone,secondary_phone,email) values ('sdsasdf','sdasdfssa','dsd','asasdfda','dsad','fsdfs','CA',91110,2222222222,1111122222,'*****@*****.**')"; // echo "'".$params[0]."'<br>"; // echo "'".$params[1]."'<br>"; // echo "'".$params[2]."'<br>"; // echo "'".$params[3]."'<br>"; // echo "'".$params[4]."'<br>"; // echo "'".$params[5]."'<br>"; // echo "'".$params[6]."'<br>"; // echo "'".$params[7]."'<br>"; // echo "'".$params[35]."'<br>"; // echo "'".$params[36]."'<br>"; // echo "'".$params[15]."'<br>"; $sql = "insert into parent(first_name,middle_name,last_name,address1,address2,city,state,zip,primary_phone,secondary_phone,email) " . "values('{$params['0']}','{$params['1']}','{$params['2']}','{$params['4']}','{$params['5']}','{$params['6']}','{$params['7']}','{$params['8']}','{$params['35']}','{$params['36']}','{$params['15']}');"; // if(mysqli_query($db,$sql)===True) echo "success"; // else echo "No Donut"; mysqli_query($db, $sql); //$how_many = mysqli_affected_rows($db); $parent_id = mysqli_insert_id($db); //echo "parent_id in else".$parent_id; if (!empty($parent_id)) { insert_child($parent_id, $params, $db); } else { echo "A critical error occurred."; } } mysqli_close($db); }