Easy Ticket : User
// include custom functions
include "../config/functions.php";
// if tracking button clicked
if (isset($_POST["track_submit"])) {
// run custom function to clean email and ticket number fields
$email = form_field_clean($_POST["track_email"], TRUE);
// set db variable
$db = db_connect();
// select ticket where email and ticket id match ticket in database
$check_tracking = mysqli_query($db, "SELECT ID, User_Email FROM $mysql_ticket WHERE User_Email = '$email'");
// count returned tickets for checking
$valid_entry = mysqli_num_rows($check_tracking);
// check for empty fields
if ($email == "") {
$track_error = "! Direccion de Email requerido";
// check for valid email
} else if (form_validate ("EMAIL", $email) === TRUE) {
$track_error = "! Direccion de Email invalida";
// check ticket no is numeric
// check if email and ticket number entered are valid from mysql check
} else if ($valid_entry == 0) {
$track_error = "! La direccion de Mail no fue encontrada";
}
// if no errors then show ticket details
if (!isset($track_error)) {
header("Location: lista_tickets.php?email=".$email."");
}
}
?>
include "inc.header.php";
?>