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;
}
function get_Categories_by_grade($grade_id, $subject_id = null)
{
$My_DB = new My_Database();
$found = "";
if ($subject_id == null) {
if (isset($My_DB->get_material_category_for_grade($grade_id)['result'])) {
$Materials = $My_DB->get_material_category_for_grade($grade_id)['result'];
foreach ($Materials as $material) {
$found = $found . '<li><a href="#"><strong style="color: dimgray">' . $material['category'] . '</strong></a>' . get_Materials_by_grade_and_category($grade_id, $material['category']) . '</li>';
}
$found = '<ul>' . $found . '</ul>';
}
} else {
if (isset($My_DB->get_material_category_for_grade_and_subject($grade_id, $subject_id)['result'])) {
$Materials = $My_DB->get_material_category_for_grade_and_subject($grade_id, $subject_id)['result'];
foreach ($Materials as $material) {
$found = $found . '<li><a href="#"><strong style="color: dimgray">' . $material['category'] . '</strong></a>' . get_Materials_by_grade_and_subject_and_category($grade_id, $subject_id, $material['category']) . '</li>';
}
$found = '<ul>' . $found . '</ul>';
}
}
return $found;
}
public static function getConnect($Project, $Account, $Type)
{
//Get Ini Configuration
self::$configuration = self::getApplicationIni($Project, $Account, $Type);
//get Configuration
$arrOptions = self::$configuration->toArray();
$strKeyDB = md5($Project . $Account . $Type);
//Get storage instance
if (!isset(self::$arrStorage[$strKeyDB]) || empty(self::$arrStorage[$strKeyDB])) {
//Create object to Connect DB
self::$arrStorage[$strKeyDB] = Zend_Db::factory($arrOptions['adapter'], $arrOptions['params']);
//Changing the Fetch Mode
self::$arrStorage[$strKeyDB]->setFetchMode(Zend_Db::FETCH_ASSOC);
//Create Adapter default is Db_Table
Zend_Db_Table::setDefaultAdapter(self::$arrStorage[$strKeyDB]);
}
//Return storage
return self::$arrStorage[$strKeyDB];
}
<?php
require_once '../private/My_Database.php';
$My_DB = new My_Database();
$res = $My_DB->is_valid_user('bengeos', 'ben');
print_r($res);
<!DOCTYPE html>
<?php
require_once '../private/My_Database.php';
$My_DB = new My_Database();
?>
<html>
<head>
<title>Content Management System </title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<meta http-equiv="content-type" content="text-html; charset=utf-8">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-glyphicons.css" rel="stylesheet">
<link href="css/css/styles.css" rel="stylesheet">
<script src="js/jquery-2.0.2.js"></script>
<script src="js/modernizr-2.6.2.min.js"></script>
<script src="js/jquery.stellar.js"></script>
</head>
<body>
<div class="navbar navbar-fixed-top navbar-default" id="nav">
<div class="container" id="dd">
<button class="navbar-toggle" data-target="#dnav" data-toggle="collapse" type="button">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
