passing data in form

[rathersurf]

I am creating a form....actually drop down boxes that each are dependent on one another.....I have the drop down script working fine for the first box...I just dont know how to make a certain criteria post back in the second drop down box depending on the selection made in the first..... Here is the code ..

<form method="GET" action="test.php">
<select name="mydropdown">
<?
// Connect to DB
$conn = ociLogon("K2DEV", "K2DEV", "SBV3");

// This is the SQL statement to run
$query = "SELECT name FROM schools";

// This parses the SQL Statement for use
$statement = OCIParse($conn, $query);

// OCIExecute returns true/false if the query succedded in runnin
// Note that this does NOT COMMIT by default, if you are using INSERT/UPDATE/DELETE
if(OCIExecute($statement))
{
// oci_fetch_array() returns the next row from the result set, OCI_BOTH returns tuples as both associative array
// eg, '$row['NAME']' and indexed array, eg $row[1].
// You can also use oci_fetch_assoc() for just an associative array, or oci_fetch_row() for just numeric array
// Oracle returns all field names in UPPERCASE, so your associative array's will be indexed as such as well.

    while(OCIFetchInto($statement, $row, OCI_ASSOC))
    {
            printf("<option value='%s'>%s</option>\n", htmlentities($row['NAME']), htmlentities($row['NAME']));
    }

}
?>
</select>
<input type="submit" />
</form>

<?
if($_GET['mydropdown']){

    print "SELECTED SCHOOL WAS: ";
    print $_GET['mydropdown'];

}

From here i dont know where to go.....I need for the school to pull a list of teachers for that school in the second drop down and the third needs to be the students in that school....

Any help would be much appreciated....

Thanks

[dalecosp]

First off, I'd recommend using POST instead of GET in the form action (and, of course, the corresponding test near the bottom).

Regardless of which method you choose, your next step is to get rid of the print "selected school was" and instead use that conditional area to do the logic for the next step. The code itself should be similar, but of course you'll adjust the database queries, and I'd suggest using different variable names. I'd very strongly recommend naming your "mydropdown" something else in every case (especially the 2nd and 3rd iterations). Like "schoolchoice" in the first instance, "teacherchoice" in the 2nd, and so on. You could actually do this quite efficiently with just "mydropdown", but you'd also have to send some kind of marker to the script to tell it exactly which part of the 3 step process you're now working on...

Your logic flow, then, is something like:

if (!$_POST) {

   // do the "select a school" stuff already written

} elseif ($_POST['schoolchoice']) {

   // do the "select stuff", but with teachers

} elseif ($_POST['teacherchoice']) {

   // do the "select stuff" with student names....

} elseif ($_POST['studentchoice']) {

   // now you do some real stuff, but you haven't said what ...
   // maybe you redirect to another page? ;-)

} else {

   // there's something wrong, so give an error message here...

}

HTH,

[rathersurf]

I tried this and didnt have much luck:

<?
if (!$_POST) {
?>
<form method="POST" action="test2.php">
<select name="schoolchoice">
<?
// Connect to DB
$conn = ociLogon("K2DEV", "K2DEV", "SBV3");

// This is the SQL statement to run
$query = "SELECT * FROM schools ORDER by Name";

// This parses the SQL Statement for use
$statement = OCIParse($conn, $query);

// OCIExecute returns true/false if the query succedded in runnin
// Note that this does NOT COMMIT by default, if you are using INSERT/UPDATE/DELETE
if(OCIExecute($statement))
{
// oci_fetch_array() returns the next row from the result set, OCI_BOTH returns tuples as both associative array
// eg, '$row['NAME']' and indexed array, eg $row[1].
// You can also use oci_fetch_assoc() for just an associative array, or oci_fetch_row() for just numeric array
// Oracle returns all field names in UPPERCASE, so your associative array's will be indexed as such as well.

    while(OCIFetchInto($statement, $row, OCI_ASSOC))
    {
            printf("<option value='%s'>%s</option>\n", htmlentities($row['NAME']), htmlentities($row['NAME']));
    }

}
?>
</select>
<input type="submit" />
</form>
<?
} elseif ($_POST['teacherchoice']) {
?>
<form method="POST" action="test2.php">
<select name="Teacher_Name">
<?
// Connect to DB
$conn = ociLogon("K2DEV", "K2DEV", "SBV3");

// This is the SQL statement to run
$query = "SELECT * FROM teachers ORDER by Last_Name";

// This parses the SQL Statement for use
$statement = OCIParse($conn, $query);

// OCIExecute returns true/false if the query succedded in runnin
// Note that this does NOT COMMIT by default, if you are using INSERT/UPDATE/DELETE
if(OCIExecute($statement))
{
// oci_fetch_array() returns the next row from the result set, OCI_BOTH returns tuples as both associative array
// eg, '$row['NAME']' and indexed array, eg $row[1].
// You can also use oci_fetch_assoc() for just an associative array, or oci_fetch_row() for just numeric array
// Oracle returns all field names in UPPERCASE, so your associative array's will be indexed as such as well.

    while(OCIFetchInto($statement, $row, OCI_ASSOC))
    {
            printf("<option value='%s'>%s</option>\n", htmlentities($row['First_Name']), htmlentities($row['First_Name']));
    }

}
?>
</select>
<input type="submit" />
</form>
<?
} elseif ($_POST['teacherchoice']) {
?>
<form method="POST" action="test2.php">
<select name="studentchoice">
<?
// Connect to DB
$conn = ociLogon("K2DEV", "K2DEV", "SBV3");

// This is the SQL statement to run
$query = "SELECT * FROM students ORDER by Last_Name";

// This parses the SQL Statement for use
$statement = OCIParse($conn, $query);

// OCIExecute returns true/false if the query succedded in runnin
// Note that this does NOT COMMIT by default, if you are using INSERT/UPDATE/DELETE
if(OCIExecute($statement))
{
// oci_fetch_array() returns the next row from the result set, OCI_BOTH returns tuples as both associative array
// eg, '$row['NAME']' and indexed array, eg $row[1].
// You can also use oci_fetch_assoc() for just an associative array, or oci_fetch_row() for just numeric array
// Oracle returns all field names in UPPERCASE, so your associative array's will be indexed as such as well.

    while(OCIFetchInto($statement, $row, OCI_ASSOC))
    {
            printf("<option value='%s'>%s</option>\n", htmlentities($row['First_Name,Last_Name']), htmlentities($row['First_Name,Last_Name']));
    }

}
?>
</select>
<input type="submit" />
</form>
<?
} elseif ($_POST['studentchoice']) {

// now you do some real stuff, but you haven't said what ...
// maybe you redirect to another page? ;-)

} else {

// there's something wrong, so give an error message here...

}

?>

Thanks again for your help

[dalecosp]

Simple brain fart, everyone has them. Your first "elseif", which is the second condition test, reads "if ($POST['teacherchoice'])", but should read "if ($POST['schoolchoice'])".

See if that helps.

[rathersurf]

That worked for now.....my sql statement is pulling blank values for whatever reason....i am going to try to figure that out now....Thanks again for your help..

[rathersurf]

I just found out that working with oracle your db names are case sensitive.....im not sure if it is the same way with mysql but in oracle --- it likes the case to match..