Trying to put an array into my query mysql wordpress

Question

I am trying to input an array into my query. I am using Wordpress.
For security purposes, I need to use %s.

If I don't use %s, and put the $results directly inside the query, it works.
But if I use %s, it doesn't work.

What am I doing wrong?

<?php
/*$sym_result is an array*/

$result = implode("','",$sym_result); 
$results = "'".$result."'";

$sql = $wpdb->get_results( $wpdb->prepare("
    SELECT DISTINCT fruit FROM dis WHERE fruit IN (%s)
            ",$results));
print_r($sql);/*echo array()*/
?>

stackoverflow.com/questions/10634058/…

Kevin
– Kevin

2016-08-01 23:53:01 +00:00
Commented Aug 1, 2016 at 23:53 — Kevin
– Kevin, Commented Aug 1, 2016 at 23:53

Punkfluff · Accepted Answer · 2016-08-02 03:30:28Z

1

Try this for your SQL statement:

SELECT DISTINCT fruit FROM dis WHERE fruit IN ("%s", "$results")

It's unclear from your question if you are wanting to use "%s" in lieu of "$results" or in addition? Either way it's the inverted commas that could be the issue I reckon.

Otherwise have you tried LIKE xxx OR xxx instead of IN? I have a feeling IN doesn't allow wildcards.

answered Aug 2, 2016 at 3:30

Punkfluff

112 bronze badges

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

Collectives™ on Stack Overflow

Trying to put an array into my query mysql wordpress

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related