PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
staar2
Forum Commoner
Posts: 83 Joined: Fri Apr 06, 2007 2:57 am
Post
by staar2 » 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();
RobertGonzalez
Site Administrator
Posts: 14293 Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA
Post
by RobertGonzalez » Fri Feb 22, 2008 4:51 pm
In a situation like this
var_dump() can be your friend. Trying using it on both $db and $stmt and see what you get back.
staar2
Forum Commoner
Posts: 83 Joined: Fri Apr 06, 2007 2:57 am
Post
by staar2 » Sat Feb 23, 2008 2:24 am
oh it was my mistake, i knew that the language var comes from $_Get put still i used $_post.
$stmt->bindValue(':lang', $_GET['language'], PDO::PARAM_STR);