<?php error_reporting(1); $host = 'localhost'; $user = '******'; $pass = '******'; $db = 'rmannava'; $load = new LoadReservations($host, $user, $pass, $db); $load->addReservations(); class LoadReservations { var $db; var $Flights; var $Meals; var $Users; var $Class; function __construct($host, $user, $pass, $db) { //connect to database on local server $this->db = new mysqli($host, $user, $pass, $db); if ($this->db->connect_errno) { echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error; } $this->Flights = array(); $this->Meals = array(); $this->Users = array(); $this->Class = array(); $this->loadFlights(); $this->loadMeals(); $this->loadUsers(); $this->loadClasses();
<?php error_reporting(1); $host = 'localhost'; $user = '******'; $pass = '******'; $db = 'vgundeti'; $load = new LoadReservations($host, $user, $pass, $db); $load->checkUser(); class LoadReservations { var $db; function __construct($host, $user, $pass, $db) { //connect to database on local server $this->db = new mysqli($host, $user, $pass, $db); if ($this->db->connect_errno) { echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error; } } function checkUser() { $email = $_POST['email']; $password = $_POST['password']; //echo $email; //echo $password; $this->getResult($email, $password); } function getResult($email, $password) { $query = "SELECT * FROM `user` WHERE email = '{$email}' and password = '******'";
<?php error_reporting(1); $host = 'localhost'; $user = '******'; $pass = '******'; $db = 'rmannava'; $load = new LoadReservations($host, $user, $pass, $db); $load->addUser(); class LoadReservations { var $db; function __construct($host, $user, $pass, $db) { //connect to database on local server $this->db = new mysqli($host, $user, $pass, $db); if ($this->db->connect_errno) { echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error; } } function addUser() { $id = $this->checkId(uniqid()); //$this->checkId($id); //echo $id; $firstname = $_POST['fn']; $lastname = $_POST['ln']; $street = $_POST['street']; $city = $_POST['city']; $state = $_POST['state']; $zip = $_POST['zip'];