PHP在提交时不会将sql数据发送到数据库？

问题描述：

I am new to PHP and I am making a insert function which will insert the html input into my Sql database but at the moment when I submit nothing happens and no information is entered into the database. Any help on how I can get the in-putted information to submit to the database would be greatly appreciated.

<html>
<head>

</head>
<body>

  <div align = "center">


           <form method = "POST" class="basic-grey">
           <h1><i>Insert</i></h1>
              <label>Title  :<input type = "text" name="title"/></label>
              <label>Content  :<input type = "text" name="content"/></label>
              <label>User  :<input type = "text" name="user"/></label>

              <label><input type = "submit" value = "submit"/></label>
           </form> 

           <div style = "font-size:11px; color:#cc0000; margin-top:10px"><?php echo $error ?></div>

           </div>
</html>
<?php

include_once 'db_config.php';

session_start();
if (!(isset($_SESSION['login_user']) && $_SESSION['login_user'] != '')) {

header ("Location: login2.php");

 }


if(isset($_POST["submit"])) {



$title = $_POST['title'];
$content = $_POST['content'];
$user = $_POST['user'];

$sql = "INSERT INTO 'diary' ('ID', 'TITLE', 'CONTENT', 'USER') 
VALUES (NULL, '$title','$content', '$user',)";

if ($conn->query($sql) === TRUE) {
header("location: results.php");
 } else {
 echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();


?>

我是PHP的新手，我正在制作一个插入函数，它将html输入插入我的Sql数据库，但是当我提交没有任何反应的时刻，没有信息输入数据库。关于如何获取提交到数据库的输入信息的任何帮助将不胜感激。 p>

 ＆lt; html＆gt; 
＆lt; head＆gt; 
 
＆lt;  / head＆gt; 
＆lt; body＆gt; 
 
＆lt; div align =“center”＆gt; 
 
 
＆lt; form method =“POST”class =“basic-grey”＆gt; 
＆lt; h1＆gt;  ;＆lt; i＆gt;插入＆lt; / i＆gt;＆lt; / h1＆gt; 
＆lt; label＆gt;标题：＆lt; input type =“text”name =“title”/＆gt;＆lt; / label＆gt; 
＆lt; label＆gt; 内容：＆lt; input type =“text”name =“content”/＆gt;＆lt; / label＆gt; 
＆lt; label＆gt;用户：＆lt; input type =“text”name =“user”/＆gt;＆lt; / 标签＆gt; 
 
＆lt; label＆gt;＆lt; input type =“submit”value =“submit”/＆gt;＆lt; / label＆gt; 
＆lt; / form＆gt;  
 
＆lt; div style =“font-size：11px; color：＃cc0000; margin-top：10px”＆gt;＆lt;？php echo $ error？＆gt;＆lt; / div＆gt; 
 
＆lt;  / div＆gt; 
＆lt; / html＆gt; 
＆lt;？php 
 
include_once'db_config.php'; 
 
session_start（）; 
if（！（isset（$ _ SESSION ['login_user']）＆amp;＆amp;  $ _SESSION ['login_user']！=''））{
 
header（“Location：login2.php”）; 
 
} 
 
 
if（isset（$ _ POST [“submit”]）  ）{
 
 
 
 $ title = $ _POST ['title']; 
 $ content = $ _POST ['content']; 
 $ user = $ _POST ['user']; 
 \  n $ sql =“INSERT INTO'日记'（'ID'，'TITLE'，'CONTENT'，'USER'）
VALUES（NULL，'$ title'，'$ content'，'$ user'，）”;  
 
if（$ conn-＆gt; query（$ sql）=== TRUE）{
header（“location：results.php”）; 
} else {
 echo“错误：”。  $ sql。  “＆LT峰; br＆gt;” 中 。  $ conn-＆gt;错误; 
} 
} 
 $ conn-＆gt; close（）; 
 
 
？n？＆gt; 
  code>  pre> 
  div>

答

Your script doesn't won't work because you don't have anything named 'submit' for if(isset($_POST["submit"])) { to test. Fix that by naming your submit button:

<label><input type="submit" name="submit" value="submit"/></label>

Once clicked now the button's name will appear in the $_POST array.

In addition: session_start() should be right after your opening PHP tag.

Your script is at risk for SQL Injection Attacks. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy.

Your error checking will reveal that you have quoted instead of back ticked table and column names and that you have an extra comma. Change your insert query as follows:

$sql = "INSERT INTO `diary` (`ID`, `TITLE`, `CONTENT`, `USER`) VALUES (NULL, '$title','$content', '$user')";

答

You are using invalid mysql syntax. You are using wrong string literal ' for table name and columns name. You can use this ` , or no literal at all.

Option 1 :

$sql = "INSERT INTO `diary` (`ID`, `TITLE`, `CONTENT`, `USER`) VALUES (NULL, '$title','$content', '$user')";

Option 2 :

$sql = "INSERT INTO diary (ID, TITLE, CONTENT, USER) VALUES (NULL, '$title','$content', '$user')";

答

maybe you didn't use name of 'submit' for executed like :

<input type="submit" **name="simpan"** value="SIMPAN"/>

PHP在提交时不会将sql数据发送到数据库？

相关推荐