PDO - Fatal error: Call to a member function prepare() on a non-object

Question

I'm new to PDO so please bear with me. I'm trying to convert my old mysql to PDO but I am getting a "Fatal error: Call to a member function prepare() on a non-object in functions.php on line 5".

So this is functions.php:

<?php
require('config.php');
$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
function getSlug($param){
    $sth = $conn->prepare("SELECT * FROM articles WHERE slug = ?");
    $sth->execute(array($param));
    $slug = $sth->fetchAll(PDO::FETCH_ASSOC);
    return $slug;
}
?>

And this is page that generates the error:

<?php
include('functions.php');
$param = $_GET['param'];
$slug = getSlug($_GET['param']);    
?>

It seems like it's the last line $slug = getSlug($_GET['param']); that's causing the issue but I can't work it out, or it might be something elsewhere. Thanks

PDO apart, you're trying to use a global variable from a function. If you don't get a notice, you haven't configured PHP to display errors. You need to fix that. — Álvaro González, Jan 14 '14 at 12:12

Jon · Accepted Answer · 2014-01-14T12:25:26.150

3

You need to pass $conn into the getSlug function, otherwise it doesn't know what that variable is (and you get your error message):

<?php
require('config.php');
$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );

function getSlug($conn, $param) {
    $sth = $conn->prepare("SELECT * FROM articles WHERE slug = ?");
    $sth->execute(array($param));
    $slug = $sth->fetchAll(PDO::FETCH_ASSOC);
    return $slug;
}
?>

<?php
include('functions.php');
$param = $_GET['param'];
$slug = getSlug($conn, $param);
?>

edited Jan 14 '14 at 12:25

answered Jan 14 '14 at 12:13

Jon

12,016
4
30
44

Updated to reflect that fact. – Jon Jan 14 '14 at 12:25
This is great. Now when I do `` I get everything returned (including 'accept') but when I do `` nothing is returned. Any ideas? – aphextwig Jan 14 '14 at 13:23
1

You'll need to do: `echo $slug[0]['accept'];` to print out the value of the `accept` column from the first row returned... – Jon Jan 14 '14 at 13:40
@aphextwig - That shows that you still haven't enabled error reporting. – Álvaro González Jan 14 '14 at 16:32
@ÁlvaroG.Vicario how do I do that? – aphextwig Jan 15 '14 at 15:22
Here's a [brief explanation](http://stackoverflow.com/a/5680885/13508). – Álvaro González Jan 15 '14 at 15:26

PDO - Fatal error: Call to a member function prepare() on a non-object

1 Answers1