Passing Objects to a function

Question

I had a function that escapes data before performing SQL statements. Now Problem is I have 4 databases, So how can I pass database object to function.

function escape($what) 
{
global $db;

foreach ($what as $variable => $value)
{
    if (is_string($value) || is_numeric($value))
    {

        $GLOBALS[$variable] = $db->real_escape_string();
    }
    else
    {
        $GLOBALS[$variable] = $value;
    }
}
}

To escape sql statements, its recommended to use prepared statements. Al the escaping is done for you that way so you dont have to invent the wheel again. Look for mysql::prepare(); On php.net — HansElsen
– HansElsen, Commented Sep 6, 2012 at 20:05

Jocelyn · Accepted Answer · 2012-09-06 20:02:27Z

1

Just add another parameter to your function:

function escape($db, $what)

And change the calls to the function.

answered Sep 6, 2012 at 20:02

Jocelyn

11.4k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Passing Objects to a function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related