Utilizing two php variables in mysql select statement

Question

I am not sure if I am apporaching this in the best way, but what I am trying to do is use two php variables for a IN clause in a mysql select query.

"select * from `user` where '$phpvar1' IN ('$phpvar2')"

Normally instead of $phpvar1 I would use a column name in the user table and it works fine, however in my case now I need the $phpvar1 variable to be used as a temporary column in this specific select query. Since $phpvar1 is dynamic in each situation, I do not want to store it. What can I do? Thanks!

EDIT: To clarify, $phpvar1 is not a column in the table, but I want it to act as one only for this one query. In this query I want $phpvar1 which is equal to for example: "cat", where as "cat" is the data that would be found in the column, and then this data ("cat") would be used in the IN clause to see if $phpvar2 contains "cat"

Basically what I want it to do is this:

SELECT * from `users` where 'mouse' IN ('cat', 'dog') and `userID` = '1'

the rows returned should have a userID = 1 AND meet the IN clause, since 'mouse' is not in ('cat,'dog') there won't be any rows returned in this case.

Are you just trying to insert the value of the PHP variables into the MySQL string? — jwatts1980
– jwatts1980, Commented Feb 7, 2014 at 3:28
Give this a try: "select * from `user` where `$phpvar1` in ('$phpvar2')". Also how is your $phpvar2 formed? — vee
– vee, Commented Feb 7, 2014 at 3:29
i don't see anything wrong with your approach. but in normal cases the we use field names instead of variable as the field names are fixed in the table. As @vee mentioned you should not use quotes around your field names — bansi
– bansi, Commented Feb 7, 2014 at 3:30
you just want to know if the 'cat' exists in the list $phpvar2? you can use a table less query SELECT 'cat' IN ('cat', 'dog') will return 1 and SELECT 'mouse' IN ('cat', 'dog') will return 0 — bansi
– bansi, Commented Feb 7, 2014 at 3:51

Arman P. · Accepted Answer · 2014-02-07 04:33:08Z

2

Rewrite your query to:

"SELECT * FROM `users` WHERE '$phpvar1' IN ('".implode("', '", $phpvar2)."') and `userID` = '1'"

Assuming that $phpvar2 is array containing values to check for.

edited Feb 7, 2014 at 4:33

answered Feb 7, 2014 at 3:30

Arman P.

4,4142 gold badges31 silver badges48 bronze badges

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

8 Comments

Arman P. Over a year ago

Yeah, sorry I just noticed :)

user1965476 Over a year ago

This does not do what I want it to. MySQL is seeing $phpvar1 as a column which does not exist.

Arman P. Over a year ago

@user1965476 Ok, I got what you want, but your approach is wrong. You define temporary fields in select part of the query. Than what is your where part? It will be like "select *, `$phpvar1` from `user` where ..."

Arman P. Over a year ago

@user1965476 Maybe you simple need the following SELECT * FROM `user` WHERE `$phpvar2` = '$phpvar1' (assuming $phpvar2 is table column and $phpvar1 is query parameter to check for, if no, than I need more clarification)

bansi Over a year ago

@ArmanP. You may need to quote the strings IN ('".implode("', '", $phpvar2)."')

|

Jignesh Patel · Accepted Answer · 2014-02-07 03:33:48Z

0

Try

 $sql = "select * from `user` where ".$phpvar1." in (".$phpvar2.")";

answered Feb 7, 2014 at 3:33

Jignesh Patel

1,0226 silver badges10 bronze badges

1 Comment

Ares Over a year ago

No sanitizing? Tsk tsk tsk

bart2puck · Accepted Answer · 2014-02-07 03:46:10Z

0

Your php variable should be in the select part Select $phpvar,otherstuff, from user where x in ('$phpvar2');

answered Feb 7, 2014 at 3:46

bart2puck

2,5203 gold badges33 silver badges61 bronze badges

Collectives™ on Stack Overflow

Utilizing two php variables in mysql select statement

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related