PHP基础示范：商品信息管理系统v1.1-tutorial php-php.cn

PHP基础示例：商品信息管理系统v1.1

实现目标：使用php和mysql写一个商品信息管理系统，并带有购物车功能

一、创建数据库和表

　　1.创建数据库和表：demodb

　　2.创建表格：goods

　　字段：商品编号，商品名称，商品类型，商品图片，单价，商品描述，库存量，添加时间

二、创建php文件编写代码(以下为要创建的php文件及其用途)

　　add.php　　商品添加页面

　　edit.php 商品信息编辑表单页

　　index.php　　商品信息浏览页

　　action.php　　执行商品信息添加和修改及删除等操作处理

　　dbconfig.php 公共配置文件，数据库连接配置信息

　　menu.php　　网站公共导航栏

　　uploads/ 　　上传图片的存放目录

　　function.php 公共函数库文件：图片信息的上传，等比缩放等处理函数

　　addCart.php 添加购物车信息的操作（向SESSION放入要购买的信息）

　　myCart.php 实现了购物车信息的浏览操作，并且实现商品信息的统计（小计和总价）

　　clearCart.php 实现了购物车信息的单个商品删除或清空购物车操作

　　updateCart.php 修改购物车中商品的数量，防止过小约束

各php文件关系图示：

好，那下面是代码部分：

首先是建表语句：

 1 create database newsdb;//创建库语句 2 3 create table goods ( 4 id int(10) unsigned NOT NULL AUTO_INCREMENT, 5 name varchar(64) NOT NULL, 6 typeid int(10) unsigned NOT NULL, 7 price double(6,2) unsigned NOT NULL, 8 total int(10) unsigned NOT NULL, 9 pic varchar(32) NOT NULL,10 note text,11 addtime int(10) unsigned NOT NULL,12 PRIMARY KEY (`id`)13 ) //创建表语句

Salin selepas log masuk

建表语句

以下为各php文件代码，需要的朋友可直接将各代码复制并放到同一目录下即可，还要在同目录下创建uplaods文件夹存放上传图片

