<?php
ini_set("error_reporting","E_ALL & ~E_NOTICE");
include_once 'conn.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>用户信息</title><script language="javascript" src="js/Calendar.js"></script><link rel="stylesheet" href="css.css" type="text/css">
</head>
<body>
<p>已有用户信息列表：</p>
<form id="form1" name="form1" method="post" action="">
搜索: 编号：<input name="gonghao" type="text" id="gonghao" /> 姓名：<input name="xingming" type="text" id="xingming" /> 身份证：<input name="shenfenzheng" type="text" id="shenfenzheng" /> 电话：<input name="dianhua" type="text" id="dianhua" /> 注册时间：<input name="ruzhishijian1" type="text" id="ruzhishijian1" value='' onclick="getDate(form1.ruzhishijian1,'2')" size="10" need="1" />-<input name="ruzhishijian2" type="text" id="ruzhishijian2" value='' onclick="getDate(form1.ruzhishijian2,'2')" size="10" need="1" /> 性别：<select name='xingbie' id='xingbie'><option value="">所有</option><option value="男">男</option><option value="女">女</option></select>
<input type="submit" name="Submit" value="查找" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#000000" style="border-collapse:collapse">
<tr>
<td width="25" bgcolor="#FFCC00">序号</td>
<td bgcolor='#FFCC00'>编号</td><td bgcolor='#FFCC00'>姓名</td><td bgcolor='#FFCC00'>密码</td><td bgcolor='#FFCC00'>身份证</td><td bgcolor='#FFCC00'>电话</td><td bgcolor='#FFCC00'>邮箱</td><td bgcolor='#FFCC00'>照片</td><td bgcolor='#FFCC00'>家庭住址</td><td bgcolor='#FFCC00'>注册时间</td><td bgcolor='#FFCC00'>性别</td><td bgcolor='#FFCC00'>备注</td>
<td width="120" align="center" bgcolor="#FFCC00">添加时间</td>
<td width="70" align="center" bgcolor="#FFCC00">操作</td>
</tr>
<?php
$sql="select * from yuangongxinxi where 1=1";
if ($_POST["gonghao"]!=""){$nreqgonghao=$_POST["gonghao"];$sql=$sql." and gonghao like '%$nreqgonghao%'";}
if ($_POST["xingming"]!=""){$nreqxingming=$_POST["xingming"];$sql=$sql." and xingming like '%$nreqxingming%'";}
if ($_POST["shenfenzheng"]!=""){$nreqshenfenzheng=$_POST["shenfenzheng"];$sql=$sql." and shenfenzheng like '%$nreqshenfenzheng%'";}
if ($_POST["dianhua"]!=""){$nreqdianhua=$_POST["dianhua"];$sql=$sql." and dianhua like '%$nreqdianhua%'";}
if ($_POST["ruzhishijian1"]!=""){$nreqruzhishijian1=$_POST["ruzhishijian1"];$sql=$sql." and ruzhishijian >= '$nreqruzhishijian1'";}
if ($_POST["ruzhishijian2"]!=""){$nreqruzhishijian2=$_POST["ruzhishijian2"];$sql=$sql." and ruzhishijian <= '$nreqruzhishijian2'";}
if ($_POST["xingbie"]!=""){$nreqxingbie=$_POST["xingbie"];$sql=$sql." and xingbie like '%$nreqxingbie%'";}
$sql=$sql." order by id desc";
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
if($rowscount==0)
{}
else
{
$pagelarge=5;//每页行数；
$pagecurrent=$_GET["pagecurrent"];
if($rowscount%$pagelarge==0)
{
$pagecount=$rowscount/$pagelarge;
}
else
{
$pagecount=intval($rowscount/$pagelarge)+1;
}
if($pagecurrent=="" || $pagecurrent<=0)
{
$pagecurrent=1;
}
if($pagecurrent>$pagecount)
{
$pagecurrent=$pagecount;
}
$ddddd=$pagecurrent*$pagelarge;
if($pagecurrent==$pagecount)
{
if($rowscount%$pagelarge==0)
{
$ddddd=$pagecurrent*$pagelarge;
}
else
{
$ddddd=$pagecurrent*$pagelarge-$pagelarge+$rowscount%$pagelarge;
}
}
for($i=$pagecurrent*$pagelarge-$pagelarge;$i<$ddddd;$i++)
{
?>
<tr>
<td width="25"><?php
echo $i+1;
?></td>
<td><?php echo mysql_result($query,$i,gonghao);?></td><td><?php echo mysql_result($query,$i,xingming);?></td><td><?php echo mysql_result($query,$i,mima);?></td><td><?php echo mysql_result($query,$i,shenfenzheng);?></td><td><?php echo mysql_result($query,$i,dianhua);?></td><td><?php echo mysql_result($query,$i,youxiang);?></td><td width='80'><a href="<?php echo mysql_result($query,$i,zhaopian) ?>" target='_blank'><img src='<?php echo mysql_result($query,$i,zhaopian) ?>' width='80' height='88' border='0'></a></td><td><?php echo mysql_result($query,$i,zhuyaozhize);?></td><td><?php echo mysql_result($query,$i,ruzhishijian);?></td><td><?php echo mysql_result($query,$i,xingbie);?></td><td><?php echo mysql_result($query,$i,beizhu);?></td>
<td width="120" align="center"><?php
echo mysql_result($query,$i,"addtime");
?></td>
<td width="70" align="center"><a href="del.php?id=<?php
echo mysql_result($query,$i,"id");
?>&tablename=yuangongxinxi" onclick="return confirm('真的要删除？')">删除</a> <a href="yuangongxinxi_updt.php?id=<?php
echo mysql_result($query,$i,"id");
?>">修改</a></td>
</tr>
<?php
}
}
?>
</table>
<p>以上数据共<?php
echo $rowscount;
?>条,
<input type="button" name="Submit2" onclick="javascript:window.print();" value="打印本页" />
</p>
<p align="center"><a href="yuangongxinxi_list.php?pagecurrent=1">首页</a>, <a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecurrent-1;?>">前一页</a> ,<a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecurrent+1;?>">后一页</a>, <a href="yuangongxinxi_list.php?pagecurrent=<?php echo $pagecount;?>">末页</a>, 当前第<?php echo $pagecurrent;?>页,共<?php echo $pagecount;?>页 </p>
<p> </p>
</body>
</html>
基于PHP的超市管理系统.rar
需积分: 50 188 浏览量
2020-08-12
16:51:22
上传
评论 7
收藏 35.45MB RAR 举报
基于PHP的超市管理系统.rar （128个子文件） 
.buildpath 174B CssAdmin.css 3KB css.css 3KB tab.css 3KB css.css 571B Thumbs.db 70KB
hsgbg3.gif 3.55MB hsgbg2.gif 44KB main_11.gif 5KB main_21.gif 4KB main_08.gif 4KB main_12.gif 3KB main_07.gif 1KB main_09.gif 1KB main_06.gif 1KB tab_05.gif 1KB main_47.gif 1KB main_45.gif 1KB tab_03.gif 1KB tab_07.gif 1KB main_16.gif 1KB editinfo.gif 1001B tab_21.gif 986B main_38.gif 973B tab_20.gif 971B tab_22.gif 967B main_01.gif 949B main_51.gif 927B ftv2folderopen.gif 894B ftv2folderclosed.gif 894B exit.gif 892B main_18.gif 871B main_40.gif 853B main_42.gif 850B main_04.gif 804B main_49.gif 786B main_23.gif 420B ftv2pnode.gif 327B main_14.gif 309B tab_14.gif 263B pwd.gif 255B ftv2mnode.gif 214B i_open.gif 205B Edit.gif 154B ftv2node.gif 147B ftv2lastnode.gif 142B ftv2vertline.gif 140B tab_12.gif 112B tab_16.gif 112B Upload.gif 111B ftv2plastnode.gif 97B ftv2mlastnode.gif 93B CalendarCn.htm 11KB
left.html 4KB login.html 3KB left2.html 3KB picturetest.html 297B 11.iml 281B
15.jpg 93KB 3.jpg 91KB 4.jpg 43KB 6.jpg 32KB 1.jpg 26KB 13.jpg 26KB 2.jpg 25KB 16.jpg 19KB 12.jpg 19KB 14.jpg 13KB 7.jpg 11KB 11.jpg 10KB 10.jpg 9KB 8.jpg 8KB 9.jpg 7KB erweima.jpg 3KB 5.jpg 2KB treemenu.js 13KB Common.js 6KB Calendar.js 281B
超市管理系统演示视频_jianqie_yinyue.mp4 28.97MB yuangongxinxi_list.php 5KB yuangongxinxi_updt2.php 5KB yuangongxinxi_add.php 4KB yuangongxinxi_updt.php 4KB rukujilu_add.php 4KB rukujilu_list.php 4KB yonghushangpinxinxchaxun.php 4KB shangpinxinxi_list.php 4KB yhzhgl.php 4KB shangpinxinxi_list2.php 4KB rukujilu_list2.php 4KB top.php 4KB rukujilu_updt.php 4KB shangpinleibie_list.php 4KB shangpinxinxi_add.php 4KB shangpinleibie_updt.php 4KB shangpinxinxi_updt.php 4KB yonghushangpinleibiechaxun.php 3KB mod.php 3KB shangpinleibie_add.php 2KB upfile.php 2KB共 128 条
- 1
- 2
资源评论
weixin_42279741
- 粉丝: 0
- 资源: 3
最新资源
- 高等数学第一章第二节数列的极限
- Python 版冒泡排序算法源代码
- tensorflow-gpu-2.7.2-cp38-cp38-manylinux2010-x86-64.whl
- tensorflow-2.7.3-cp39-cp39-manylinux2010-x86-64.whl
- tensorflow-2.7.2-cp39-cp39-manylinux2010-x86-64.whl
- Python版本快速排序源代码
- Python 语言版的快速排序算法实现
- 450815388207377安卓_base.apk
- 超微主板 X9DRE-TF+ bios 支持 nvme启动
- 基于Python通过下载气象数据和插值拟合离散数据曲线实现对寒潮过程的能量分析
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
