[insert_php] session_start(); // pop_app_content_str.php date_default_timezone_set(‘America/New_York’); $copy_year = date(“Y”); $error_extra = ‘error_page.php’; $mysqli = new mysqli(‘127.0.0.1′,’tdgclien_leaders’,’Leadership_0′,’tdgclien_leadership_w’); if (mysqli_connect_errno()) { die(“Error connecting to DB”); } $query = “SELECT * FROM Application_Content WHERE Ca_Q1 >’ ‘ LIMIT 1”; $result = $mysqli->query($query); if (!$result) { mysqli_close($mysqli); $_SESSION[‘DB_ERROR’] = $user; $host = $_SERVER[‘HTTP_HOST’]; $uri = rtrim(dirname($_SERVER[‘PHP_SELF’]), ‘/\\’); $message = “Application Content Query Failed \n”; echo “$message \n”; echo “$query \n”; //exit(0); die($message); } $n = $result->num_rows; if ($n >0){ $row = $result->fetch_assoc(); $ci_str = $row[‘Ci_Text’]; $Ca_Q1_str.= $row[‘Ca_Q1’]; $Ca_Q2_str.= $row[‘Ca_Q2’]; $Ca_Q3_str.= $row[‘Ca_Q3’]; $Ca_Q4_str.= $row[‘Ca_Q4’]; $Ca_Q5_str.= $row[‘Ca_Q5’]; $Ca_Q6_str.= $row[‘Ca_Q6’]; $Ref_str.= $row[‘Ref_Text’]; $Tui_str.= $row[‘Tuition_Text’]; $Emp_str.= $row[‘Emp_Comm_Text’]; $Commitment_str.= $row[‘Commitment_Text’]; //var_dump($row); //mysqli_close($mysqli); //return; } else{ mysqli_close($mysqli); $_SESSION[‘DB_ERROR’] = “User Not in DB. \n”; $host = $_SERVER[‘HTTP_HOST’]; $uri = rtrim(dirname($_SERVER[‘PHP_SELF’]), ‘/\\’); //header(“Location: http://$host$uri/../$error_extra”); $message = “Error getting app content (2) \n”; die($message); } $The_checkbox_str = ‘  ‘; $Certify_str = ‘