<?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();
