商品交易
商品互换
<?php define('GW_UPLOADPATH','image/');
define('MAX_FILE_SIZE','3276800');
define('HOST','localhost');
define('USER','root');
define('PASSWORD','luYI90King90');
define('NAME','aliendatabase');
if(isset($_GET['cf']))
$cf=$_GET['cf'];
$dbc=mysqli_connect(HOST,USER,PASSWORD,NAME);
$sql="select * from b";
$query=mysqli_query($dbc,$sql);
$all_num=mysqli_num_rows($query); //总条数
$page_num=3; //每页条数
$page_all_num = ceil($all_num/$page_num); //总页数
$page=empty($_GET['page'])? 1 : $_GET['page']; //当前页码为'$page'
$page=(int)$page; //安全强制转换
$limit_st = ($page-1) * $page_num; //起始数
//=================================================
$sql="select * from b limit $limit_st , $page_num";
$result=mysqli_query($dbc,$sql);
while($row=mysqli_fetch_array($result))//必须用'$result'作为函数的参数
{
if( $cf=='trade' &&is_file(GW_UPLOADPATH.$row['st'])&&filesize
(GW_UPLOADPATH.$row['st'])>0) {
echo'Date:'. $row['date'].'
'; echo'Name:'. $row['name'].'
'; echo'Score:'. $row['score'].'
'; echo ''.'
'; } else echo 'It is ERROR ! '; } $px = $page>=$page_all_num ? $page_all_num : $page+1 ; $p1=$page+2; $p2=$page+3; $p3=$page+4; mysqli_close($dbc); if($cf=='trade'){ ?> 首页 | [<?php echo $px?>] | [<?php echo $p1?>] | [<?php echo $p2?>] | [<?php echo $p3?>] | .....尾页 <?php } ?>
'; echo'Name:'. $row['name'].'
'; echo'Score:'. $row['score'].'
'; echo ''.'
'; } else echo 'It is ERROR ! '; } $px = $page>=$page_all_num ? $page_all_num : $page+1 ; $p1=$page+2; $p2=$page+3; $p3=$page+4; mysqli_close($dbc); if($cf=='trade'){ ?> 首页 | [<?php echo $px?>] | [<?php echo $p1?>] | [<?php echo $p2?>] | [<?php echo $p3?>] | .....尾页 <?php } ?>
<?php if(isset($_GET['cf']))
$cf=$_GET['cf'];
$dbc=mysqli_connect(HOST,USER,PASSWORD,NAME);
$sql="select * from b";
$query=mysqli_query($dbc,$sql);
$all_num=mysqli_num_rows($query); //总条数
$page_num=3; //每页条数
$page_all_num = ceil($all_num/$page_num); //总页数
if(empty($_GET['page']))
$page= 1 ;
else
$page=$_GET['page'];
$page=(int)$page; //安全强制转换
$limit_st = ($page-1) * $page_num; //起始数
//=================================================
$sql="select * from b limit $limit_st , $page_num";
$result=mysqli_query($dbc,$sql);
while($row=mysqli_fetch_array($result))//必须用'$result'作为函数的参数
{
if( $cf=='change' && is_file(GW_UPLOADPATH.$row
['st'])&&filesize(GW_UPLOADPATH.$row['st'])>0) {
echo'Date:'. $row['date'].'
'; echo'Name:'. $row['name'].'
'; echo'Score:'. $row['score'].'
'; echo ''.'
'; } else echo 'It is ERROR ! '; } $px = $page>=$page_all_num ? $page_all_num : $page+1 ; $p1=$page+2; $p2=$page+3; $p3=$page+4; mysqli_close($dbc); if($cf=='change'){ ?> 首页 | [<?php echo $px?>] | [<?php echo $p1?>] | [<?php echo $p2?>] | [<?php echo $p3?>] | .....尾页 <?php } ?>
'; echo'Name:'. $row['name'].'
'; echo'Score:'. $row['score'].'
'; echo ''.'
'; } else echo 'It is ERROR ! '; } $px = $page>=$page_all_num ? $page_all_num : $page+1 ; $p1=$page+2; $p2=$page+3; $p3=$page+4; mysqli_close($dbc); if($cf=='change'){ ?> 首页 | [<?php echo $px?>] | [<?php echo $p1?>] | [<?php echo $p2?>] | [<?php echo $p3?>] | .....尾页 <?php } ?>