PHP Model::fetchOne Examples

Example #1

File: AdminModel.class.php Project: denglitong/tice

 public function checkLogin()
 {
     $sql = "SELECT * FROM tice_admin\n                  WHERE name = :name\n                  AND password = :password";
     $params = array(':name' => $this->name, ':password' => $this->password);
     //使用pdo的函数，可过滤sql注入，安全
     return parent::fetchOne($sql, $params);
 }

Example #2

File: AttributesModel.class.php Project: denglitong/tice

 public function getConfig()
 {
     $sql = "SELECT * FROM tice_config LIMIT 1";
     return parent::fetchOne($sql);
 }

Example #3

File: UserModel.class.php Project: denglitong/tice

 public function search()
 {
     $sql = "SELECT * FROM `{$this->tableName}` WHERE stuId = '{$this->stuId}' LIMIT 1";
     return parent::fetchOne($sql);
 }