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]; }
$_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']); }