retrieve data from array list

Anon

Supposed that I have array list like A, B, C, D, E etc. from checkbox or combo, I want to use them all against database to retrieve data. How to query them to reach the goal?

select c1, c2, c4, c5 from table1 where c3 = $c3[]; ???

It is right or somthing else?

[deleted]

Do you mean that you have a form where people can select several options at the same time, giving you arrays like
$A=array(1,5,7);
$C=array(87,9,23);
in that case you'd use the IN statement.

$sQuery = "SELECT *
FROM table
WHERE col_a IN (".implode(',', $A).")
OR col_b IN (".implode(',', $😎.")
OR ...etc...

Note: you'll have to check if an array is empty, because SQL doesn't like IN statements with no data.

techek

If you have an array (eg. from a list of checkboxes), you can do this :

<?php

$my = array('a', 'b', 'd', 'z');

if (count($my) > 0)) {
$sql_in = "'".implode("','", $my)."'";
$sql = "SELECT * FROM table WHERE val IN ($sql_in)";
$result = mysql_query($sql);
}

This way you'll get records matching val at 'a', 'b', 'd' and 'z'. Hope you can use that for something?

Anon

Hi,

Thanks for your suggestions. But If I have checkbox, user will paste or upload bunch of data there, then I want to search all data against database, then retrieve data for them.

That means that we don't know what data user will input there, so how to handle it using PHP?

Thanks

[deleted]

A checkbox can be on or off, I suppose you mean a textarea?

Anon

yes, textarea.

[deleted]

If I were you I wouldn't use a textarea in a search, because the only way to search 'reliably' is by splitting the searchtext up into seperate words and check them all with a LIKE statement. In other words: slow.