PHP Database::Where Examples

Example #1

File: User.php Project: jobsbe7/PokeDev

 static function GetUsers()
 {
     if (Authentication::IsLogged()) {
         $id = Session::Get('current_user')->Get('id');
     }
     $db = new Database();
     $users = array();
     $db->Select();
     if (isset($id)) {
         $db->Where('id', $id, '!=');
     }
     $result = $db->Get(Config::Get('db.table'));
     if ($result) {
         foreach ($result as $value) {
             $users[] = new User($value);
         }
         return $users;
     }
     return false;
 }

Example #2

File: database.php Project: h3rb/page

 public function Delete($table, $where_clause, $prepared = "")
 {
     if (!is_array($where_clause)) {
         plog("HEY YOU DIDN'T MEAN TO DELETE EVERYTHING, RIGHT? (->Delete() requires array())");
         return FALSE;
     }
     $query = "DELETE FROM " . $table;
     if (is_array($where_clause)) {
         $query .= Database::Where($where_clause);
     } else {
         if (!empty($where_clause)) {
             $query .= " WHERE " . $where_clause;
         }
     }
     $this->result = $this->Run($query, $prepared);
     return $this->result;
 }