Page 1 of 1

PDO bindParam problems

Posted: Fri Feb 22, 2008 1:24 pm
by staar2
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. :roll:

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();
 

Re: PDO bindParam problems

Posted: Fri Feb 22, 2008 4:51 pm
by RobertGonzalez
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.

Re: PDO bindParam problems

Posted: Sat Feb 23, 2008 2:24 am
by staar2
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);