php小型企業庫存管理系統的設計與實現代碼

最後更新：2018-12-08 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

雙專業畢業論文做了一個小型企業庫存管理系統，使用PHP&mysql組合進行開發。頭一次開發稍微大一點的東西，php也是自學的。這裡想跟大家一起分享一下

check_login 模組

複製代碼代碼如下:
<?php
session_start();
$workid=$_GET['wid'];//擷取工作號
if($workid!=$_SESSION['$workid']||$workid==''){
echo "<script language=javascript>alert('您還沒有登陸，無法管理!');location.href='login.php';</script>";
}
?>

function.inc//主要包括資料庫連接模組複製代碼代碼如下:<?php
function mysql_link($user="admin",$password="admin",$database="systembase"){
$id=mysql_connect("localhost",$user,$password);
if(!$id){
die('Could not connect: ' . mysql_error());
}
if (!mysql_select_db($database,$id)){
die ("Can\'t select_db : " . mysql_error());
}
//改變用戶端字元集編碼為gb2312
mysql_query("SET NAMES gb2312");
return $id;
}
?>

倉庫管理介面storage.php 複製代碼代碼如下:
2 <?php
3 include "inc/check_login.php";
4 include "inc/function.inc";
5 $id=mysql_link("storage","storage");//建立storage串連
6
7 $query="select * from admin where admin_id='$workid'";//定位倉庫
8 $result=mysql_query($query,$id);
9 $info=mysql_fetch_array($result,MYSQL_ASSOC);
$stoid=$info['storage_id'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<html>
<head>
<LINK href="images/style.css" type=text/css rel=stylesheet>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<title>倉庫管理</title>
<style type="text/css">
body{
font-family:Arial,Helvetica,sans-serif; /*設定字型樣式*/
font-size:12px;
margin:0px 240px;
height:auto;
width:800px;
border:1px solid #006633;
background-color:rgb(195,245,200);

}
</style>
</head>
<body>
<div id="header" ></div>
<ul id="nav">
<li><a href="logout.php">注銷</a></li>
<?php
echo "<li><a href=input.php?wid=".$workid.">入庫</a></li>";
echo "<li><a href=output.php?wid=".$workid.">出庫</a></li>";
?>
</ul>
<div id="content" align=center>
<div id="man_zone" align=center>
<table width="99%" border="1" align="center" cellpadding="3" cellspacing="1">
<?php
$query="select * from storage where storage_id='$stoid'";//定位倉庫資訊
$result=mysql_query($query,$id);
if(mysql_num_rows($result)<1){
echo "沒有倉庫".$stoid;
}else{
$info=mysql_fetch_array($result,MYSQL_ASSOC);
echo "倉庫號:".$stoid." 總容量:".$info['storage_cap']." 剩餘容量:".$info['storage_lcap']."
倉庫地址:".$info['storage_add']." 倉庫電話:".$info['storage_tele'];
if (!mysql_select_db("basicbase",$id)){
die ("Can\'t select_db : " . mysql_error());
}
//在basicbase中建立對應倉庫貨物視圖，入程式庫檢視以及出程式庫檢視
//判斷是否存在相關視圖，沒有的話就建立視圖
$query="select * from ".$stoid."_inventory";
if(!mysql_query($query,$id)){
//建立inventory視圖
$query="create view ".$stoid."_inventory as
select inventory.goods_id,name,number from inventory,systembase.goods where storage_id=".$stoid." and inventory.goods_id=systembase.goods.goods_id";
if(!mysql_query($query,$id)){
die ("Can\'t create_view_inventory : " . mysql_error());
}
//建立input視圖
$query="create view ".$stoid."_input as
select input_id,goods_id,number,time from input where admin_id=".$workid;
if(!mysql_query($query,$id)){
die ("Can\'t create_view_input : " . mysql_error());
}
//建立output視圖
$query="create view ".$stoid."_output as
select output_id,goods_id,number,time from output where admin_id=".$workid;
if(!mysql_query($query,$id)){
die ("Can\'t create_view_output : " . mysql_error());
}
}
$query="select * from ".$stoid."_inventory";
$result=mysql_query($query,$id);
if(mysql_num_rows($result)<1){
echo "<br>該倉庫目前是空的";
}else{
$totalnum=mysql_num_rows($result);
$pagesize=7;
$page=$_GET["page"];
if(""==$page){
$page=1;
}
$begin=($page-1)*$pagesize;
$totalpage=ceil($totalnum/$pagesize);

echo "<tr>倉庫中共有".$totalnum."種貨物。";
echo "每頁".$pagesize."種，共".$totalpage."頁。</tr>";
for($j=1;$j<=$totalpage;$j++){
echo "<a href=storage.php?wid=".$workid."&page=".$j.">[".$j."] </a>";
}
echo "<br>";
$query="select *from ".$stoid."_inventory order by goods_id limit $begin,$pagesize";
$result=mysql_query($query,$id);
$datanum=mysql_num_rows($result);
//echo "<tr><td id=table_title >貨物id</td><td id=table_title >貨物名稱</td><td id=table_title >貨物數量</td></tr>";
echo "<tr><td >貨物id</td><td >貨物名稱</td><td >貨物數量</td></tr>";
for($i=1;$i<=$datanum;$i++){
$info=mysql_fetch_array($result,MYSQL_ASSOC);
//echo "<tr><td id=table_title >".$info['goods_id']."</td><td id=table_title >".$info['name']."</td><td id=table_title >".$info['number']."</td></tr>";
echo "<tr><td >".$info['goods_id']."</td><td >".$info['name']."</td><td >".$info['number']."</td></tr>";
}

}
}
mysql_close($id);
?>
</table>
</div>
</div>
<div id="footer">著作權：Freeze&zhaoL <br>E-mail:zhoujiebin15@qq.com</div>
</body>
</html>

代碼太多不一一貼了，第一次寫碰到很多問題，但不管怎麼說程式還是運行起來了

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More