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

  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 "<br> <a href='index.php'>查看商品信息<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             }else
116             {
117                 echo "修改失败".mysql_error();
118             }
119             echo "<br> <a href='index.php'>查看商品信息<a>";
120             break;
121             default:
122                 echo "错误";break;
123              
124     }
125 //四、关闭数据库
126     mysql_close($link);