DaniWeb Forum Index > Web Development > PHP

Passing variable sql php

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2007

Posts: 30

Reputation: Mylena is an unknown quantity at this point

Solved Threads: 1

Mylena

Offline

Light Poster

Passing variable sql php

Oct 4th, 2008

Hi,

I have a web site in which I pass many javascript variables to php and the other way round. This is my last passing variable challenge, and I cannot figure it out.

There's an alphabet letter that i pass into showhide1(v) function, and i try to pass it to IN(). For example IN ('b') will retrieve all items beginning with letter b.

The way I did it below does not work for some reason. Does anyone know how to do it?

Thanks

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
function showhide1(v)
{
 
<?php
$result = mysql_query("SELECT * FROM birdstable
WHERE left(Name, 1) IN ($_GET[v]) 
ORDER BY Name;"); 
 
while($row = mysql_fetch_assoc($result)){  
$varr= $row['BirdID'];
?>
document.getElementById("Layer1").innerHTML = "hello";
 
<?php
 
}
?>
 
 
}
function showhide1(v)
{

<?php
$result = mysql_query("SELECT * FROM birdstable
WHERE left(Name, 1) IN ($_GET[v]) 
ORDER BY Name;"); 

while($row = mysql_fetch_assoc($result)){  
$varr= $row['BirdID'];
?>
document.getElementById("Layer1").innerHTML = "hello";

<?php

}
?>


}

Last edited by Mylena; Oct 4th, 2008 at 2:53 pm.

•

Join Date: Jul 2008

Posts: 1,072

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: Passing variable sql php

Oct 6th, 2008

i think you can't get the java script function values by this way: $_GET[v].
if you want to send javascript values to php try this way:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
function showhide1(x)
{
d.action="yourpage.php?v="+x;
d.submit();
}
function showhide1(x)
{
d.action="yourpage.php?v="+x;
d.submit();
}