How to call this php function

Question

// Gets a single row from $from where $where is true    
    function Select($from, $where='', $orderBy='', $limit='', $like=false, $operand='AND',$cols='*'){

Let's say I created the object  - 
$oMySQL = new MySQL();

$oMySQL->Select();

if I was doing this query `- SELECT * FROM users where email='$email'"`

I can do insert and all the others - But I am confused how to make the select();

Thanks for the help.

$oMySQL.Select('tbl', "tbl.field = 'value'", 'tbl.name', '0,25'); — Jared Farrish
– Jared Farrish, Commented Jul 27, 2013 at 16:08

Tobias Golbs · Accepted Answer · 2013-07-27 16:07:51Z

1

Since i do not know how the Select function is implemented i would assume something like this:

$oMySQL->Select('users', "email='$email'");

answered Jul 27, 2013 at 16:07

Tobias Golbs

4,6164 gold badges31 silver badges50 bronze badges

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

2 Comments

Kyle Over a year ago

Don't forget to escape values that come from users. You can mysql_real_escape_string. Or end up using something like MySQL PDO or MySQLi since they allows for parametized expressions.

Tobias Golbs Over a year ago

Yes that is right. I should have mentioned that. But since this looks like a framework method, i assumed that this is the case.

Collectives™ on Stack Overflow

How to call this php function

if I was doing this query `- SELECT * FROM users where email='$email'"`

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

if I was doing this query - SELECT * FROM users where email='$email'"

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related

if I was doing this query `- SELECT * FROM users where email='$email'"`