Пример #1
0
 public static function getByEmail($email)
 {
     $db = DB::get()->getConnection();
     $sql = "SELECT * FROM user WHERE email = :p_email";
     $stmt = $db->prepare($sql);
     myPDOexecute($stmt, array(':p_email' => $email));
     $r = $stmt->fetch(PDO::FETCH_ASSOC);
     if (!$r) {
         return false;
     }
     return $r;
 }
Пример #2
0
 public static function getById($id)
 {
     $db = DB::get()->getConnection();
     $sql = "SELECT * FROM event WHERE uid = :p_id";
     $stmt = $db->prepare($sql);
     myPDOexecute($stmt, array(':p_id' => $id));
     $r = $stmt->fetch(PDO::FETCH_ASSOC);
     if (!$r) {
         return false;
     }
     return $r;
 }