Modifying MySQL Where Statement Based on Array

Question

Using an array like this:

$data = array
     (
       'host' => 1,
       'country' => 'fr',
     )

I would like to create a MySQL query that uses the values of the array to form its WHERE clause like:

SELECT *
FROM table
WHERE host = 1 and country = 'fr'

How can I generate this query string to use with MySQL?

Kerry Jones · Accepted Answer · 2010-05-23 02:06:35Z

4

Try this

$where = '';

foreach( $data as $k => $v ) {
    if( !empty( $where ) )
        $where .= ' AND ';

    $where .= sprintf( "`%s` = '%s'", mysql_real_escape_string( $k ), mysql_real_escape_string( $v ) );
}

mysql_query( "SELECT * FROM `table` WHERE $where" );

edited May 23, 2010 at 2:06

answered May 22, 2010 at 21:39

Kerry Jones

21.8k12 gold badges67 silver badges89 bronze badges

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

Comments

Andy Lester · Accepted Answer · 2010-06-03 16:29:56Z

0

Please please please don't build SQL statements with embedded data. Look here: http://bobby-tables.com/php.html

answered Jun 3, 2010 at 16:29

Andy Lester

94.2k16 gold badges106 silver badges162 bronze badges

Collectives™ on Stack Overflow

Modifying MySQL Where Statement Based on Array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related