How To Check INSERTION Success ?

Hi,

I coded 3 ways but not sure which is correct way as all worky.
I reckon my 1st one is best. What do you say ?
Need to check if INSERT succeeded or not.

1.

[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

$conn = mysqli_connect(“localhost”,”root”,””,”gulf”); //mysqli_connect(“server”,”user”,”password”,”db”);

$input_1 = ‘mogambo’; //username.
$input_2 = ‘[email protected]’; //email.

$sql = “INSERT into users (username,email) VALUES (?,?)”;

if($stmt = mysqli_prepare($conn,$sql))
{
mysqli_stmt_bind_param($stmt,”ss”,$input_1,$input_2);

if(mysqli_stmt_execute($stmt))
{
echo ‘INSERTING SUCESSFULLY: ‘ .mysqli_stmt_affected_rows($stmt);
}
else
{
echo ‘Mysqli Error: ‘ .mysqli_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
echo ‘<br>’;
die(‘Failed to INSERT!’);
}
}
else
{
echo ‘Mysqli Error: ‘ .mysqli_stmt_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_stmt_errno();
}

mysqli_stmt_close($stmt);
mysqli_close($conn);
[/code]

2.

[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

$conn = mysqli_connect(“localhost”,”root”,””,”gulf”); //mysqli_connect(“server”,”user”,”password”,”db”);

$input_1 = ‘mogambo’; //username.
$input_2 = ‘[email protected]’; //email.

$sql = “INSERT into users (username,email) VALUES (?,?)”;

if($stmt = mysqli_prepare($conn,$sql))
{
mysqli_stmt_bind_param($stmt,”ss”,$input_1,$input_2);
mysqli_stmt_execute($stmt);

if(mysqli_stmt_affected_rows($stmt))
{
echo ‘INSERTING SUCESSFULLY: ‘ .mysqli_stmt_affected_rows($stmt);
}
else
{
echo ‘Mysqli Error: ‘ .mysqli_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
echo ‘<br>’;
die(‘Failed to INSERT!’);
}
}
else
{
echo ‘Mysqli Error: ‘ .mysqli_stmt_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_stmt_errno();
}

mysqli_stmt_close($stmt);
mysqli_close($conn);
[/code]

3.

[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);

$conn = mysqli_connect(“localhost”,”root”,””,”gulf”); //mysqli_connect(“server”,”user”,”password”,”db”);

$input_1 = ‘mogambo’; //username.
$input_2 = ‘[email protected]’; //email.

$sql = “INSERT into users (username,email) VALUES (?,?)”;

if($stmt = mysqli_prepare($conn,$sql))
{
mysqli_stmt_bind_param($stmt,”ss”,$input_1,$input_2);
mysqli_stmt_execute($stmt);
echo ‘INSERTING SUCESSFULLY: ‘ .mysqli_stmt_affected_rows($stmt);
}
else
{
echo ‘Mysqli Error: ‘ .mysqli_stmt_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_stmt_errno();
}

mysqli_stmt_close($stmt);
mysqli_close($conn);
[/code]

Also in #PHP _↴