Hi,
These 3 ways of coding works.
Which one you recommend and why ?
I would prefer if you rank these 3 where best on top.
Note that, I am checking in 3 different ways if INSERTION into Mysql DB was successful or not. Spoiled for choice whcih one to use. Wish to use the one where no room for issues will arise.
1.
[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect(“localhost”,”root”,””,”buzz”); //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_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
2.
[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect(“localhost”,”root”,””,”buzz”); //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_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
3.
[code]
mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect(“localhost”,”root”,””,”buzz”); //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_error();
echo ‘<br>’;
echo ‘Mysqli Error No: ‘ .mysqli_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);