Trying to work with onchange and php

DKY

I have this dropdown box, located here.
http://dky.sytes.net/golesnew/cat/pickitem.php
and I would like it to change when selecting a table, here's my code below, I was told I could just simply input the onchange in the select part of the dropdown, but that doesnt seem to be working. any suggestions?

<html><head><title></title><LINK HREF="catalogwhite.css" REL="STYLESHEET"></head><body>

<?
require("connect.php");

database_connect();
display_tables();



if (!$_GET) 
{
  echo "<form action=\"$_SERVER['PHP_SELF']\" method=\"post\" NAME=\"show_tables\">";
  echo "<br />";
  echo "<table align=\"center\">";
  echo "<tr>";
  echo "<td width=\"100%\" valign=\"top\" align=\"center\">";
  echo "<select name=\"view_category\" onChange=\"location.href='?mode=change&table=' . $table . ''\">";
  echo "<option value=\"ViewTheContentsofaTable\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
  echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;View a Category&nbsp;&nbsp;";
  echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
  echo "</option>;";


while($row= mysql_fetch_array($result)) {
    echo "\t\t\t\t<option>{$row[0]}</option>\n";
}

echo  "</select>";
echo  "&nbsp;&nbsp;<input type=\"submit\" name=\"Select\" value=\"Select\" />";
echo  "</td></tr></table></form>";
 }

if('change' == $_GET['mode']) { 
        $table=$_GET['table'];

if ($table == "ViewTheContentsofaTable")
{
echo "<br><br><br><br><font id='title'>Please Select a Category</font>";    

}
else
{
$query = "SELECT * FROM $table";
$result = mysql_query($query);
if (!$result)
{
    $mcrmessage = mysql_error();
     echo "$mcrmessage<br>";
     die();
} 

ECHO "<TABLE BORDERCOLOR='#003300' BORDER='0' CELLSPACING='0' CELLPADDING='10'>";
echo "<tr><td colspan='2' STYLE='border-bottom-style: solid; border-bottom-width:1'><center>
<font id='title'>$table</font></td></tr>";
while ($row = mysql_fetch_array($result))
{
    extract($row);
echo "<tr onclick=\"javascript:top.showitem.location.href('showitem.php?mode=view&
table=".$table."&main_id=".$row["Product_Number"]."');\" STYLE=\"Cursor:Hand;\" 
ONMOUSEOVER=\"this.style.backgroundColor='#E2EEE2';\" 
ONMOUSEOUT=\"this.style.backgroundColor='#FFFFFF';\">
    <td STYLE='border-bottom-style: solid; border-bottom-width:1'>$Thumbnail</td>
    <td STYLE='border-bottom-style: solid; border-bottom-width:1'>$Item_Name</td></tr>\n";
}
echo "</table>\n";
}
}

database_disconnect();
?>
</body></html>

paulnaj

I did a 'view source' on your
page and noticed that the 'onchange' handler is incomplete.

It seems that your variable $table hasn't been set yet ... where I've highlighted it ...

