Code not extracting data from DB

[A2enMOD]

Hi guys,

 

I am having trouble with the following code that I put together. It is not getting any data from the DB, can you see if I have made any errors in my syntax?

 

// DATABASE FUNCTION //Search database for pages matching the current
// page and display the title, description and keywords


$page = isset($_GET['page']) ? $_GET['page'] : 'home';



if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}


if($stmt = $mysqli->prepare("SELECT * FROM url WHERE page=? LIMIT 1")) {


$stmt -> bind_param("s",$page);


$stmt -> execute();


$sql = $stmt;


if ($sql->num_rows > 0) {
while ($row = $sql->fetch_object())
{
$title = $row->title;
$description = $row->descr;
$keywords = $row->keywords;


}


} else {


$title = 'Set Default Title';
$description = 'Set Default Description';
$keywords = 'Set Default Keywords';


$stmt -> close();
}
}
$mysqli -> close();

[Barand]

check for error after executing the query

[A2enMOD]

check for error after executing the query

 

So I dont understand what you mean?

[Christian F.]

This post will help you:

http://forums.phpfreaks.com/index.php?topic=365029.msg1730174#msg1730174

[Barand]

$res = $stmt->execute();
if (!$res)
   die($stmt->error);