PHP CRUD::obtain示例

 public function get_rating($productID)
 {
     $sql = '
     SELECT DISTINCT AVG(rating) AS  customers_rating , COUNT(*) AS customer_votes
     FROM ' . REVIEWS_TABLE . '
     WHERE productID = ' . $productID . ' AND approve=1';
     $c = CRUD::obtain();
     $result = $c->query($sql);
     return $result[0];
 }

示例#2

显示文件

文件： index.php 项目： gblok/rsc

$_GET = xStripSlashesGPC($_GET);
$_COOKIE = xStripSlashesGPC($_COOKIE);
db_connect(DB_HOST, DB_USER, DB_PASS) or die(ERROR_DB_INIT);
db_select_db(DB_NAME) or die(db_error());
settingDefineConstants();
// Friendly URLs module
//include('url_rewriter.php');
$alias = new Router();
//     $alias->import (Alias::MODULE_PAGE);
//     $alias->import (Alias::MODULE_CATEGORY);
//     $alias->import (Alias::MODULE_PRODUCT);
//$alias->generate_query();
include "core/config/headers.php";
include "core/config/error_handler.php";
//CRUD
$crud = CRUD::obtain('localhost', DB_USER, DB_PASS, DB_NAME);
function set_cookie($Name, $Value = '', $Expires = '', $Secure = false, $Path = '', $Domain = '', $HTTPOnly = false)
{
    header('Set-Cookie: ' . rawurlencode($Name) . '=' . rawurlencode($Value) . (empty($Expires) ? '' : '; expires=' . gmdate('D, d-M-Y H:i:s', $Expires) . ' GMT') . (empty($Path) ? '' : '; path=' . $Path) . (empty($Domain) ? '' : '; domain=' . $Domain) . (!$Secure ? '' : '; secure') . (!$HTTPOnly ? '' : '; HttpOnly'), false);
}
# стартуем сессию
define("SECURITY_EXPIRE", 60 * 60 * CONF_SECURITY_EXPIRE);
session_set_save_handler("sess_open", "sess_close", "sess_read", "sess_write", "sess_destroy", "sess_gc");
session_start();
# посылаем cookie сессии
if (isset($_COOKIE['PHPSESSID'])) {
    if (SECURITY_EXPIRE > 0) {
        set_cookie('PHPSESSID', $_COOKIE['PHPSESSID'], time() + SECURITY_EXPIRE);
    } else {
        set_cookie('PHPSESSID', $_COOKIE['PHPSESSID']);
    }