[RESOLVED] Unknown Number of Variables in Query

D_tunisia

I have a query which uses variables from a string in the URL.

For example:

URL: http://www.mysite.com/page.php?id=1

Query: SELECT * FROM table WHERE id = $id

This works fine, but if I want to specify more than one variable I have to manually change the query on the PHP page to accept the new variable:

URL: http://www.mysite.com/page.php?id=1&id2=2

Query: SELECT * FROM table WHERE id= $id OR id = $id2

Is there a way to make the query dynamic so that I can enter as many variables in the string as I want and not having to change the query?

Thanks in advance for any help!

n_wattam

mmm i might have something on this, just trying somot now...

use this for your url

test2.php?var[]=1&var[]=2

and save this as test2.php

<?
for ($n = 0; $n < count($var); $n++) {
	echo $var[$n] . "<br>";
}
?>

Give us a few mins, will have somot better

n_wattam

ok i have solved this for you, just making the code readable. 🙂

D_tunisia

Wow, cool! Thanks!

n_wattam

using the following in your url path

test2.php?var=1:2:3

: is used to break up each value you want to search by, using the explode function in the php code, this then takes your values and puts them in an array, using a loop and an if statement we then build up your custom query which we then us on the DB

<?

// splits into array.
$searchfor = explode(":",$var);

// Builds your OR statment
for ($n = 0; $n < count($searchfor); $n++) {
	//stops a false OR at the end of your custom query
	if ($n != (count($searchfor) - 1)) {
		$custom_query = $custom_query . "id='" . $searchfor[$n] . "'" . " OR ";
	} else {
		$custom_query = $custom_query . "id='" . $searchfor[$n] . "'";
	}
}


// Debug, so you can see your custom query
echo "SELECT * FROM pageconfig WHERE " . $custom_query ;



$result = mysql_query("SELECT * FROM pageconfig WHERE " . $custom_query,$db);
while ($row = mysql_fetch_array ($result)) {
	echo $row['id'];
}

?>

D_tunisia

Wow! It works, thanks!!!

Just out of interest, what is the $db for in the query?

n_wattam

No problem.

You should be able to build on that idea, to run other types of querys or mixture of.

Its equal to the following details for making my connection to a database.

$db = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
mysql_select_db(DB_NAME,$db);

D_tunisia

Related to this problem, but also a new question...

If there were to be no variable in the URL string and I wanted to do something along the lines of:

if ($var = null)
{
echo "There is no variable";
}
ELSE
{
Run the query
}

Would this work?

n_wattam

more or less yes..

<?

if ($var) {

// the code i posted above here


} else {


// Null statement here

}

?>