MySQLi If condition alert msg not showing the outp

问题:

Below Given code working perfect. Db table also values are inserted. But Echo Message not showing in output

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'admin');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
if(isset($_POST["register"]))
{
    $id = $_POST["id"];
    $name = $_POST["user_name"];
    $password = $_POST["password"];
    $query = mysqli_query($db, "INSERT INTO user (id, user_name, password)VALUES ('$id', '$name', '$password')");
    $result = mysqli_query($query);

 if($result)
{
    echo "Thank You! you are now registered.";
}
}

?>

回答1:

You called mysqli_query 2 times and second time in wrong way, you just need to call it once instead

// Change
$query = mysqli_query($db, "INSERT INTO user (id, user_name, password)VALUES ('$id', '$name', '$password')");
$result = mysqli_query($query);

// To
$result = mysqli_query($db, "INSERT INTO user (id, user_name, password) VALUES ('$id', '$name', '$password')");

// And change your condition to 
if( mysqli_affected_rows($db) ){
 ..
}

回答2:

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'admin');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
if(isset($_POST["register"]))
{
    $id = $_POST["id"];
    $name = $_POST["user_name"];
    $password = $_POST["password"];
    $result = mysqli_query($db, "INSERT INTO user (id, user_name, password)VALUES ('$id', '$name', '$password')");


 if($result)
{
    echo "Thank You! you are now registered.";
}
}

回答3:

this Code working corrrectly

   <?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'admin');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
if(isset($_POST["register"]))
{
    $id = $_POST["id"];
    $name = $_POST["user_name"];
   $password = $_POST["password"];
    $result = mysqli_query($db, "INSERT INTO user (id, user_name, password)VALUES ('$id', '$name', '$password')");


 if($result)
{
    echo "<script>alert('User Register Successfully Go to login!')</script>";
    echo "<script>window.open('index.php','_self')</script>";
}
}
?>

回答4:

its work properly once it insert the record then it print

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'test');
$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE) or  die("Error") ;
if(isset($_POST["register"]))
{
    $id = $_POST["id"];
    $name = $_POST["unm"];
    $password = $_POST["pass"];
    $query = mysqli_query($db,"INSERT INTO user (id,user_name,password)VALUES ('$id','$name','$password')");

    if($query)
    {
        echo "Thank You! you are now registered.";
    }
}

回答5:

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', 'hrhk');
define('DB_DATABASE', 'test');

$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

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

$id = $_POST["id"];
$name = $_POST["user_name"];
$password = $_POST["password"];
$result = mysqli_query($db, "INSERT INTO user (id, user_name, password) VALUES   ('$id', '$name', '$password')");

if($result)
{
echo "Thank You! you are now registered.";
}
}