<span style="color: #008080;"> 1</span> <span style="color: #008080;"> 2</span>     <span style="color: #008080;"> 3</span>         <title>商品信息管理</title><span style="color: #008080;"> 4</span>     <span style="color: #008080;"> 5</span>     <span style="color: #008080;"> 6</span>         <center>
<span style="color: #008080;"> 7</span>             <?php <span style="color: #0000ff;">include("menu.php");<span style="color: #008000;">//</span><span style="color: #008000;">导入导航栏  ?></span><span style="color: #008080;"> 8</span>             <h3>发布商品信息</h3>
<span style="color: #008080;"> 9</span>             <form action="action.php?action=add" enctype="multipart/form-data" method="post">
<span style="color: #008080;">10</span>             <table border="0" width="300">
<span style="color: #008080;">11</span>                 <tr>
<span style="color: #008080;">12</span>                     <td align="right">名称：</td>
<span style="color: #008080;">13</span>                     <td><input type="text" name="name"></td>
<span style="color: #008080;">14</span>                 </tr>
<span style="color: #008080;">15</span>                 <tr>
<span style="color: #008080;">16</span>                     <td align="right">类型：</td>
<span style="color: #008080;">17</span>                     <td>
<span style="color: #008080;">18</span>                         <select name="typeid"><span style="color: #008080;">19</span>                         <span style="color: #000000;">php </span><span style="color: #008080;">20</span>                             <span style="color: #0000ff;">include</span>("dbconfig.php"<span style="color: #000000;">);</span><span style="color: #008080;">21</span>                             <span style="color: #0000ff;">foreach</span>(<span style="color: #800080;">$typelist</span> <span style="color: #0000ff;">as</span> <span style="color: #800080;">$k</span>=><span style="color: #800080;">$v</span><span style="color: #000000;">)</span><span style="color: #008080;">22</span> <span style="color: #000000;">                            {</span><span style="color: #008080;">23</span>                                 <span style="color: #0000ff;">echo</span> "<option value='{<span style="color: #800080;">$k</span>}'>{<span style="color: #800080;">$v</span>}</option>"<span style="color: #000000;">;</span><span style="color: #008080;">24</span> <span style="color: #000000;">                            }</span><span style="color: #008080;">25</span>                         ?><span style="color: #008080;">26</span>                         </select><span style="color: #008080;">27</span>                     </td>
<span style="color: #008080;">28</span>                 </tr>
<span style="color: #008080;">29</span>                 <tr>
<span style="color: #008080;">30</span>                     <td align="right">单价：</td>
<span style="color: #008080;">31</span>                     <td><input type="text" name="price"></td>
<span style="color: #008080;">32</span>                 </tr>
<span style="color: #008080;">33</span>                 <tr>
<span style="color: #008080;">34</span>                     <td align="right">库存：</td>
<span style="color: #008080;">35</span>                     <td><input type="text" name="total"></td>
<span style="color: #008080;">36</span>                 </tr>
<span style="color: #008080;">37</span>                 <tr>
<span style="color: #008080;">38</span>                     <td align="right">图片：</td>
<span style="color: #008080;">39</span>                     <td><input type="file" name="pic"></td>
<span style="color: #008080;">40</span>                 </tr>
<span style="color: #008080;">41</span>                 <tr>
<span style="color: #008080;">42</span>                     <td align="right" valign="top">描述：</td>
<span style="color: #008080;">43</span>                     <td><textarea rows="5" cols="20" name="note"></textarea></td>
<span style="color: #008080;">44</span>                 </tr>
<span style="color: #008080;">45</span>                 <tr>
<span style="color: #008080;">46</span>                     <td colspan="2" align="center">
<span style="color: #008080;">47</span>                         <input type="submit" value="添加"> &<span style="color: #000000;">nbsp;</span><span style="color: #008080;">48</span>                         <input type="reset" value="重置"><span style="color: #008080;">49</span>                     </td>
<span style="color: #008080;">50</span>                 </tr>
<span style="color: #008080;">51</span>             </table>
<span style="color: #008080;">52</span>             </form>
<span style="color: #008080;">53</span>         </center><span style="color: #008080;">54</span>     <span style="color: #008080;">55</span>

Salin selepas log masuk

add.php

 1 php 2 //执行商品信息的增、删、改的操作 3 4 //一、导入配置文件和函数库文件 5 require("dbconfig.php"); 6 require("function.php"); 7 //二、连接MySQL，选择数据库 8 $link = mysql_connect(HOST,USER,PASS) or die("数据库连接失败"); 9 mysql_select_db(DBNAME,$link); 10 11 12 //三、获取action参数的值，并做对应的操作 13 switch($_GET["action"]) 14 { 15 case "add": //添加 16 //1.获取添加信息 17 $name = $_POST["name"]; 18 $typeid = $_POST["typeid"]; 19 $price = $_POST["price"]; 20 $total = $_POST["total"]; 21 $note = $_POST["note"]; 22 $addtime = time(); 23 //2.验证()省略 24 if(empty($name)) 25 { 26 die("商品名称必须有值"); 27 } 28 //3.执行图片上传 29 $upinfo = uploadFile("pic","./uploads/"); 30 if($upinfo["error"]===false) 31 { 32 die("图片信息上传失败：".$upinfo["info"]); 33 }else 34 { 35 //上传成功 36 $pic = $upinfo["info"];//获取上传成功的图片名 37 38 } 39 //4.执行图片缩放 40 imageUpdateSize('./uploads/'.$pic,50,50); 41 //5.拼装sql语句，并执行添加 42 $sql = "insert into goods values(null,'{$name}','{$typeid}',{$price},{$total},'{$pic}','{$note}',{$addtime})"; 43 mysql_query($sql,$link); 44 //6.判断并输出结果 45 if(mysql_insert_id($link)>0) 46 { 47 echo "商品发布成功"; 48 }else 49 { 50 echo "商品发布失败"; 51 } 52 echo " <a href="index.php">查看商品信息</a><a>"; 53 54 break; 55 case "del": //删除 56 //获取要删除的id号并拼装删除sql，执行 57 $sql = "delete from goods where id={$_GET['id']}"; 58 59 mysql_query($sql,$link); 60 //执行图片删除 61 if(mysql_affected_rows($link)>0) 62 { 63 @unlink("./uploads/".$_GET['picname']); 64 @unlink("./uploads/s_".$_GET['picname']); 65 } 66 //跳转到浏览界面 67 header("Location:index.php"); 68 break; 69 70 case "update": //修改 71 //1.获取要修改的信息 72 $name = $_POST["name"]; 73 $typeid = $_POST["typeid"]; 74 $price = $_POST["price"]; 75 $total = $_POST["total"]; 76 $note = $_POST["note"]; 77 $id = $_POST['id']; 78 $pic = $_POST['oldpic']; 79 //2.数据验证 80 if(empty($name)) 81 { 82 die("商品名称必须有值"); 83 } 84 //3.判断有无图片上传 85 if($_FILES['pic']['error']!=4) 86 { 87 //执行上传 88 $upinfo = uploadFile("pic","./uploads/"); 89 if($upinfo["error"]===false) 90 { 91 die("图片信息上传失败：".$upinfo["info"]); 92 }else 93 { 94 //上传成功 95 $pic = $upinfo["info"];//获取上传成功的图片名 96 //4.有图片上传执行缩放 97 imageUpdateSize('./uploads/'.$pic,50,50); 98 } 99 }100 101 102 //5.执行修改103 $sql = "update goods set name='{$name}',typeid={$typeid},price={$price},total={$total},note='{$note}',pic='{$pic}' where id={$id}";104 mysql_query($sql,$link);105 //6.判断是否修改成功106 if(mysql_affected_rows($link)>0)107 {108 if($_FILES['pic']['error']!=4)109 {110 //若有图片上传，就删除老图片111 @unlink("./uploads/".$_POST['oldpic']);112 @unlink("./uploads/s_".$_POST['oldpic']);113 }114 echo "修改成功";115 }else116 {117 echo "修改失败".mysql_error();118 }119 echo " </a><a href="index.php">查看商品信息</a><a>";120 break;121 default:122 echo "错误";break;123 124 }125 //四、关闭数据库126 mysql_close($link);</a>

Salin selepas log masuk

action.php

Salin selepas log masuk

dbconfig.php

<span style="color: #008080;"> 1</span> <span style="color: #008080;"> 2</span>     <span style="color: #008080;"> 3</span>         <title>商品信息管理</title><span style="color: #008080;"> 4</span>     <span style="color: #008080;"> 5</span>     <span style="color: #008080;"> 6</span>         <center>
<span style="color: #008080;"> 7</span>             <?php <span style="color: #0000ff;">include("menu.php");<span style="color: #008000;">//</span><span style="color: #008000;">导入导航栏  ?></span><span style="color: #008080;"> 8</span>             <h3>浏览商品信息<h3>
<span style="color: #008080;"> 9</span>             <span style="color: #008080;">10</span>             </h3>
</h3>
<table border="1" width="700">
<span style="color: #008080;">11</span>                 <tr>
<span style="color: #008080;">12</span>                     <th>商品编号</th>
<span style="color: #008080;">13</span>                     <th>商品名称</th>
<span style="color: #008080;">14</span>                     <th>商品图片</th>
<span style="color: #008080;">15</span>                     <th>单价</th>
<span style="color: #008080;">16</span>                     <th>库存量</th>
<span style="color: #008080;">17</span>                     <th>添加时间</th>
<span style="color: #008080;">18</span>                     <th>操作</th>
<span style="color: #008080;">19</span>                 </tr>
<span style="color: #008080;">20</span>                 <span style="color: #000000;">php </span><span style="color: #008080;">21</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">从数据库中读取信息并输出到浏览器表格中</span><span style="color: #008080;">22</span> <span style="color: #008000;">                //1.导入配置文件</span><span style="color: #008080;">23</span>                     <span style="color: #0000ff;">require</span>("dbconfig.php"<span style="color: #000000;">);</span><span style="color: #008080;">24</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">2.连接数据库，并选择数据库</span><span style="color: #008080;">25</span>                     <span style="color: #800080;">$link</span> = @<span style="color: #008080;">mysql_connect</span>(HOST,USER,PASS) or <span style="color: #0000ff;">die</span>("数据库连接失败"<span style="color: #000000;">);</span><span style="color: #008080;">26</span>                     <span style="color: #008080;">mysql_select_db</span>(DBNAME,<span style="color: #800080;">$link</span><span style="color: #000000;">);</span><span style="color: #008080;">27</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">3.执行商品信息查询</span><span style="color: #008080;">28</span>                     <span style="color: #800080;">$sql</span>="select * from goods"<span style="color: #000000;">;</span><span style="color: #008080;">29</span>                     <span style="color: #800080;">$result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$link</span><span style="color: #000000;">);</span><span style="color: #008080;">30</span>                     <span style="color: #008080;">31</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">4.解析商品信息（解析结果集）</span><span style="color: #008080;">32</span>                     <span style="color: #0000ff;">while</span>(<span style="color: #800080;">$row</span> = <span style="color: #008080;">mysql_fetch_assoc</span>(<span style="color: #800080;">$result</span><span style="color: #000000;">))</span><span style="color: #008080;">33</span> <span style="color: #000000;">                    {</span><span style="color: #008080;">34</span>                         <span style="color: #0000ff;">echo</span> "<tr>"<span style="color: #000000;">;</span><span style="color: #008080;">35</span>                         <span style="color: #0000ff;">echo</span> "<td>{<span style="color: #800080;">$row</span>["id"]}</td>"<span style="color: #000000;">;</span><span style="color: #008080;">36</span>                         <span style="color: #0000ff;">echo</span> "<td>{<span style="color: #800080;">$row</span>["name"]}</td>"<span style="color: #000000;">;</span><span style="color: #008080;">37</span>                         <span style="color: #0000ff;">echo</span> "<td>
<img  class="code_img_closed lazy" src="/static/imghw/default1.png" data-src="/img/2015/05/26/151456224.gif" color: alt="PHP基础示范：商品信息管理系统v1.1" >$row['pic']}'/></td>"<span   style="max-width:90%">;</span><span style="color: #008080;">38</span>                         <span style="color: #0000ff;">echo</span> "<td>{<span style="color: #800080;">$row</span>["price"]}</td>"<span style="color: #000000;">;</span><span style="color: #008080;">39</span>                         <span style="color: #0000ff;">echo</span> "<td>{<span style="color: #800080;">$row</span>["total"]}</td>"<span style="color: #000000;">;</span><span style="color: #008080;">40</span>                         <span style="color: #0000ff;">echo</span> "<td>".<span style="color: #008080;">date</span>("Y-m-d H:i:s",<span style="color: #800080;">$row</span>['addtime'])."</td>"<span style="color: #000000;">;</span><span style="color: #008080;">41</span>                         <span style="color: #0000ff;">echo</span> "<span style="color: #000000;"></span><td>
<span style="color: #008080;">42</span>                                 <a href="action.php?action=del&id=%7B<span%20style=%22color:%20#800080;%22>%24row</span>%5B" id style="color: #800080;">$row<span style="color: #000000;">['pic']}'>删除</span></a>  <span style="color: #008080;">43</span>                                 <a href="edit.php?id=%7B<span%20style=%22color:%20#800080;%22>%24row</span><span%20style=%22color:%20#000000;%22>%5B" id>修改</a>  <span style="color: #008080;">44</span>                                 <a href="addCart.php?id=%7B<span%20style=%22color:%20#800080;%22>%24row</span><span%20style=%22color:%20#000000;%22>%5B" id>放入购物车</a>  <span style="color: #008080;">45</span>                                                                                     <span style="color: #008080;">46</span>                               </td>"<span style="color: #000000;">;</span><span style="color: #008080;">47</span>                         <span style="color: #0000ff;">echo</span> "</tr>"<span style="color: #000000;">;</span><span style="color: #008080;">48</span> <span style="color: #000000;">                    }</span><span style="color: #008080;">49</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">5.释放结果集，关闭数据库</span><span style="color: #008080;">50</span>                 ?><span style="color: #008080;">51</span>             </table>
<span style="color: #008080;">52</span>         </center><span style="color: #008080;">53</span>     <span style="color: #008080;">54</span>

