<?
// Configuration
require_once('shop/config.php');
// Application Classes
require_once(DIR_SYSTEM . 'library/customer.php');
require_once(DIR_SYSTEM . 'library/currency.php');
require_once(DIR_SYSTEM . 'library/tax.php');
require_once(DIR_SYSTEM . 'library/weight.php');
require_once(DIR_SYSTEM . 'library/cart.php');
// Engine
require_once(DIR_SYSTEM . 'engine/controller.php');
require_once(DIR_SYSTEM . 'engine/registry.php');
// Common
require_once(DIR_SYSTEM . 'library/config.php');
require_once(DIR_SYSTEM . 'library/db.php');
require_once(DIR_SYSTEM . 'library/session.php');
// Registry
$registry = new Registry();
// Config
$config = new Config();
$registry->set('config', $config);
// Database
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$registry->set('db', $db);
// Session
$session = new Session();
$registry->set('session', $session);
// Customer
$registry->set('customer', new Customer($registry));
// Currency
$registry->set('currency', new Currency($registry));
// Tax
$registry->set('tax', new Tax($registry));
// Weight
$registry->set('weight', new Weight($registry));
// Cart
$registry->set('cart', new Cart($registry));
require_once(DIR_APPLICATION . 'controller/module/cart.php');
$product_id = $registry->get('cart')->session->data['cart'];
$tf = false;
foreach($product_id as $p=>$val) {
if($tf) {
$sql .= 'OR p.product_id = "'.$p.'"';
}else{
$tf = true;
$sql = 'p.product_id = "'.$p.'"';
}
}
$cartSQL = mysql_query("
SELECT DISTINCT *, pd.name AS name, p.image AS image, m.name AS manufacturer, ss.name AS stock FROM " . DB_PREFIX . "product p
LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN " . DB_PREFIX . "stock_status ss ON (p.stock_status_id = ss.stock_status_id)
WHERE (" . $sql . ") AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' AND p.date_available <= NOW() AND p.status = '1'");
while($row = mysql_fetch_array($cartSQL)) {
echo $row['name'];
}
$logged = $registry->get('session')->data['customer_id'];
?>
ต้องการวนลูป
while($row = mysql_fetch_array($cartSQL)) {
echo $row['name'];
}
ใช้โค๊ดอะไรครับ คือแบบPHP ไม่รู้เรื่องครับ ลองทำแล้วไม่ได้เลยครับ
คือมันแสดงผลติดกันยาวเป็นบรรทัดเดียวกัน ผมลองใส่ .'<br>'
while($row = mysql_fetch_array($cartSQL)) {
echo $row['name'].'<br>';
}
มันก็ขึ้นบรรทัดใหม่ครับแต่อยากได้แบบแสดง
<ul>
<li> echo $row['name']; </li>
</ul>
พัฒนาเว็บไซต์
