public static function add($uid, $pid) { $db = Db::getConection(); $stmt = $db->prepare("INSERT INTO us_post (uid, pid)\nVALUES (:uid, :pid)"); $res = $stmt->execute(array(':uid' => $uid, ':pid' => $pid)); return $res; }
public static function dellFree($uid, $date) { $db = Db::getConection(); $stmt = $db->prepare("DELETE FROM `freemen` WHERE `uid` = :uid AND `date` = :date"); $res = $stmt->execute(array('uid' => $uid, 'date' => $date)); return $res; }
public static function updateUsersByParam($pole, $val, $oid) { $db = Db::getConection(); $res = $db->prepare('UPDATE `users` SET `' . $pole . '`=:val WHERE `id`=:oid'); $answer = $res->execute(array(':val' => $val, ':oid' => $oid)); return $answer; }
public static function addMounting($oid, $uid, $datedb) { $db = Db::getConection(); $res = $db->prepare('INSERT INTO `mounting`(`oid`,`uid`,`m_date`) VALUES (:oid, :uid, :date)'); $answer = $res->execute(array(':oid' => $oid, ':uid' => $uid, ':date' => $datedb)); echo $uid; return $answer; }
public static function getPosts() { $db = Db::getConection(); $res = $db->prepare('SELECT * FROM `posts`'); $res->execute(); $res->setFetchMode(PDO::FETCH_ASSOC); while ($row = $res->fetch()) { $posts[$row['id']] = $row['list']; } return $posts; }
public static function getAllDillers() { $db = Db::getConection(); $userList = array(); $res = $db->prepare('SELECT * FROM `dillers`'); $res->execute(); $res->setFetchMode(PDO::FETCH_ASSOC); while ($row = $res->fetch()) { $userList[] = $row; } return $userList; }
public static function getSamples() { $db = Db::getConection(); $list = array(); $res = $db->prepare('SELECT * FROM `sample_sms`'); $res->execute(); $res->setFetchMode(PDO::FETCH_ASSOC); while ($row = $res->fetch()) { $list[$row['id']] = $row; } return $list; }
public static function getClaimsNoSum() { $db = Db::getConection(); $orderList = array(); $res = $db->prepare(' SELECT `oid`, `contract`, `sum`, (SELECT `name` FROM `users` WHERE `users`.`id` = `orders`. `technologist`) AS `tech` FROM `orders` , `order_stan` WHERE `contract` REGEXP \'^.*[РД][1-9]?$\' AND `orders`.`id` = `order_stan`.`oid` AND `orders`.`sum` < 1000 AND `order_stan`.`otgruz_end`!= \'2\' '); $res->execute(); $res->setFetchMode(PDO::FETCH_ASSOC); while ($row = $res->fetch()) { $orderList[] = $row; } return $orderList; }
public static function setNote($oid, $note) { $db = Db::getConection(); $res = $db->prepare("\nINSERT INTO `notes` (`oid`, `note` , `date`)\nVALUES (:oid, :note, CURDATE())\n\t "); $res->execute(array('oid' => $oid, 'note' => $note)); }