Salin selepas log masuk

index.php

<span style="color: #008080;"> 1</span> <span style="color: #008080;"> 2</span>     <span style="color: #008080;"> 3</span>         <title>商品信息管理</title><span style="color: #008080;"> 4</span>     <span style="color: #008080;"> 5</span>     <span style="color: #008080;"> 6</span>         <center>
<span style="color: #008080;"> 7</span>             <span style="color: #000000;">php </span><span style="color: #008080;"> 8</span>                 <span style="color: #0000ff;">include</span>("menu.php");<span style="color: #008000;">//</span><span style="color: #008000;">导入导航栏  </span><span style="color: #008080;"> 9</span> <span style="color: #008000;">                //1.导入配置文件</span><span style="color: #008080;">10</span>                 <span style="color: #0000ff;">require</span>("dbconfig.php"<span style="color: #000000;">);</span><span style="color: #008080;">11</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">2.连接数据库，并选择数据库</span><span style="color: #008080;">12</span>                 <span style="color: #800080;">$link</span> = @<span style="color: #008080;">mysql_connect</span>(HOST,USER,PASS) or <span style="color: #0000ff;">die</span>("数据库连接失败"<span style="color: #000000;">);</span><span style="color: #008080;">13</span>                 <span style="color: #008080;">mysql_select_db</span>(DBNAME,<span style="color: #800080;">$link</span><span style="color: #000000;">);</span><span style="color: #008080;">14</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">3.获取要修改的商品信息</span><span style="color: #008080;">15</span>                 <span style="color: #800080;">$sql</span>="select *from goods where id={<span style="color: #800080;">$_GET</span>['id']}"<span style="color: #000000;">;</span><span style="color: #008080;">16</span>                 <span style="color: #800080;">$result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$link</span><span style="color: #000000;">);</span><span style="color: #008080;">17</span>                 <span style="color: #008000;">//</span><span style="color: #008000;">4.判断是否获取到要编辑的商品信息</span><span style="color: #008080;">18</span>                 <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$result</span>&&<span style="color: #008080;">mysql_num_rows</span>(<span style="color: #800080;">$result</span>)>0<span style="color: #000000;">)</span><span style="color: #008080;">19</span> <span style="color: #000000;">                {</span><span style="color: #008080;">20</span>                     <span style="color: #800080;">$shop</span>=<span style="color: #008080;">mysql_fetch_assoc</span>(<span style="color: #800080;">$result</span>);<span style="color: #008000;">//</span><span style="color: #008000;">解析出要修改的商品信息</span><span style="color: #008080;">21</span>                 }<span style="color: #0000ff;">else</span><span style="color: #008080;">22</span> <span style="color: #000000;">                {</span><span style="color: #008080;">23</span>                     <span style="color: #0000ff;">die</span>("没有找到要修改的商品信息"<span style="color: #000000;">);</span><span style="color: #008080;">24</span> <span style="color: #000000;">                }</span><span style="color: #008080;">25</span>                 <span style="color: #008080;">26</span>             ?><span style="color: #008080;">27</span>             <h3>编辑商品信息</h3>
<span style="color: #008080;">28</span>             <form action="action.php?action=update" enctype="multipart/form-data" method="post">
<span style="color: #008080;">29</span>                 <input type="hidden" name="id" value="<?php echo <span style=" color:>$shop['id']; ?>" /><span style="color: #008080;">30</span>                 <input type="hidden" name="oldpic" value="<?php echo <span style=" color:>$shop['pic']; ?>" /><span style="color: #008080;">31</span>                 <span style="color: #008080;">32</span>             <table border="0" width="300">
<span style="color: #008080;">33</span>                 <tr>
<span style="color: #008080;">34</span>                     <td align="right">名称：</td>
<span style="color: #008080;">35</span>                     <td>
<input type="text" name="name" value="<?php echo <span style=" color:>$shop['name']; ?>" /></td>
<span style="color: #008080;">36</span>                 </tr>
<span style="color: #008080;">37</span>                 <tr>
<span style="color: #008080;">38</span>                     <td align="right">类型：</td>
<span style="color: #008080;">39</span>                     <td>
<span style="color: #008080;">40</span>                         <select name="typeid"><span style="color: #008080;">41</span>                         <span style="color: #000000;">php </span><span style="color: #008080;">42</span>                             <span style="color: #0000ff;">include</span>("dbconfig.php"<span style="color: #000000;">);</span><span style="color: #008080;">43</span>                             <span style="color: #0000ff;">foreach</span>(<span style="color: #800080;">$typelist</span> <span style="color: #0000ff;">as</span> <span style="color: #800080;">$k</span>=><span style="color: #800080;">$v</span><span style="color: #000000;">)</span><span style="color: #008080;">44</span> <span style="color: #000000;">                            {</span><span style="color: #008080;">45</span>                                 <span style="color: #800080;">$sd</span> = (<span style="color: #800080;">$shop</span>['typeid']==<span style="color: #800080;">$k</span>)?"selected":"";<span style="color: #008000;">//</span><span style="color: #008000;">判断是否当前的类型</span><span style="color: #008080;">46</span>                                 <span style="color: #0000ff;">echo</span> "<option value='{<span style="color: #800080;">$k</span>}' style="color: #800080;">$sd}>{<span style="color: #800080;">$v</span>}</option>"<span style="color: #000000;">;</span><span style="color: #008080;">47</span> <span style="color: #000000;">                            }</span><span style="color: #008080;">48</span>                         ?><span style="color: #008080;">49</span>                         </select><span style="color: #008080;">50</span>                     </td>
<span style="color: #008080;">51</span>                 </tr>
<span style="color: #008080;">52</span>                 <tr>
<span style="color: #008080;">53</span>                     <td align="right">单价：</td>
<span style="color: #008080;">54</span>                     <td>
<input type="text" name="price" value="<?php echo <span style=" color:>$shop['price']; ?>" /></td>
<span style="color: #008080;">55</span>                 </tr>
<span style="color: #008080;">56</span>                 <tr>
<span style="color: #008080;">57</span>                     <td align="right">库存：</td>
<span style="color: #008080;">58</span>                     <td>
<input type="text" name="total" value="<?php echo <span style=" color:>$shop['total']; ?>" /></td>
<span style="color: #008080;">59</span>                 </tr>
<span style="color: #008080;">60</span>                 <tr>
<span style="color: #008080;">61</span>                     <td align="right">图片：</td>
<span style="color: #008080;">62</span>                     <td><input type="file" name="pic"></td>
<span style="color: #008080;">63</span>                 </tr>
<span style="color: #008080;">64</span>                 <tr>
<span style="color: #008080;">65</span>                     <td align="right" valign="top">描述：</td>
<span style="color: #008080;">66</span>                     <td><textarea rows="5" cols="20" name="note"><?php <span style="color: #0000ff;">echo <span style="color: #800080;">$shop</span>['note']; ?></textarea></td>
<span style="color: #008080;">67</span>                 </tr>
<span style="color: #008080;">68</span>                 <span style="color: #008080;">69</span>                 <tr>
<span style="color: #008080;">70</span>                     <td colspan="2" align="center">
<span style="color: #008080;">71</span>                         <input type="submit" value="修改"> &<span style="color: #000000;">nbsp;</span><span style="color: #008080;">72</span>                         <input type="reset" value="重置"><span style="color: #008080;">73</span>                     </td>
<span style="color: #008080;">74</span>                 </tr>
<span style="color: #008080;">75</span>                 <tr>
<span style="color: #008080;">76</span>                     <td align="right" valign="top"> </td>
<span style="color: #008080;">77</span>                     <td>
<img  class="code_img_closed lazy" src="/static/imghw/default1.png" data-src="/img/2015/05/26/151456224.gif" color: alt="PHP基础示范：商品信息管理系统v1.1" >$shop['pic'];?>" /></td>
<span style="color: #008080;">78</span>                 </tr>
<span style="color: #008080;">79</span>             </table>
<span style="color: #008080;">80</span>             </form>
<span style="color: #008080;">81</span>         </center><span style="color: #008080;">82</span>     <span style="color: #008080;">83</span>

Salin selepas log masuk

edit.php

Salin selepas log masuk