PHP DbConnect::get方法代码示例

 private function getContacts()
 {
     $this->table = 'contacts';
     //Select query
     $this->query_string = "SELECT * FROM %s WHERE user_id = '%s'";
     //Package array for query arguments
     $this->packageArguments();
     //Connect to database
     $this->db = DbConnect::get();
     //Query db
     $this->result = $this->db->query($this->query_string, $this->arguments);
     //Reset Session
     $this->contacts_array = array();
     //Turn result into associative array
     if (mysql_num_rows($this->result)) {
         while ($this->contacts = mysql_fetch_array($this->result, MYSQL_ASSOC)) {
             $this->contact = array('contact_id' => $this->contacts['id'], 'first_name' => $this->contacts['first_name'], 'last_name' => $this->contacts['last_name'], 'phone_one' => $this->contacts['phone_one'], 'phone_two' => $this->contacts['phone_two'], 'phone_three' => $this->contacts['phone_three'], 'email' => $this->contacts['email'], 'company' => $this->contacts['company'], 'address_one' => $this->contacts['address_one'], 'address_two' => $this->contacts['address_two'], 'city' => $this->contacts['city'], 'state' => $this->contacts['state'], 'zip_code' => $this->contacts['zip_code'], 'notes' => $this->contacts['notes']);
             array_push($this->contacts_array, $this->contact);
         }
         return $this->contacts_array;
     } else {
         $this->error_message = "You have No Contacts";
         return $this->error_message;
     }
 }

 public function __construct()
 {
     $this->user_name = $_SESSION['current_user'];
     //Connect to database
     $this->db = DbConnect::get();
     //$this->endConvo();
     //$this->deleteMessages();
     $this->logout();
     $this->endSession();
 }

 private function handleInfo()
 {
     //If no errors, query db
     if (!isset($this->error_message)) {
         //Update query
         $this->query_string = "UPDATE %s SET first_name = '%s', last_name = '%s', phone_one = '%s', phone_two = '%s', phone_three = '%s', email = '%s', company = '%s', address_one = '%s', address_two = '%s', city = '%s', state = '%s', zip_code = '%s', notes = '%s', user_id = '%s' WHERE id = '%s';";
         //Package array for query arguments
         $this->packageEditArguments();
         //Connect to database
         $this->db = DbConnect::get();
         //call query method
         $this->result = $this->db->query($this->query_string, $this->arguments);
         $this->return_array = array('id' => $this->real_contact_id, 'errorMessage' => NULL);
         //If errors, set session and redirect
     } else {
         $this->return_array = array('id' => $this->real_contact_id, 'errorMessage' => $this->error_message);
     }
 }

 private function handleInfo()
 {
     //If no errors, query db
     if (!isset($this->errorMsg)) {
         $this->first_name = $this->postArray['First Name'];
         $this->user_name = $this->postArray['User Name'];
         $this->password = $this->postArray['Password'];
         $this->table = "users";
         $this->logged_in = "0";
         //Encrypt login
         $this->encryptLogin();
         //Select query
         $this->query_string = "SELECT * FROM %s WHERE user_name = '%s'";
         //Package array for query arguments
         $this->packageArguments();
         //Connect to database
         $this->db = DbConnect::get();
         //call query method
         $this->result = $this->db->query($this->query_string, $this->arguments);
         //Turn result into associative array
         $this->line = mysql_fetch_array($this->result, MYSQL_ASSOC);
         //Check to see if user name already exists and redirect, else create new user
         if ($this->line) {
             $this->errorMsg .= 'User Name Already Exists';
             $_SESSION['error'] = $this->errorMsg;
             header("Location: ../index.php");
         } else {
             //Select query
             $this->query_string = "INSERT INTO %s (first_name, user_name, password, logged_in) VALUES('%s', '%s', '%s', '%s');";
             //Package array for query arguments
             $this->packageInsertArguments();
             //call query method
             $this->result = $this->db->query($this->query_string, $this->arguments);
             $this->errorMsg .= 'Account Created, Please Log in';
             $_SESSION['error'] = $this->errorMsg;
             header("Location: ../index.php");
         }
         //If errors, set session and redirect
     } else {
         $_SESSION['error'] = $this->errorMsg;
         header("Location: ../index.php");
     }
 }

 public function __construct()
 {
     $this->user_name = $_POST['userName'];
     $this->password = $_POST['password'];
     $this->table = "users";
     //Connect to database
     $this->db = DbConnect::get();
     //Call validate method
     $this->validate();
     //Encrypt login
     $this->encryptLogin();
     //Select query
     $this->query_string = "SELECT * FROM %s WHERE user_name = '%s' AND password = '%s'";
     //$this->selectQuery("SELECT * FROM %s WHERE user_name = '%s' AND password = '%s'");
     //Package array for query arguments
     $this->packageArguments();
     //call query method
     $this->result = $this->db->query($this->query_string, $this->arguments);
     //
     $this->handleResults();
 }

 private function handleInfo()
 {
     //If no errors, query db
     if (!isset($this->error_message)) {
         $this->first_name = $_POST['firstName'];
         $this->last_name = $_POST['lastName'];
         $this->phone_one = $_POST['phone1'];
         $this->phone_two = $_POST['phone2'];
         $this->phone_three = $_POST['phone3'];
         $this->email = $_POST['email'];
         $this->company = $_POST['company'];
         $this->address_one = $_POST['address1'];
         $this->address_two = $_POST['address2'];
         $this->city = $_POST['city'];
         $this->state = $_POST['state'];
         $this->zip_code = $_POST['zipCode'];
         $this->notes = $_POST['notes'];
         $this->table = "contacts";
         //Insert query
         $this->query_string = "INSERT INTO %s (first_name, last_name, phone_one, phone_two, phone_three, email, company, address_one, address_two, city, state, zip_code, notes, user_id) VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');";
         //Package array for query arguments
         $this->packageInsertArguments();
         //Connect to database
         $this->db = DbConnect::get();
         //call query method
         $this->result = $this->db->query($this->query_string, $this->arguments);
         //Grab last id from inserted row
         //$this->contact_id = mysql_insert_id();
         //Check to see if user name already exists and redirect, else create new user
         if ($this->result) {
             //Select query
             $this->query_string = "SELECT * FROM %s WHERE user_id = %s ORDER BY id DESC LIMIT 1;";
             //Package array for query arguments
             $this->packageSelectArguments();
             //Connect to database
             $this->db = DbConnect::get();
             //call query method
             $this->result = $this->db->query($this->query_string, $this->arguments);
             $this->line = mysql_fetch_array($this->result, MYSQL_ASSOC);
             $this->contact_id = $this->line['id'];
             $this->return_array = array('id' => $this->contact_id, 'data' => $this->line, 'errorMessage' => NULL);
         } else {
             $this->error_message = 'Unable to add contact';
             $this->return_array = array('id' => $this->contact_id, 'errorMessage' => $this->error_message);
         }
         //If errors, set session and redirect
     } else {
         $this->return_array = array('id' => $this->contact_id, 'errorMessage' => $this->error_message);
     }
 }