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; }
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; }