<?php
header ( "Content-type: text/html; charset=UTF-8" );
include ("../layouts/_header.php");
include ("../../conn/conn.php");
?>
<body>
<div class="div1">
<div>
<img src="../images/biaotu.jpg" width="100%">
</div>
<div class="div2">
<div class="i_button">
<input type="button" name="need" value="查看需求" onclick="location.href='showNeed_view.php?type=all'" class="i_btn-info" onmouseover="this.style.backgroundColor='#8addde'" onmouseout="this.style.backgroundColor=''">
</div>
<div class="i_button">
<input type="button" name="unused" value="我的闲置" onclick="location.href='goodsList_view.php'" class="i_btn-info" onmouseover="this.style.backgroundColor='#8addde'" onmouseout="this.style.backgroundColor=''">
</div>
<div class="i_button">
<input type="button" name="need" value="我的需求" onclick="location.href='needList_view.php'" class="i_btn-info" onmouseover="this.style.backgroundColor='#8addde'" onmouseout="this.style.backgroundColor=''">
</div>
<div class="div3">
<a href="showGoods_view.php?type=tool"><img src="../images/tools.jpg"></a>
<a href="showGoods_view.php?type=sports"><img src="../images/sports.jpg"></a>
</div>
<div >
<a href="showGoods_view.php?type=cloths"><img src="../images/apparel.jpg"></a>
<a href="showGoods_view.php?type=book"><img src="../images/books.jpg"></a>
<a href="showGoods_view.php?type=all"><img src="../images/viewall.jpg" width="21%" height="34%"></a>
</div>
</div>
<div class="div4">
<center> <label>------------------------------最新闲置------------------------------</label></center>
<table frame="box" rules="all" style="background:#dbf9e8">
<tr>
<td>
<?php
$sql=mysqli_query($conn,"select * from tb_goods where number >0 order by goodsId desc limit 0,1");
$info=mysqli_fetch_array($sql);
if($info==false){
echo "暂无推荐产品!";
}
else {
?>
<table width="270" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="130" rowspan="5">
<div align="center">
<?php
if(trim($info['img']=="")){
echo '<img src="../images/hulu.png" width="80" height="80" border="0">';
echo "<br>暂无图片";
}
else{
?>
<img src="<?php echo $info['img'];?>" width="80" height="80" border="0">
<?php
}
?>
</div>
</td>
<td width="11" height="16"> </td>
<td width="124"><font color="FF6501"> <?php echo $info['goodsname'];?></font></td>
</tr>
<tr>
<td height="16"> </td>
<td><font color="#000000">商品价格：</font><font color="FF6501"><?php echo $info['price'];?></font></td>
</tr>
<tr>
<td height="16"> </td>
<td><font color="#000000">商品数量：</font><font color="FF6501"><?php echo $info['number'];?></font></td>
</tr>
<tr>
<td height="50" colspan="2">
<a href="showGoodsInfo_view.php?goodsId='<?php echo $info['goodsId']; ?>'"><input type="button" value="查看详情" /></a>
<a href="order_view.php?goodsId='<?php echo $info['goodsId']?>'"><input type="button" value="购买" /></a>
</td>
</tr>
</tr>
</table>
<?php
}
?>
</td>
<td>
<?php
$sql=mysqli_query($conn,"select * from tb_goods where number >0 order by goodsId desc limit 1,1");
$info=mysqli_fetch_array($sql);
if($info==false){
echo "暂无推荐产品!";
}
else {
?>
<table width="270" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="130" rowspan="5">
<div align="center">
<?php
if(trim($info['img']=="")){
echo '<img src="../images/hulu.png" width="80" height="80" border="0">';
echo "<br>暂无图片";
}
else{
?>
<img src="<?php echo $info['img'];?>" width="80" height="80" border="0">
<?php
}
?>
</div>
</td>
<td width="11" height="16"> </td>
<td width="124"><font color="FF6501"> <?php echo $info['goodsname'];?></font></td>
</tr>
<tr>
<td height="16"> </td>
<td><font color="#000000">商品价格：</font><font color="FF6501"><?php echo $info['price'];?></font></td>
</tr>
<tr>
<td height="16"> </td>
<td><font color="#000000">商品数量：</font><font color="FF6501"><?php echo $info['number'];?></font></td>
</tr>
<tr>
<td height="50" colspan="2">
<a href="showGoodsInfo_view.php?goodsId='<?php echo $info['goodsId']; ?>'"><input type="button" value="查看详情" /></a>
<a href="order_view.php?goodsId='<?php echo $info['goodsId']?>'"><input type="button" value="购买" /></a>
</td>
</tr>
</tr>
</table>
<?php
}
?>
</td>
<td>
<?php
$sql=mysqli_query($conn,"select * from tb_goods where number >0 order by goodsId desc limit 2,1");
$info=mysqli_fetch_array($sql);
if($info==true){
?>
<table width="270" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="130" rowspan="5">
<div align="center">
<?php
基于PHP的校园二手交易系统，是PHP的课程设计作业.zip （53个子文件） 
ori_code_vip sql 
hulu_shop.sql 3KB data hulu_shop tb_user.frm 9KB tb_user.MYD 364B tb_goods.MYI 2KB db.opt 61B tb_admin.MYD 20B tb_order.MYI 3KB tb_goods.MYD 3KB tb_need.MYD 968B tb_admin.MYI 2KB tb_order.frm 13KB tb_need.frm 9KB tb_admin.frm 8KB tb_need.MYI 2KB tb_user.MYI 2KB tb_goods.frm 9KB tb_order.MYD 3KB ajax aggregate.php 307B models login.php 1KB addGoods.php 790B admin login.php 1KB change.php 948B changeInfor.php 612B loginout.php 89B order.php 2KB jiejuexuqiu.php 413B enroll.php 864B orderOperation.php 892B addNeed.php 805B conn conn.php 208B views pages login_view.php 2KB showGoods_view.php 4KB showNeed_view.php 4KB needList_view.php 4KB index.php 19KB addNeed_view.php 5KB showGoodsInfo_view.php 3KB order_view.php 7KB enroll_view.php 3KB orderList_view.php 7KB addGoods_view.php 4KB goodsList_view.php 4KB personalInfor.php 4KB admin login_view.php 2KB index.php 2KB images 
sports.jpg 12KB apparel.jpg 13KB viewall.jpg 17KB biaotu.jpg 461KB
hulu.png 405KB tools.jpg 15KB books.jpg 18KB layouts _header.php 3KB资源评论
