How to add PHP inside SQL Query in PHP file

Question

I have a Array named $category which has values in string format. I want to add it in query such that I can filter the results by category.

Something Like this:

SELECT * FROM ig_accounts WHERE category IN (Array Values here)

So the query becomes something like:

SELECT * FROM ig_accounts WHERE category IN ('text','fashion','sports')

Right now I am using this, which has an error:

$query = "SELECT * FROM ig_accounts WHERE category IN (".
                for($i=0;$i<$category[NULL];$i++)
                {
                echo '$category[$i]';   
                }
                .")";

make your for loop outer of the query and format it properly. — Murad Hasan
– Murad Hasan, Commented May 7, 2016 at 17:47
Don't echo, concatenate. Use foreach to. What is $category[NULL]? — chris85
– chris85, Commented May 7, 2016 at 17:49
I have to use Loop in the Query because the values will be dynamic depending upon what Categories the User has Selected. — shobhit99
– shobhit99, Commented May 7, 2016 at 17:50
In for do $query .= also use " variables in single quotes aren't processed. — chris85
– chris85, Commented May 7, 2016 at 17:50

olibiaz · Accepted Answer · 2016-05-07 17:51:04Z

4

You can use the implode function depending on the structure of your array

http://php.net/manual/fr/function.implode.php

$query = "SELECT * FROM ig_accounts WHERE category IN ('" . implode("','", $category) . "')";

answered May 7, 2016 at 17:51

olibiaz

2,6034 gold badges31 silver badges33 bronze badges

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

Comments

St0iK · Accepted Answer · 2016-05-07 17:53:31Z

1

You can do something like this

$query = "SELECT * FROM ig_accounts WHERE category IN ('" . implode("','", $category) . "')";

http://php.net/manual/en/function.implode.php implode — Join array elements with a string

<?php
$a1 = array("1","2","3");
echo "a1 is: '".implode("','",$a1)."'<br>";

?>

will produce:
===========
a1 is: '1','2','3'

edited May 7, 2016 at 17:53

answered May 7, 2016 at 17:51

St0iK

6483 silver badges10 bronze badges

1 Comment

olibiaz Over a year ago

you have some missing simple quote around the brackets.

user1032531 · Accepted Answer · 2016-05-07 18:19:18Z

1

Is $category provided by the user? If so, beware, and consider prepared statements. Try the following.

$sql='SELECT * FROM ig_accounts WHERE category IN ('.implode(',', array_fill(0,count($category ), '?')).')';
$stmt=$myDB->prepare($sql);
$stmt->execute($category );

Reference http://php.net/manual/en/book.pdo.php

answered May 7, 2016 at 18:19

user1032531

26.5k77 gold badges248 silver badges422 bronze badges

Comments

Murad Hasan · Accepted Answer · 2016-05-07 18:11:03Z

0

Use join to make the string from an array. This is the way how can you do the thing.

$arr = array();
for($i = 0; $i < count($category); $i++){
    $arr[] = $category[$i];
}
$in = join(" , ", $arr);
$query = "SELECT * FROM ig_accounts WHERE category IN (".$in.")";

edited May 7, 2016 at 18:11

answered May 7, 2016 at 17:50

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

4 Comments

shobhit99 Over a year ago

I guess this will work, In C++ i use for(i=0;i<=variable[NULL];i++) How do i specify last value in php that is NULL ?

shobhit99 Over a year ago

I mean how to get size of array directly in PHP,

Murad Hasan Over a year ago

use count() function.

Murad Hasan Over a year ago

@shobhit99, I update my answer how you want it to be.

Collectives™ on Stack Overflow

How to add PHP inside SQL Query in PHP file

4 Answers 4

Comments

1 Comment

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related