PHP Model::fetch Examples

Example #1

File: booking.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function byId($id)
 {
     $sql = "SELECT\n\t\t\t\t\tb.*\n\t\t\t\tFROM\n\t\t\t\t\tbookings b\n\t\t\t\tWHERE\n\t\t\t\t\tb.id = ?";
     return Model::fetch($sql, __CLASS__, $id);
 }

Example #2

File: user.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function checkUser($email, $password)
 {
     $sql = "SELECT\n\t\t\t\t\tu.*\n\t\t\t\tFROM\n\t\t\t\t\tusers u\n\t\t\t\tWHERE\n\t\t\t\t\tu.email = ? AND\n\t\t\t\t\tu.password = ?";
     $data = array($email, md5($password));
     return Model::fetch($sql, __CLASS__, $data);
 }

Example #3

File: room.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function byId($id)
 {
     $sql = "SELECT\n\t\t\t\t\tr.*,\n\t\t\t\t\tl.*\n\t\t\t\tFROM\n\t\t\t\t\trooms r, rooms_lang l\n\t\t\t\tWHERE\n\t\t\t\t\tr.id = l.id AND l.id_lang = " . ID_LANG . " AND r.id = ?";
     return Model::fetch($sql, __CLASS__, $id);
 }

Example #4

File: cms.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function byName($name)
 {
     $sql = "SELECT\n\t\t\t\t\tc.*,\n\t\t\t\t\tl.*\n\t\t\t\tFROM\n\t\t\t\t\tcms c, cms_lang l\n\t\t\t\tWHERE\n\t\t\t\t\tc.id = l.id AND l.id_lang = " . ID_LANG . " AND c.name = ?";
     return Model::fetch($sql, __CLASS__, $name);
 }

Example #5

File: physicalroom.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function byId($id)
 {
     $sql = "SELECT\n\t\t\t\t\tr.*\n\t\t\t\tFROM\n\t\t\t\t\tphysicalrooms r\n\t\t\t\tWHERE\n\t\t\t\t\tr.id = ?";
     return Model::fetch($sql, __CLASS__, $id);
 }

Example #6

File: language.php Project: erseco/ugr_sistemas_de_informacion_basados_en_web

 public static function byId($id)
 {
     $sql = "SELECT\n                    l.*\n                FROM\n                    languages l\n                WHERE\n                    l.id = ?";
     return Model::fetch($sql, __CLASS__, $id);
 }