| |
问题是,即使我使用方法POST,当它调用addScript.php时,使用的方法实际上是GET,我的链接是www.domain.com/addScript.php?name=..&description=... etc.
和如果我$name=$_REQUEST['title'];
在php文件中使用,我得到这个错误:.Undefined index: title in /home/domain/public_html/addScript.php on line 13
我如何解决这个问题?
编辑
这是我没有mysqli_connect()的PHP;
$name=$_POST['title'];
$description=$_POST['description'];
$price=$_POST['price'];
$profilePic=$_FILES['profilepic']['name'];
$path="images/";
//move picures in images/ folder and get their path
$pic1=$_FILES['pic1']['name'];
$pictmp=$_FILES['pic1']['tmp_name'];
$moveResult=move_uploaded_file($pictmp, $path);
$pic2=$_FILES['pic2']['name'];
$pictmp=$_FILES['pic2']['tmp_name'];
$moveResult=move_uploaded_file($pictmp, $path);
$pic3=$_FILES['pic3']['name'];
$pictmp=$_FILES['pic3']['tmp_name'];
$moveResult=move_uploaded_file($pictmp, $path);
$pic1Path=$path.$pic1;
$pic2Path=$path.$pic2;
$pic3Path=$path.$pic3;
//insert info in database
$sql="INSERT INTO products ( name, description, price, profile_pic, pic1, pic2, pic3)
VALUES
('$name','$description','$price',$profilePic','$pic1Path','$pic2Path','$pic3Path')";
if(!mysqli_query($con,$sql)){
die("ERROR ".mysqli_error($con));
}
我总是得到这个错误
ERROR You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'images/','images/','images/')' at line 3
重新编辑:
现在我可以看到确认回显,但它填充了我的error_log这些错误,数据库中的列大多是空的.
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: title in /home/domain/public_html/addScript.php on line 13
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: description in /home/domain/public_html/addScript.php on line 14
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: price in /home/domain/public_html/addScript.php on line 15
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: profilepic in /home/domain/public_html/addScript.php on line 16
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic1 in /home/domain/public_html/addScript.php on line 20
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic1 in /home/domain/public_html/addScript.php on line 21
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic2 in /home/domain/public_html/addScript.php on line 24
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic2 in /home/domain/public_html/addScript.php on line 25
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic3 in /home/domain/public_html/addScript.php on line 28
[05-Feb-2014 15:01:12 UTC] PHP Notice: Undefined index: pic3 in /home/domain/public_html/addScript.php on line 29
再重新编辑
我var_dump($_REQUEST);
在$ name之前添加了PHP文件并得到了它
array(7) { ["name"]=> string(4) "aaaa" ["description"]=> string(7) "aaaaaaa" ["price"]=> string(3) "555" ["profilepic"]=> string(7) "cr7.jpg" ["pic1"]=> string(9) "copac.jpg" ["pic2"]=> string(9) "close.png" ["pic3"]=> string(12) "obiectiv.jpg" } 1 product added
但DB中的列仍为空.
1 个回答
-
您的表单中有拼写错误.您键入methot
而不是method
:
<form action="addScript.php" methot="POST" enctype="multipart/form-data">
应该
<form action="addScript.php" method="POST" enctype="multipart/form-data">
更新
您在SQL查询中缺少引号:
('$name','$description','$price',$profilePic','$pic1Path','$pic2Path','$pic3Path')";
^^^^^
HERE
应该
('$name','$description','$price','$profilePic','$pic1Path','$pic2Path','$pic3Path')";
^^^^^
HERE
2023-01-29 11:15 回答
氣質正妹_384