数据不会使用php和mamp插入到Db中 - Data is not inserted into Db using php and mamp

Data is not inserted into Db using php and mamp

本文关键字：插入 mamp Db php 数据 | 更新日期: 2023-09-27

我使用下面的代码将数据输入到我的数据库中，但即使数据没有插入到数据库中，也没有生成错误。请帮我

<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpassword = "root";
$conn = mysqli_connect($dbhost, $dbuser, $dbpassword);
if(! $conn )
{
  die('Could not connect: ' . mysqli_error());
}
$post_enroll = $_POST['enroll'];
$post_mobile = $_POST['mobile'];
$post_email = $_POST['email'];
$post_password = $_POST['password'];
$sql = "INSERT INTO login (enroll, mobile, email, password) VALUES ('".$post_enroll."','".$post_mobile."','".$post_email."','".$post_password."')";
mysqli_select_db('rgpv');
$retval = mysqli_query( $sql, $conn );
if(! $retval )
{
  die('Could not enter data: ' . mysqli_error());
}
mysqli_close($conn);
?>

更改

mysqli_select_db('rgpv');
$retval = mysqli_query( $sql, $conn );

至

mysqli_select_db($conn , "rgpv");
$retval = mysqli_query( $conn , $sql);

代替使用：

if(! $retval )

用途：

if (mysqli_errno($conn) != 0){

SO中的许多专家强烈建议不要使用mysql/i函数。他们的建议是接受PDO。不过我还是同意他们的建议。在这种情况下；我建议如下：

<?php   
    //DATABASE CONNECTION CONFIGURATION:
    defined("HOST")     or define("HOST",   "localhost");           //REPLACE WITH YOUR DB-HOST
    defined("DBASE")    or define("DBASE",  "rgpv");                //REPLACE WITH YOUR DB NAME
    defined("USER")     or define("USER",   "root");                //REPLACE WITH YOUR DB-USER
    defined("PASS")     or define("PASS",   "root");                //REPLACE WITH YOUR DB-PASS

    $post_enroll    = isset($_POST['enroll'])   ? htmlspecialchars(trim($_POST['enroll']))      : null;  //PROTECT AGAINST ATTACKS
    $post_mobile    = isset($_POST['mobile'])   ? htmlspecialchars(trim($_POST['mobile']))      : null;  //PROTECT AGAINST ATTACKS
    $post_email     = isset($_POST['email'])    ? htmlspecialchars(trim($_POST['email']))       : null;  //PROTECT AGAINST ATTACKS
    $post_password  = isset($_POST['password']) ? htmlspecialchars(trim($_POST['password']))    : null;  //PROTECT AGAINST ATTACKS
    try {
        $dbh        = new PDO('mysql:host='.HOST.';dbname='. DBASE,USER,PASS);
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $stmt       = $dbh->prepare("INSERT INTO login (`enroll`, `mobile`, `email`, `password`) VALUES (:enroll, :mobile, :email, :password)");
        $stmt->bindParam(':enroll',     $post_enroll);
        $stmt->bindParam(':mobile',     $post_mobile);
        $stmt->bindParam(':email',      $post_email);
        $stmt->bindParam(':password',   $post_password);
        $status     = $stmt->execute();
        if(! $status ) {
            die('Something went wrong...');
        }
        //GARBAGE COLLECTION
        $dbh        = null;
    }catch(PDOException $e){
        echo $e->getMessage();
    }
?>

我希望这能有所帮助。。。