<?php require_once 'config.php'; require_once 'inc/respond.php'; $db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // connect to the DB $respond = new Respond(); // Send out JSON responses $table = 'fv_data'; if ($db->connect_errno) { $respond->fail("Failed to connect to MySQL: " . $db->connect_error); } // All setup - let's get started with handling any data. $res = $db->query("SELECT *,DATE_FORMAT(dob,'%D %M %Y') as dob_formatted FROM {$table} ORDER BY id DESC"); while ($row = $res->fetch_assoc()) { $data['results'][] = $row; } $respond->success("results", $data);
<?php require_once 'config.php'; require_once 'inc/mail.php'; require_once 'inc/respond.php'; $db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // connect to the DB $mail = new Mailer(); // handle email including validations $respond = new Respond(); // Send out JSON responses $table = 'fv_data'; if ($db->connect_errno) { $respond->fail("Failed to connect to MySQL: " . $db->connect_error); } // All setup - let's get started with handling any data. // kill the page if nothing posted if (!$_POST) { $respond->fail("error", "no data"); } #1 Sanitize and prepare the data: $comments = trim($_POST["comments"]); $day = trim($_POST["day"]); $email = trim($_POST["email"]); $firstname = trim($_POST["firstname"]); $gender = trim($_POST["gender"]); $lastname = trim($_POST["lastname"]); $month = trim($_POST["month"]); $phone = trim($_POST["phone"]); $year = trim($_POST["year"]); $errors = array();