PHP Model::add_up_de Examples

Example #1

File: LevelModel.class.php Project: hachi-zzq/guest-cms

 public function Delete_Level()
 {
     $this->id = $_GET['id'];
     $sql_delete = "delete from manage_level where id='{$this->id}' limit 1";
     $affected_rows = parent::add_up_de($sql_delete);
     if ($affected_rows == 1) {
         Tool::alertLocation('删除成功', 'level.php?action=show');
     } else {
         Tool::alertBack('删除失败');
     }
 }

Example #2

File: UserModel.class.php Project: hachi-zzq/guest-cms

 public function Update_User()
 {
     if ($this->password == null) {
         $sql = "update\r\n\t\t\t\t\t\t\t\t\t\tuser\r\n\t\t\t\t\t\tset\r\n\t\t\t\t\t\t\t\tface='{$this->face}',\r\n\t\t\t\t\t\t\t\tquestion='{$this->question}',\r\n\t\t\t\t\t\t\t\tanswer='{$this->answer}',\r\n\t\t\t\t\t\t\t\temail='{$this->email}',\r\n\t\t\t\t\t\t\t\tstate='{$this->state}'\r\n\t\t\t\t\t\t\twhere id='{$this->id}'";
     } else {
         $sql = "update\r\n\t\t\t\t\t\t\t\t\t\tuser\r\n\t\t\t\t\t\tset\r\n\t\t\t\t\t\t\t\tpassword=sha1('{$this->password}'),\r\n\t\t\t\t\t\t\t\tface='{$this->face}',\r\n\t\t\t\t\t\t\t\tquestion='{$this->question}',\r\n\t\t\t\t\t\t\t\tanswer='{$this->answer}',\r\n\t\t\t\t\t\t\t\temail='{$this->email}',\r\n\t\t\t\t\t\t\t\tstate='{$this->state}'\r\n\t\t\t\t\t\t\t\twhere id='{$this->id}'";
     }
     return parent::add_up_de($sql);
 }

Example #3

File: CommentModel.class.php Project: hachi-zzq/guest-cms

 public function oppose()
 {
     $sql = "update comment set oppose = oppose-1 where id ='{$this->id}'";
     return parent::add_up_de($sql);
 }

Example #4

File: RotatainModel.class.php Project: hachi-zzq/guest-cms

 public function Del_Rotatain()
 {
     $sql = "delete from rotatain where id='{$this->id}'";
     return parent::add_up_de($sql);
 }

Example #5

File: ManageModel.class.php Project: hachi-zzq/guest-cms

 public function deleteManage()
 {
     $this->id = $_GET['id'];
     $sql_delete = "delete from manage where id='{$this->id}' limit 1";
     $affected_rows = parent::add_up_de($sql_delete);
     if ($affected_rows == 1) {
         Tool::alertLocation('删除管理员成功', 'manage.php?action=show');
     } else {
         Tool::alertBack('删除管理员失败');
     }
 }

Example #6

File: ContentModel.class.php Project: hachi-zzq/guest-cms

 public function Detail_Comment()
 {
     $sql = "update content set comment=(select count(id) from comment where cid='{$this->cid}') where id='{$this->cid}'";
     return parent::add_up_de($sql);
 }