if (!$_GET)  
{ 
  echo "<form action=\"$_SERVER['PHP_SELF']\" method=\"post\" NAME=\"show_tables\">"; 
  echo "<br />"; 
  echo "<table align=\"center\">"; 
  echo "<tr>"; 
  echo "<td width=\"100%\" valign=\"top\" align=\"center\">"; 
  echo "<select name=\"view_category\" onChange=\"location.href='?mode=change&table=' .  [B]$table[/B] . ''\">";

DKY

its not going to be set until the dropdown is selected, at least that's what i was hoping for. the $table variable is to be what's selected in the dropdown.

maybe it should be something like table='viewcategory'????

also, nothing happens when you select it anyway, no click in Internet Explorer, or anything. Shouldnt something be happening there? Maybe I have this onchange thing all wrong.

weevil

I use a javascript function call to redirect when a selection is made from a dropdown. Just set the option value = to the page you want to redirect to.

</head>
<body>
<form>
Select Page:
<select size=1 name=dest onChange="leapto(this.form)">
<option>Choose Page</option>
<option value="page1.php">Page 1</option>
<option value="page2.php">Page 2</option>
</select>
</form>
</body>
</html>

DKY

I'm not trying to redirect to another page though, I'm trying to, when you select the dropdown box, it takes that selection, and puts it in the $table variable, then the rest of the code takes that variable, runs an sql query, and shows the table's contents below it, all being on the same php page. Can I still use this code to insert the value into a variable, and then somehow have it run the sql query?

LordShryku

You can have the javascript call a new variable, but your going to have to recall the page or go to a new page to perform the sql query. It's that server side mumbo jumbo

DKY

This makes perfect sense now, onchange=\"this.form.submit();\" points to the action in the form, I think I figured it out. and if I want, I can put it like so mypage.php?mode=change in the action, and then use a php if statement to run the query, like so.

if('change' == $_GET['mode']) 
{

}

That's awesome!!! Thanks a lot everyone. One problem I have though, my dropdown disappears when selected. here's the page I'm working on. http://dky.sytes.net/golesnew/cat/pickitem.php and here's the code, in case anyone wants to help me problem solve this. Thanks in advance.

<html><head><title>Pick an Item Page</title><LINK HREF="catalogwhite.css" REL="STYLESHEET"></head><body>
<?
require("connect.php" );
database_connect();
display_tables();

if (!$_GET) 
{
echo "<form action=\"$_SERVER['PHP_SELF']?mode=change\" method=\"post\" NAME=\"show_tables\">";
echo "<br />";
echo "<table align=\"center\">";
echo "<tr>";
echo "<td width=\"100%\" valign=\"top\" align=\"center\">";
# must add this in the select below onChange=\"location.href="?mode=change&table=" . $table . ''\"
echo "<select name=\"view_category\" onchange=\"this.form.submit();\">";
echo "<option value=\"ViewTheContentsofaTable\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;View a Category&nbsp;&nbsp;";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "</option>;";

while($row= mysql_fetch_array($result)) {
echo "\t\t\t\t<option>{$row[0]}</option>\n";
}
echo "</select>";
#echo "&nbsp;&nbsp;<input type=\"submit\" name=\"Select\" value=\"Select\" />";
echo "</td></tr></table>";
}

#if ($_POST["Select"]) {
#$table = $_POST["view_category"];

if('change' == $_GET['mode']) { 
$table = $_POST["view_category"];
# $table=$_GET['table'];

if ($table == "ViewTheContentsofaTable" )
{
echo "<br><br><br><br><font id='title'>Please Select a Category</font>"; 
}
else
{
$query = "SELECT * FROM $table";
$result = mysql_query($query);
if (!$result)
{
$mcrmessage = mysql_error();
echo "$mcrmessage<br>";
die();
} 
ECHO "<TABLE BORDERCOLOR='#003300' BORDER='0' CELLSPACING='0' CELLPADDING='10'>";
echo "<tr><td colspan='2' STYLE='border-bottom-style: solid; border-bottom-width:1'><center>
<font id='title'>$table</font></td></tr>";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<tr onclick=\"java script:top.showitem.location.href('showitem.php?mode=view&
table=".$table."&main_id=".$row["Product_Number"]."');\" STYLE=\"Cursor:Hand;\" 
ONMOUSEOVER=\"this.style.backgroundColor='#E2EEE2';\" 
ONMOUSEOUT=\"this.style.backgroundColor='#FFFFFF';\">
<td STYLE='border-bottom-style: solid; border-bottom-width:1'>$Thumbnail</td>
<td STYLE='border-bottom-style: solid; border-bottom-width:1'>$Item_Name</td></tr>\n";
}
echo "</table>\n";
}
}
database_disconnect();
?>
</form></body></html>