【php开源代码栏目提醒】:网学会员--在 php开源代码编辑为广大网友搜集整理了:products.php绩等信息,祝愿广大网友取得需要的信息,参考学习。
<?php
require("include/comment.php");
require("include/product.class.php");
$product = new product();
/*
if(!$_COOKIE['user']['user_id']){
$product->msg('Sorry, you have not registered!<br><br><a href="register.html">new member enter here</a>');
}elseif(!$_COOKIE['user']['is_open']){
$product->msg('your information has been submitted to administrator,pls try again later.');
}
*/
$i = 0;
$sort_arr = $product->get_sort();
foreach ($sort_arr as $value){
$sort[$i] = $value;
$sort2_arr = $product->get_sort($value['id']);
$j = 0;
$sort2 = array();
foreach ($sort2_arr as $value2){
$sort2[$j] = $value2;
$sort3_arr = $product->get_sort($value2['id']);
$k = 0;
$sort3 = array();
foreach ($sort3_arr as $value3){
$sort3[$k] = $value3;
$k++;
}
$sort2[$j]['sort3'] = $sort3;
$j++;
}
$sort[$i]['sort2'] = $sort2;
$sort[$i]['number'] = $product->get_f_num($value['id']);
$i++;
}
$product->assign('sort',$sort);
$sort_id = $product->INCOME['sort_id']?$product->INCOME['sort_id']:0;
$product->assign('sort_id', $sort_id);
$f_id = $product->INCOME['f_id']?$product->INCOME['f_id']:0;
$product->assign('f_id', $f_id);
if($sort_id){
$sql = "select id from product_sort where fidlist LIKE '{$sort_id},%' OR fidlist LIKE '%,{$sort_id},%' OR id = {$sort_id}";
}else{
$sql = "select id from product_sort";
}
$rs = $product->DB->execute($sql);
$i = 0;
$arr = array();
while(!$rs->EOF()){
$row = $rs->fields;
$arr[$i] = $row['id'];
$i++;
$rs->MoveNext();
}
$sort_arr = implode(",", $arr);
$
sql = "select count(*) as num from product_products where sort_id in ({$sort_arr})";
$rs = $product->DB->execute($sql);
$row = $rs->fields;
$page_num = 9;
$st = $product->INCOME['st']?$product->INCOME['st']:0;
$pages = $product->build_pagelinks(array( 'TOTAL_POSS' => $row['num'],
'PER_PAGE' => $page_num,
'CUR_ST' => $st,
'BASE_URL' => "products.php?f_id={$f_id}&sort_id={$sort_id}"
)
);
$product -> assign( "pages" , $pages);
$sql = "select id, name, img from product_products where sort_id in ({$sort_arr}) order by product_products.orderby asc LIMIT ".$st*$page_num.','.$page_num;
$rs = $product->DB->execute($sql);
$i=0;
$arr = array();
while(!$rs->EOF()){
$row = $rs->fields;
$arr[$i] = $row;
$i++;
$rs->MoveNext();
}
$product->assign('product', $arr);
$product->assign('small_img_path', $product->up_img);
$product -> display("products.html");
?>