无法将数据插入数据库(php/mysqli)(Phpstorm 9/Wamp)


Cannot insert data into database (php/mysqli) (Phpstorm 9/Wamp)

我在将从其中一个表单收集的数据插入数据库时遇到问题。每个表单都将数据添加到数据库中的不同表中(一个添加到用户中,一个添加任务中)。

我使用一个表格进行注册,我会粘贴下面代码的重要部分(这个正在工作)。这是Register.php文件的表单部分

<form method="post" action="register_code.php">
<div class="FormElement">
    <input name="user_name" type="text" class="Tfield" id="user_name" required placeholder="User Name">
</div>
<div class="FormElement">
    <input name="password" type="password" class="Tfield" id="password" required placeholder="Password">
</div>
<div class="FormElement">
    <input name="email" type="email" class="Tfield" id="email" required placeholder="E-mail">
</div>
<div class="FormElement">
    <input name="first_name" type="text" class="Tfield" id="first_name" required placeholder="First Name">
</div>
<div class="FormElement">
    <input name="last_name" type="text" class="Tfield" id="last_name" required placeholder="Last Name">
</div>
<div class="FormElement">
    <input type="submit" id="Register" name="Register" value="Register" class="button">
</div>

这是register_code.php文件

  <?php
require "DBconnect.php";
$post = $_POST;
if(isset($post)) {
    session_start();
    $UName = $post['user_name'];
    $PW = md5($post['password']);
    $FName = $post['first_name'];
    $LName = $post['last_name'];
    $Email = $post['email'];
    $sql = $con->query("INSERT INTO users (user_name, password, email, first_name, last_name) VALUES ('$UName','$PW','$Email', '$FName', '$LName')");
    if($sql)
        header("Location: Registration_successful.php");
    else
        echo "Please try again to register";
}
include 'Register.php';

以及我用来将数据添加到另一个表中的另一种形式(命名任务)。由于某种原因,我从该文件收集的数据将不会插入到我的数据库中。

这是Add_Task.php文件的表单部分:

    <form method="post" action="Add_Task_code.php">
    <div class="FormElement">
        <input name="TName" type="text" class="Tfield" id="TName" required placeholder="Task name">
    </div>
    <div class="FormElement">
        <input name="TDesc" type="text" class="TextField" id="TDesc" required placeholder="Task summary">
    </div>
    <div class="FormElement">
        <input type="submit" id="Submit" name="Submit" value="Submit" class="button">
    </div>
</form>

这是来自Add_Task_code.php文件的代码

  <?php
require 'DBconnect.php';
$post=$_POST;
if(isset($post))
{
    $TaskName = $post['TName'];
    $TaskDesc = $post['TDesc'];
    $sqltask="INSERT INTO tasks ('TName','TDesc') VALUES ('$TaskName','$TaskDesc')";
    if ($con->query($sqltask))
        header("Location: Tasks.php");
    else
        header("Location: Add_Task.php");
}
?>

文件DBconnect.php仅包含以下内容:

   <?php
$con= mysqli_connect("localhost", "root","","first_app")
?>

问题是,尽管两种形式的代码相似,但只有一种可以工作。每次我运行Add_Task.php文件时,它都会将我重定向到同一个页面(按照我的指示),因为它不会向数据库中添加任何内容。

我也检查了表格,以防它添加了什么,但没有。

请在表任务中将primary_key(id)设置为自动递增。如果你不设置,这可能是可能的。并更改这条线路

$sqltask="INSERT INTO tasks ('TName','TDesc') VALUES ('$TaskName','$TaskDesc')";

像这样:

$sqltask="INSERT INTO tasks (TName,TDesc) VALUES ($TaskName,$TaskDesc)";

您在代码中混合了OOP styleProcedural Style

您在DBconnect.php文件中使用了Procedural Style。并且您的连接文件中缺少;

DBconnect.php文件应该是:

<?php    
   $con= mysqli_connect("localhost", "root","","first_app");    
?>

register_code.php代码应为:

<?php
require "DBconnect.php";
$post = $_POST;
if(isset($post)) {
    session_start();
    $UName = $post['user_name'];
    $PW = md5($post['password']);
    $FName = $post['first_name'];
    $LName = $post['last_name'];
    $Email = $post['email'];
    $sql = mysqli_query($con,"INSERT INTO users (user_name, password, email, first_name, last_name) VALUES ('$UName','$PW','$Email', '$FName', '$LName')");
    if($sql)
        header("Location: Registration_successful.php");
    else
        echo "Please try again to register";
}
include 'Register.php';

Add_Task_code.php文件代码应为:

<?php
require 'DBconnect.php';
$post=$_POST;
if(isset($post))
{
    $TaskName = $post['TName'];
    $TaskDesc = $post['TDesc'];
    $sqltask="INSERT INTO tasks ('TName','TDesc') VALUES ('$TaskName','$TaskDesc')";
    if (mysqli_query($con,$sqltask))
        header("Location: Tasks.php");
    else
        header("Location: Add_Task.php");
}
?>

尝试进行以下更改,看看实际错误是什么。然后调试代码。

if($_SERVER['REQUEST_METHOD']=='POST')
{
   $TaskName = $post['TName'];
   $TaskDesc = $post['TDesc'];
   $sqltask="INSERT INTO tasks ('TName','TDesc') VALUES ('$TaskName','$TaskDesc')";
   if ($con->query($sqltask))
     echo "Successfully Inserted";
   else
     echo "Error: " . $sqltask. "<br>" . mysqli_error($conn);
}
?>