PHP & Mysql : PHP filtering query from database over a list

Question

I have a jQuery list which is returning a list of user_name on php page like

rohit,Bhalu,Ram

Now I want to filter the user_names from the database which is not the part of above list

So far I am trying the basic query of mysql like

 select * from table_name where user_name NOTIN('rohit','Bhalu','Ram');

But problem with above query is, this a not the specific solution for bigger list which contains 1000 user_name so I want to use some query filter with php

Please suggest me what should I do in this stage ?

yAnTar · Accepted Answer · 2012-09-17 13:25:20Z

1

First use index for field user_name.

Second use this query (in $array - usernames)

$array = array('Rohit', 'Bhalu');
$comma_separated = implode("','", $array);
$comma_separated = "'".$comma_separated."'";
$query = "select * from table_name where user_name NOT IN($comma_separated)";

edited Sep 17, 2012 at 13:25

answered Sep 17, 2012 at 12:08

yAnTar

4,64010 gold badges51 silver badges74 bronze badges

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

2 Comments

yAnTar Over a year ago

CREATE INDEX key_user_name ON table_name (user_name);

user1667633 Over a year ago

ok now my $array = Array ( [0] => rohit [1] => Bhalu ) but still its not working for me

Collectives™ on Stack Overflow

PHP & Mysql : PHP filtering query from database over a list

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related