PHP development corporate website tutorial to modify products
It is also queried in the database based on the parameter id brought by the form submission
The code is as follows:
<?php
require_once('conn.php');
$id = $_GET['id'];
$sql = "SELECT * from product where id= '$id'";
$res = mysql_query($sql);
$info = mysql_fetch_array($res);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>修改产品</title>
<style type="text/css">
#cnt{
width:400px;
height:400px;
margin-top:15px;
margin-left: 15px;
}
iframe{border:0px;}
</style>
</head>
<body>
<div id="cnt">
<form method="post" action="modifyproduct.php?id=<?php echo $info['id']?>" enctype="multipart/form-data">
产品名称:<input type="text" name="title" id="title" value="<?php echo $info['title']?>"></br></br>
<iframe src="file.php"></iframe>
<input type="text" id="imgname" name="imgname" value="<?php echo $info['imgname'];?>"></br></br>
产品价格:<input type="text" name="price" value="<?php echo $info['price']?>">
</br></br>
<input type="submit" value="修改产品">
</form>
</div>
</body>
</html>You can see that there is a file.php file in our form
When modifying, we may re-upload the image, so I used an iframe tag.
Let’s take a look at the code of file.php:
<?php
if(!empty($_POST['go']) && $_POST['go']==1){
//接受文件，临时文件信息
$fileinfo=$_FILES["myFile"];//降维操作
$filename=$fileinfo["name"];
$tmp_name=$fileinfo["tmp_name"];
$size=$fileinfo["size"];
$error=$fileinfo["error"];
$type=$fileinfo["type"];
//服务器端设定限制
$maxsize=10485760;//10M,10*1024*1024
$allowExt=array('jpeg','jpg','png','gif');//允许上传的文件类型（拓展名
$ext=pathinfo($filename,PATHINFO_EXTENSION);//提取上传文件的拓展名
//目标存放文件夹
$path="../uploads";
if (!file_exists($path)) { //当目录不存在，就创建目录
mkdir($path,0777,true);//创建目录
chmod($path, 0777);//改变文件模式,所有人都有执行权限、写权限、度权限
}
//得到唯一的文件名！防止因为文件名相同而产生覆盖
$uniName=md5(uniqid(microtime(true),true)).".$ext";
//md5加密，uniqid产生唯一id，microtime做前缀
//目标存放文件地址
$destination=$path."/".$uniName;
//当文件上传成功，存入临时文件夹，服务器端开始判断
if ($error==0) {
if ($size>$maxsize) {
exit("上传文件过大！");
}
if (!in_array($ext, $allowExt)) {
exit("非法文件类型");
}
if (!is_uploaded_file($tmp_name)) {
exit("上传方式有误，请使用post方式");
}
//判断是否为真实图片（防止伪装成图片的病毒一类的
if (!getimagesize($tmp_name)) {//getimagesize真实返回数组，否则返回false
exit("不是真正的图片类型");
}
//move_uploaded_file($tmp_name, "uploads/".$filename);
if (@move_uploaded_file($tmp_name, $destination)) {//@错误抑制符，不让用户看到警告
echo "<script>parent.document.all.imgname.value = '$destination';</script>文件".$filename."上传成功!";
}else{
echo "文件".$filename."上传失败!";
}
}else{
switch ($error){
case 1:echo "超过了上传文件的最大值，请上传2M以下文件";break;
case 2:echo "上传文件过多，请一次上传20个及以下文件！";break;
case 3:echo "文件并未完全上传，请再次尝试！";break;
case 4:echo "未选择上传文件！";break;
case 7:echo "没有临时文件夹";break;
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="post" action="?" enctype="multipart/form-data">
上传文件:<input type="file" name="myFile"></br></br>
<input type="hidden" value="1" name="go">
<input type="submit" value="上传"></br></br>
</form>
</body>
</html>Do it on this page Process the uploaded file
We then look down at the code of the modifyproduct.php file
<?php
require_once('conn.php');
$id = $_GET['id'];
$title = $_POST['title'];
$imagename = $_POST['imgname'];
$price = $_POST['price'];
$goodtime = time();
$sql = "UPDATE product SET title='$title',imgname='$imagename',price='$price',goodtime='$goodtime' where id='$id'";
$res = mysql_query($sql);
if($res){
echo "<script>alert('修改产品成功');location.href='product.php'</script>";
}else{
echo "<script>alert('修改产品失败');history.go(-1);</script>";
}
?>Based on the above code, we have completed the product modification function
new file
<?php
require_once('conn.php');
$id = $_GET['id'];
$sql = "SELECT * from product where id= '$id'";
$res = mysql_query($sql);
$info = mysql_fetch_array($res);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>修改产品</title>
<style type="text/css">
#cnt{
width:400px;
height:400px;
margin-top:15px;
margin-left: 15px;
}
iframe{border:0px;}
</style>
</head>
<body>
<div id="cnt">
<form method="post" action="modifyproduct.php?id=<?php echo $info['id']?>" enctype="multipart/form-data">
产品名称:<input type="text" name="title" id="title" value="<?php echo $info['title']?>"></br></br>
<iframe src="file.php"></iframe>
<input type="text" id="imgname" name="imgname" value="<?php echo $info['imgname'];?>"></br></br>
产品价格:<input type="text" name="price" value="<?php echo $info['price']?>">
</br></br>
<input type="submit" value="修改产品">
</form>
</div>
</body>
</html>
Preview
Clear
- Course Recommendations
- Courseware download
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~
Students who have watched this course are also learning
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)