empty echo

Prepared Statements

[bethesda]

$db = new mysqli('X', 'X', 'X', 'X');
$db -> query("SET NAMES 'latin2'");
$stmt = $db->stmt_init();
if($stmt->prepare("DELETE FROM `a` WHERE `b` = ?")) {
$stmt->bind_param('s', $x);
$x = "$user";
$stmt->execute(); 
if (!$stmt) {
$feedback1 = die(mysql_error());
echo "myscript.php error #209 $feedback1";
$stmt->close(); 
$db->close(); 
}} else {
echo "something";
echo "something2";
}
$stmt->close(); 
$db->close(); 

Well - I do not receive the result of echo - (something and something2)..
Why ?

[penders]

"something" would only echo if your prepare() statement failed. Should it fail?

[bethesda]

But this code is responsible for the failure:

if (!$stmt) {
$feedback1 = die(mysql_error());
echo "myscript.php error #209 $feedback1";

yes ?

[bethesda]

Ok i think i get it.
This work's fine:

$db = new mysqli('X', 'X', 'X', 'X');
$db -> query("SET NAMES 'latin2'");
$stmt = $db->stmt_init();
if($stmt->prepare("DELETE FROM `a` WHERE `b` = ?")) {
$stmt->bind_param('s', $x);
$x = "$user";
$stmt->execute(); 
if ($stmt) {
echo "something";
echo "something2";
} else {
$feedback1 = die(mysql_error());
echo "myscript.php error #209 $feedback1";
$stmt->close(); 
$db->close(); 
}}
$stmt->close(); 
$db->close(); 

[eelixduppy]

FYI, die() does not have a return value. Should instead be something along the lines of this:

echo sprintf("myscript.php error #209 %s\n", mysql_error());

[bethesda]

I keep it in mind. Thanks.