PHP Model::Select Examples

Example #1

File: model_publisher.php Project: usfuprog/Library_ap

 public static function GetAll($conn)
 {
     return Model::Select($conn, 'Publishers', array('id', 'name'), 'Publisher');
     //        $pubs = array();
     //        $res = $conn->query("Select id, name From Publishers Order by name");
     //        while ($p = $res->fetch_object()) {
     //            $pubs[ $p->id ] = new Publisher($p->id, $p->name);
     //        }
     //        return $pubs;
 }

Example #2

File: model_author.php Project: VitalHawk/Library

 public static function GetAll($conn)
 {
     return Model::Select($conn, 'Authors', array('id', 'name', 'surname', 'birthdate'), 'Author');
 }

Example #3

File: model_author.php Project: smart-com/bike-cms

 public static function GetAll($conn)
 {
     return Model::Select($conn, 'Authors', array('ID', 'Name'), 'Author');
 }

Example #4

File: model_category.php Project: VitalHawk/Library

 public static function GetAll($conn)
 {
     return Model::Select($conn, 'Categories', array('id', 'name'), 'Category');
 }

Example #5

File: model_category.php Project: smart-com/bike-cms

 public static function GetCategory($conn, $cat_id)
 {
     return Model::Select($conn, 'Category', array('ID', $cat_id), 'Category');
 }