Help Needed/ PHP, MySql, Javascript
Posted: Tue Mar 22, 2011 1:00 pm
Hi everyone, any help or comments would be greatly appreciated.
At the code below, I cannot understand why after the page reloads (using the onchange=\"reload2(this.form)\) my selection at the "organism name" dropdown goes back to "Select one" and is not sticking what I selected. However, I did it the exact same way as I did the proposed category" which works (and sticks). (also $CommonName prints the correct value). All that before submitting the form, just by refreshing the page with this "reload" function.
Any comment would be great!
Thanks!
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Report a species </title>
<SCRIPT language=JavaScript>
function reload(form){
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
self.location='editReport.php?ProposedCategory=' + val ;
}
function reload2(form)
{
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
var val2=form.OrganismName.options[form.OrganismName.options.selectedIndex].value;
self.location='editReport.php?ProposedCategory=' + val + '&CommonName=' + val2 ;
}
</script>
</head>
<body>
<?php $ProposedCategory=$_GET['ProposedCategory']; ?>
<?php $CommonName=$_GET['CommonName']; ?>
<h2>Submit a New Report</h2>
<form enctype="multipart/form-data" action="editReport.php" method="post">
<p>
<label>Organism Category:</label>
<?php
$q = "SELECT DISTINCT ProposedCategory FROM tbl_species WHERE ProposedCategory != '' ORDER BY ProposedCategory ASC";
$r = mysqli_query($dbc, $q);
echo "<select name='ProposedCategory' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while ($row = mysqli_fetch_array($r, MYSQLI_NUM)){
if ($ProposedCategory==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}
echo '</select>';
?>
<p>
<label>Organism Name:</label>
<?php
$q2 = "SELECT DISTINCT CommonName FROM tbl_species WHERE ProposedCategory = '$ProposedCategory' AND CommonName != '' ORDER BY CommonName ASC";
$r2 = mysqli_query($dbc, $q2);
echo "<select name='OrganismName' onchange=\"reload2(this.form)\"><option value=''>Select one</option>";
while ($row = mysqli_fetch_array($r2, MYSQLI_NUM)){
if ($CommonName==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}
echo '</select>';
?>
<p>
<label>Scientific Name:</label>
<input name="ScientificName" type="text" value="<?php if(isset($CommonName)) echo $CommonName; ?>"/>
</p>
</body>
</html>
At the code below, I cannot understand why after the page reloads (using the onchange=\"reload2(this.form)\) my selection at the "organism name" dropdown goes back to "Select one" and is not sticking what I selected. However, I did it the exact same way as I did the proposed category" which works (and sticks). (also $CommonName prints the correct value). All that before submitting the form, just by refreshing the page with this "reload" function.
Any comment would be great!
Thanks!
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Report a species </title>
<SCRIPT language=JavaScript>
function reload(form){
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
self.location='editReport.php?ProposedCategory=' + val ;
}
function reload2(form)
{
var val=form.ProposedCategory.options[form.ProposedCategory.options.selectedIndex].value;
var val2=form.OrganismName.options[form.OrganismName.options.selectedIndex].value;
self.location='editReport.php?ProposedCategory=' + val + '&CommonName=' + val2 ;
}
</script>
</head>
<body>
<?php $ProposedCategory=$_GET['ProposedCategory']; ?>
<?php $CommonName=$_GET['CommonName']; ?>
<h2>Submit a New Report</h2>
<form enctype="multipart/form-data" action="editReport.php" method="post">
<p>
<label>Organism Category:</label>
<?php
$q = "SELECT DISTINCT ProposedCategory FROM tbl_species WHERE ProposedCategory != '' ORDER BY ProposedCategory ASC";
$r = mysqli_query($dbc, $q);
echo "<select name='ProposedCategory' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while ($row = mysqli_fetch_array($r, MYSQLI_NUM)){
if ($ProposedCategory==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}
echo '</select>';
?>
<p>
<label>Organism Name:</label>
<?php
$q2 = "SELECT DISTINCT CommonName FROM tbl_species WHERE ProposedCategory = '$ProposedCategory' AND CommonName != '' ORDER BY CommonName ASC";
$r2 = mysqli_query($dbc, $q2);
echo "<select name='OrganismName' onchange=\"reload2(this.form)\"><option value=''>Select one</option>";
while ($row = mysqli_fetch_array($r2, MYSQLI_NUM)){
if ($CommonName==$row[0]){
echo '<option value="'. $row[0] . '" selected="selected">'. $row[0] . '</option>';
}else{
echo '<option value="'. $row[0] . '">'. $row[0] . '</option>';
}
}
echo '</select>';
?>
<p>
<label>Scientific Name:</label>
<input name="ScientificName" type="text" value="<?php if(isset($CommonName)) echo $CommonName; ?>"/>
</p>
</body>
</html>