PDO bindParam problems
Posted: Fri Feb 22, 2008 1:24 pm
Here's code which returns empty array, when i tested it in mysql it returned correct result, but i think the bindParam() dosen't replace the code.
Code: Select all
$sql = "SELECT
tutorials.id,
tutorials.text,
tutorials.subject,
tutorials.description,
tutorials.date,
languages.language,
users.username
FROM `tutorials`
INNER JOIN languages ON tutorials.language_id = languages.id
INNER JOIN users ON tutorials.user_id = users.id
WHERE languages.language = :lang";
// $conn = mysql_connect('localhost', 'root', '');
// mysql_select_db('andmed');
//
// $result = mysql_query($sql);
//
// while ($row = mysql_fetch_row($result)) {
// $data[] = $row;
// }
//
// var_dump($data);
$stmt = $db->prepare($sql);
$stmt->bindValue(':lang', $_POST['language'], PDO::PARAM_STR);
$stmt->execute();
$data = $stmt->fetchAll();