我有一个 PHP 页面,用于检索我的数组中的数组$_SESSION['products']
会议。该会话中的每个数组都是用户通过以下方式添加到其“购物车”中的产品:catalogue.php
页。目前我的会话有 11 个阵列,这意味着我已将 11 个产品添加到购物车。我现在尝试在我的设备上显示数组view_cart.php
页,并按十分页。基本上我希望页面显示前十个数组,然后显示第十一个数组view_cart.php?Page=2
。现在,代码一次在页面上显示所有 11 个数组,并在每个数组之前显示三个错误消息。我已经发布了下面的错误。
警告:mssql_query() [function.mssql-query]:消息:不正确
'OFFSET' 附近的语法。 (严重程度 15)
D:\Hosting\4502990\html\partscatalogue\view_cart4.php 第 63 行
警告:mssql_query() [function.mssql-query]:消息:无效用法
FETCH 语句中的 NEXT 选项。 (严重程度 15)
D:\Hosting\4502990\html\partscatalogue\view_cart4.php 第 63 行
警告:mssql_query() [function.mssql-query]:查询失败
D:\Hosting\4502990\html\partscatalogue\view_cart4.php 第 63 行
警告:mssql_fetch_object():提供的参数不是有效的 MS
SQL 结果资源位于
D:\Hosting\4502990\html\partscatalogue\view_cart4.php 第 64 行
这是我的完整 PHP 页面代码view_cart.php
page:
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
session_start();
include_once("config.php");
$cart_items = 0;
foreach ($_SESSION['products'] as $cart_itm)
{
$cart_items ++;
}
$Number_of_Arrays = $cart_items;
echo "Number of Arrays: ".$Number_of_Arrays."";
$Per_Page = 10; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Number_of_Arrays<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Number_of_Arrays % $Per_Page)==0)
{
$Num_Pages =($Number_of_Arrays/$Per_Page) ;
}
else
{
$Num_Pages =($Number_of_Arrays/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$Page_End = $Per_Page * $Page;
IF ($Page_End > $Number_of_Arrays)
{
$Page_End = $Number_of_Arrays;
}
?>
<?php
if(isset($_SESSION["products"]))
{
$total = 0;
echo '<form method="post" action="PAYMENT-GATEWAY">';
echo '<ul>';
$cart_items = 0;
$i = 0;
foreach ($_SESSION['products'] as $cart_itm)
{
$product_code = $cart_itm["code"];
$queryy = "SELECT TOP 1 product_name,product_desc, price FROM products ORDER BY id OFFSET (($Page - 1) * $Per_Page) FETCH NEXT $Per_Page ONLY";
$results = mssql_query($queryy, $mysqli);
$obj = mssql_fetch_object($results);
echo '<li class="cart-itm">';
echo '<span class="remove-itm"><a href="cart_update.php?removep='.$cart_itm["code"].'&return_url='.$current_url.'">×</a></span>';
echo '<div class="p-price">'.$currency.$obj->price.'</div>';
echo '<div class="product-info">';
echo '<h3>'.$obj->product_name.' (Code :'.$product_code.')</h3> ';
echo '<div class="p-qty">Qty : '.$cart_itm["qty"].'</div>';
echo '<div>'.$obj->product_desc.'</div>';
echo '</div>';
echo '</li>';
$subtotal = ($cart_itm["price"]*$cart_itm["qty"]);
$total = ($total + $subtotal);
echo '<input type="hidden" name="item_name['.$cart_items.']" value="'.$obj->product_name.'" />';
echo '<input type="hidden" name="item_code['.$cart_items.']" value="'.$product_code.'" />';
echo '<input type="hidden" name="item_desc['.$cart_items.']" value="'.$obj->product_desc.'" />';
echo '<input type="hidden" name="item_qty['.$cart_items.']" value="'.$cart_itm["qty"].'" />';
$cart_items ++;
}
echo '</ul>';
echo '<span class="check-out-txt">';
echo '<strong>Total : '.$currency.$total.'</strong> ';
echo '</span>';
echo '</form>';
echo '<a href="checkout.php">Checkout</a>';
}
?>
</body>
</html>
这是我的config.php
页面完整代码:
<?php
$mysqli = mssql_connect('dag','gfa','dca');
$objConnectee = mssql_select_db('gba',$mysqli );
?>
感谢您的任何帮助。感谢所有帮助。