public static function getall($params) { $params = array_merge(array("category_id" => null, "order" => null, "limit" => null, "offset" => null), $params); $params["limit"] = $params["limit"] ? (int) $params["limit"] : 20; $params["offset"] = $params["offset"] ? (int) $params["offset"] : 0; switch ($params["order"]) { case 1: $strOrder = " ORDER BY m.id DESC "; break; case 2: $strOrder = " ORDER BY m.id ASC "; break; case 3: $strOrder = " ORDER BY l.count DESC "; case 4: $strOrder = " ORDER BY l.count ASC "; break; default: $strOrder = " ORDER BY m.id DESC "; break; } $objDB = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $objDB->prepare("\n SELECT m.id, m.name, l.count FROM truyenmain m \n LEFT JOIN (SELECT truyen_id, COUNT(id) count FROM truyenlike GROUP BY truyen_id) l ON m.id = l.truyen_id\n WHERE TRUE\n AND if(:category_id IS NOT NULL AND :category_id != '', FIND_IN_SET(:category_id,m.category), TRUE)\n " . $strOrder . "\n LIMIT :limit\n OFFSET :offset\n "); $stmt->bindParam("category_id", $params["category_id"], PDO::PARAM_STR); $stmt->bindParam("limit", $params["limit"], PDO::PARAM_INT); $stmt->bindParam("offset", $params["offset"], PDO::PARAM_INT); $stmt->execute(); $arrData = $stmt->fetchAll(); unset($objDB, $stmt); return $arrData; }
public static function getall($params) { $objDB = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $objDB->prepare("SELECT * FROM truyencategory WHERE active = 1"); $stmt->execute(); $arrData = $stmt->fetchAll(); unset($objDB, $stmt); return $arrData; }
public static function get_count_img_cat_by_id($id_cat) { $db = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $db->prepare("SELECT COUNT(*) as total_row FROM quotes WHERE FIND_IN_SET('" . $id_cat . "',quotes.category)"); $stmt->execute(); $arrData = $stmt->fetchAll(); unset($stmt, $db); return $arrData; }
public static function delete($params) { $params = array_merge(array("id" => null), $params); $db = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $db->prepare("DELETE FROM truyencategory WHERE `id` = :id"); $stmt->bindParam("id", $params["id"], PDO::PARAM_INT); $result = $stmt->execute(); unset($stmt, $db); return $result; }
public static function getbyusername($params) { $params = array_merge(array('username' => null), $params); $db = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $db->prepare("SELECT * FROM users WHERE username = :username"); $stmt->bindParam("username", $params["username"], PDO::PARAM_STR); $stmt->Execute(); $arrData = $stmt->fetch(); unset($stmt, $db); return $arrData; }
public static function sendlike($params) { $params = array_merge(array("like_id" => null, "truyen_id" => null), $params); $objDB = My_Database::getConnect("tgst", "tgst", "master"); $stmt = $objDB->prepare("INSERT IGNORE INTO truyenlike (like_id,truyen_id) VALUES (:like_id,:truyen_id)"); $stmt->bindParam("like_id", $params["like_id"], PDO::PARAM_STR); $stmt->bindParam("truyen_id", $params["truyen_id"], PDO::PARAM_STR); $result = $stmt->execute(); unset($objDB, $stmt); return $result; }