时间戳

首页 > 解决方案 > 表单数据未插入 MySQL 数据库

php - 表单数据未插入 MySQL 数据库

问题描述

表单数据未插入 MYSQL 中。表单成功发布数据（我已经检查了 var dump）。请帮我解决一下这个。
这是我的行动PHP。

<?php 
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname= "test";
    $conn = new mysqli($servername,$username,$password,$dbname);

    if($conn->connect_error){
    die("connection failed:" .$conn->connect_error);
    }
    else{
        echo "Connected successfully";
    }
    $selected = mysqli_select_db($conn,$dbname);



        $first_name = $_POST['first_name'];
        $last_name = $_POST['last_name'];
        $email = $_POST['email'];
        $mobile = $_POST['mobile'];
        $address = $_POST['address'];
        //$gender = $_POST['male'];
        //$gender = $_POST['female'];

    $sql =  "INSERT INTO test1 (first_name,last_name,email,mob,home_address) VALUES ('$first_name','$last_name','$email','$mobile','$address')";

    var_dump($sql);
    ?>

标签： php

解决方案

您缺少执行查询以保存数据的最后一部分：

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

推荐阅读