Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require_once "config/db.php";
- class mPoll {
- public $id;
- public $name;
- public $status;
- private $result;
- // Вытаскиваем опросы с тем или иным статуом в массив
- public function m_get_poll($status) {
- $sql = "SELECT * FROM `poll` WHERE `status` = '$status'";
- $this->result = Db::sql($sql);
- $this->m_next();
- return $this->result;
- }
- // Выводим опрос по заданному id
- public function m_next() {
- $result = mysql_fetch_assoc($this->result);
- if($result){
- $this->id = $result['id'];
- $this->name = $result['name'];
- $this->status = $result['status'];
- }
- return $result;
- }
- // Функция добавления опроса на сайт
- public function add(){
- $sql = "INSERT INTO `poll` (`name`, `status`) VALUES ('{$this->name}', '{$this->status}')";
- $result = Db::sql($sql);
- $this->id = mysql_insert_id();
- return $result;
- }
- // Формируем опрос для редактирования
- public function upd(){
- $sql = "UPDATE `poll` SET `name` = '{$this->name}', `status` = '{$this->status}' WHERE id = '{$this->id} '";
- $result = Db::sql($sql);
- return true;
- }
- // Удаление опроса
- public function del(){
- $sql = "DELETE FROM `poll` WHERE id = '{$this->id}'";
- $result = Db::sql($sql);
- return true;
- }
- // Выводим опрос по заданному id
- public function view($id) {
- $sql = "SELECT `id`, `name`, `status` FROM `poll` WHERE `id`='$id'";
- $result = Db::sql($sql);
- $this->m_next();
- return $this->result;
- }
- public function get() {
- $sql = "SELECT * FROM `poll`";
- $this->result = Db::sql($sql);
- $this->m_next();
- return $this->result;
- }
- public function s_p() {
- $sql = "SELECT COUNT(*) FROM `poll` WHERE `status`='active'";
- $result = Db::sql($sql);
- $row = mysql_fetch_row($result);
- $total = $row[0];
- return $total;
- }
- public function u_p(){
- $sql = "UPDATE `poll` SET `status`='active' WHERE `id` = '{$this->id}'";
- $result = Db::sql($sql);
- return true;
- }
Add Comment
Please, Sign In to add comment