我制作了一个包含26个字段的表单,其中包括6个图像。使用PHP语言,我使用输入类型submit提交表单,然后发布所有值,但数据库中的条目没有完成。
显示此错误:G:'xampp'tmp'php9506.tmp
在错误中,用PHP编写的数字9506
是随机数,每次我尝试提交表单时它都会发生变化。
我的数据库和连接文件是正确的。
可能的原因是什么?
<?php
include "header.php";
include "left.php";
$busi_cat = $_GET['mcatname'];
if(isset($_POST) && $_POST['add'] == "Add")
{
extract($_POST);
$adver_type = implode(',',$adver_type);
echo $busi_cat = $_GET['mcatname'];
if ($_FILES["photo1"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
echo $source = $_FILES["photo1"]['tmp_name'];
$photo1 = "images/client/".$_FILES["photo1"]['name'];
if(move_uploaded_file($source, $photo1))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
if ($_FILES["photo2"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
$source = $_FILES["photo2"]['tmp_name'];
$photo2 = "images/client/".$_FILES["photo2"]['name'];
if(move_uploaded_file($source, $photo2))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
if ($_FILES["photo3"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
$source = $_FILES["photo3"]['tmp_name'];
$photo3 = "images/client/".$_FILES["photo3"]['name'];
if(move_uploaded_file($source, $photo3))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
if ($_FILES["photo4"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
$source = $_FILES["photo4"]['tmp_name'];
$photo4 = "images/client/".$_FILES["photo4"]['name'];
if(move_uploaded_file($source, $photo4))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
if ($_FILES["photo5"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
$source = $_FILES["photo5"]['tmp_name'];
$photo5 = "images/client/".$_FILES["photo5"]['name'];
if(move_uploaded_file($source, $photo5))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
if ($_FILES["photo6"]['tmp_name'] != "")
{
if(! file_exists("images/client"))
{
mkdir("images/client");
}
$source = $_FILES["photo6"]['tmp_name'];
$photo6 = "images/client/".$_FILES["photo6"]['name'];
if(move_uploaded_file($source, $photo6))
{
echo "image uploaded succesfully";
}
else
{
echo "problem in uploading";
}
}
else
{
echo "please select a photo";
}
echo $query = "INSERT INTO register(busi_name, busi_cat, busi_scat, oth_busi_cat, addr, cont_per, phone, mobile, emailid, website, deal, keyword, message, adver_plan, photo1, photo2, photo3, photo4, photo5, photo6, status, full_page)VALUES('$busi_name', '$busi_cat', '$busi_scat', '$oth_busi_cat', '$addr', '$cont_per', '$phone', '$mobile', '$emailid', '$website', '$deal', '$keyword', '$message','$adver_type','$photo1','$photo2','$photo3','$photo4','$photo5','$photo6','0', '0')";
$res = mysql_query($query);
if($res)
{
$msg = "Your Business Added Successfully.";
}
}
?>
可能您使用的是$_GET
而不是$_POST
。尝试$_POST['element name']
我认为问题出在提取函数上。
echo $query = "INSERT I....
从该线路上卸下echo
。这是当您看到"随机数"时打印的内容。
如果要打印查询(不推荐),请在$query = "INSERT
行之后添加echo $query;
。
此外,请使用mysqli
和准备好的声明。