php小型企业库存管理系统的设计与实现代码_php实例

双专业毕业论文做了一个小型企业库存管理系统，使用PHP&mysql组合进行开发。头一次开发稍微大一点的东西，php也是自学的。这里想跟大家一起分享一下

check_login 模块
代码如下:

<br><!--用户登陆检验模块--> <br><!--?php <BR-->session_start(); <br>$workid=$_GET['wid'];//获取工作号 <br>if($workid!=$_SESSION['$workid']||$workid==''){ <br>echo ""; <br>} <br>?> <br> <br>function.inc//主要包括数据库连接模块 <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><!--?php <BR-->function mysql_link($user="admin",$password="admin",$database="systembase"){ <br>$id=mysql_connect("localhost",$user,$password); <br>if(!$id){ <br>die('Could not connect: ' . mysql_error()); <br>} <br>if (!mysql_select_db($database,$id)){ <br>die ("Can\'t select_db : " . mysql_error()); <br>} <br>//改变客户端字符集编码为gb2312 <br>mysql_query("SET NAMES gb2312"); <br>return $id; <br>} <br>?> <br> <br>仓库管理界面storage.php <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><!--仓库管理员管理界面--> <br>2 <!--?php <BR-->3 include "inc/check_login.php"; <br>4 include "inc/function.inc"; <br>5 $id=mysql_link("storage","storage");//建立storage连接 <br>6 <br>7 $query="select * from admin where admin_id='$workid'";//定位仓库 <br>8 $result=mysql_query($query,$id); <br>9 $info=mysql_fetch_array($result,MYSQL_ASSOC); <br>$stoid=$info['storage_id']; <br>?> <br> <br> <br> <br><link href="images/style.css" type="text/css" rel="stylesheet"> <br><meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <br><title>仓库管理</title> <br><style type="text/css"> <BR>body{ <BR>font-family:Arial,Helvetica,sans-serif; /*设置字体样式*/ <BR>font-size:12px; <BR>margin:0px 240px; <BR>height:auto; <BR>width:800px; <BR>border:1px solid #006633; <BR>background-color:rgb(195,245,200); <br><br>} <BR></style> <br> <br> <br> <br><ul id="nav"> <br><li>注 销</li> <br><!--?php <BR-->echo "<li>入 库</li>"; <br>echo "<li>出 库</li>"; <br>?> <br></ul> <br> <br> <br><br>$query="select * from storage where storage_id='$stoid'";//定位仓库信息 <br>$result=mysql_query($query,$id); <br>if(mysql_num_rows($result)<1){ <br>echo "没有仓库".$stoid; <br>}else{ <br>$info=mysql_fetch_array($result,MYSQL_ASSOC); <br>echo "仓库号:".$stoid." 总容量:".$info['storage_cap']." 剩余容量:".$info['storage_lcap']." <br> 仓库地址:".$info['storage_add']." 仓库电话:".$info['storage_tele']; <br>if (!mysql_select_db("basicbase",$id)){ <br>die ("Can\'t select_db : " . mysql_error()); <br>} <br>//在basicbase中建立对应仓库货物视图，入库视图以及出库视图 <br>//判断是否存在相关视图，没有的话就新建视图 <br>$query="select * from ".$stoid."_inventory"; <br>if(!mysql_query($query,$id)){ <br>//创建inventory视图 <br>$query="create view ".$stoid."_inventory as <br>select inventory.goods_id,name,number from inventory,systembase.goods where storage_id=".$stoid." and inventory.goods_id=systembase.goods.goods_id"; <br>if(!mysql_query($query,$id)){ <br>die ("Can\'t create_view_inventory : " . mysql_error()); <br>} <br>//创建input视图 <br>$query="create view ".$stoid."_input as <br>select input_id,goods_id,number,time from input where admin_id=".$workid; <br>if(!mysql_query($query,$id)){ <br>die ("Can\'t create_view_input : " . mysql_error()); <br>} <br>//创建output视图 <br>$query="create view ".$stoid."_output as <br>select output_id,goods_id,number,time from output where admin_id=".$workid; <br>if(!mysql_query($query,$id)){ <br>die ("Can\'t create_view_output : " . mysql_error()); <br>} <br>} <br>$query="select * from ".$stoid."_inventory"; <br>$result=mysql_query($query,$id); <br>if(mysql_num_rows($result)<1){ <br>echo "<br>该仓库目前是空的"; <br>}else{ <br>$totalnum=mysql_num_rows($result); <br>$pagesize=7; <br>$page=$_GET["page"]; <br>if(""==$page){ <br>$page=1; <br>} <br>$begin=($page-1)*$pagesize; <br>$totalpage=ceil($totalnum/$pagesize); <br><br>echo "仓库中共有".$totalnum."种货物。"; <br>echo "每页".$pagesize."种，共".$totalpage."页。"; <br>for($j=1;$j<=$totalpage;$j++){ <br>echo "[".$j."]  "; <br>} <br>echo "<br>"; <br>$query="select *from ".$stoid."_inventory order by goods_id limit $begin,$pagesize"; <br>$result=mysql_query($query,$id); <br>$datanum=mysql_num_rows($result); <br>//echo ""; <br>echo ""; <br>for($i=1;$i<=$datanum;$i++){ <br>$info=mysql_fetch_array($result,MYSQL_ASSOC); <br>//echo ""; <br>echo ""; <br>} <br><br>} <br>} <br>mysql_close($id); <br>?> <br><table width="99%" border="1" align="center" cellpadding="3" cellspacing="1"> <!--?php <BR--><tbody><tr></tr><tr><td id="table_title">货物id</td><td id="table_title">货物名称</td><td id="table_title">货物数量</td></tr><tr><td>货物id</td><td>货物名称</td><td>货物数量</td></tr><tr><td id="table_title">".$info['goods_id']."</td><td id="table_title">".$info['name']."</td><td id="table_title">".$info['number']."</td></tr><tr><td>".$info['goods_id']."</td><td>".$info['name']."</td><td>".$info['number']."</td></tr></tbody></table> <br> <br> <br>版权所有：Freeze&zhaoL <br>E-mail:zhoujiebin15@qq.com <br> <br> <br> <br>代码太多不一一贴了，第一次写碰到很多问题，但不管怎么说程序还是运行起来了                    </li></ol></pre></li></ol></pre>