query() Dosent Work Inside a Function

Question

I'm making a script using PHP and PDO syntax. And before I start I wanted to make some shortcuts for me. $db->query() = qr() and $string->fetch(PDO::FETCH_OBJ) = fet($string)

but a problem pops up on my page, that query() doesn't work inside a function

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

Here's my code

// $db->query() = qr()
function qr($str)
{
    return $db->query($str);
}
// $string->fetch(PDO::FETCH_OBJ) = fet($string)
function fet($dbq)
{
    return $dbq->fetch(PDO::FETCH_OBJ);
}

$qr = qr("select * from example");
$fet = fet($qr);

echo "".$fet->example."";

http://stackoverflow.com/q/16959576/285587 – Your Common Sense Jul 11 '13 at 06:17 — Your Common Sense, Jul 11 '13 at 06:17

score 3 · Accepted Answer · edited May 23 '17 at 11:52

3

Because $db is not available in function. You have to pass it via function parameter.

function qr($db, $str)
{
    return $db->query($str);
}

Don't use Global variable

edited May 23 '17 at 11:52

Community

1
1

answered Jul 11 '13 at 06:18

Yogesh Suthar

29,554
17
66
96

Any reason to downvote? – Yogesh Suthar Jul 11 '13 at 06:19
These 2 users seem suspicious. Hmm – Jm Verastigue Jul 11 '13 at 06:22
@JmVerastigue Which 2 users? – Yogesh Suthar Jul 11 '13 at 06:23
1

Us eR and user. Both created 2 days ago and have the same picture. Almost same username too. – Jm Verastigue Jul 11 '13 at 06:24
@JmVerastigue It may be coincidence. – Yogesh Suthar Jul 11 '13 at 06:26

query() Dosent Work Inside a Function

1 Answers1