Hi
I am trying to create a user interface for my MySQL database. I got some
help earlier for my questions from some of the Php users on this site. I am
now stuck at a point from where I have no idea how to proceed.
I created a form with 5-6 options some of them uses mysql results based on
the previous options. I am using _GET and javascript to dynamically show the
options as one may be dependent upon the other. I put the submit button at
last. I want to go to a new page only after pressing the submit button.
Since I am using autoSubmit in javaScript it directs to the new page after I
select any of the option.
I know that this is possible but just dont know how to do it. I am
attaching the full code.
How to reset all the options by pressing the reset button once???.
Thanks a lot .
Php code:
[php]
<?php
$conn = mysql_connect('localhost', 'root', 'fahim');
$db = mysql_select_db('rugit',$conn);
if (!$db) die("Unable to connect to MySQL: " . mysql_error());
?>
<?php
$organism = $genomeVer = $queryType = $arrType = $arrTypeTarget = null;
//declare vars
if(isset($_GET["organism"]) && is_string($_GET["organism"]))
{
$organism = $_GET["organism"];
}
if(isset($_GET["genomeVer"]) && is_string($_GET["genomeVer"]))
{
$genomeVer = $_GET["genomeVer"];
}
if(isset($_GET["queryType"]) && is_string($_GET["queryType"]))
{
$queryType = $_GET["queryType"];
}
if(isset($_GET["arrType"]) && is_string($_GET["arrType"]))
{
$arrType = $_GET["arrType"];
}
if(isset($_GET["arrTypeTarget"]) && is_string($_GET["arrTypeTarget"]))
{
$arrTypeTarget = $_GET["arrTypeTarget"];
}
?>
<script language="JavaScript">
function autoSubmit()
{
var formObject = document.forms['theForm'];
formObject.submit();
}
</script>
<!-- Form tag -->
<form name="theForm" method="get" enctype="multipart/form-data"> <!--action
is left blank to enter all the options-->
<!-- Option 1: Select the organism -->
<select name="organism" onChange="autoSubmit();">
<option value="null">Select Organism</option>
<option value= "human" <?php if(strcmp($organism, "human") == 0) echo
" selected"; ?>>human</option>
<option value= "mouse" <?php if(strcmp($organism, "mouse") == 0) echo
" selected"; ?>>mouse</option>
<option value= "rat" <?php if(strcmp($organism,"rat") == 0) echo "
selected"; ?>>rat</option>
</select> <br></br>
<!--Option 2: select the genome -->
<?php
//POPULATE DROP DOWN MENU FOR Genome version corresponding to a
given organism
$sql = "SELECT genomeVer FROM organismGenomeVer WHERE organism =
\"$organism\"";
//print("sql is $sql");
$result = mysql_query($sql,$conn);
//print("result is $result");
?>
<br>
<select name="genomeVer" onChange="autoSubmit();">
<option value="null">genomeVer</option>
<?php
while($row = mysql_fetch_array($result))
{
echo ("<option value=\"$row[0]\" " . ($genomeVer ==
$row["0"] ? " selected" : "") . ">$row[0]</option>");
}
mysql_free_result($result);
echo"</select>";
//print "\n\nselected genome version is $genomeVer\n\n\n\n";
?>
<!--Option 3: Radio button to select the query type -->
<br><br>
<input type="radio" value="idList" name="queryType" <?php if
($queryType == "idList") echo "checked"; ?> onclick="autoSubmit();" >
Identifier(s) as query <BR>
<input type="radio" value="seqList" name="queryType" <?php if
($queryType == "seqList") echo "checked"; ?> onclick="autoSubmit();"> Fasta
Seq(s) as query
<BR></br>
<!--Option 4 (optional): Select input array Type -->
<?php
$query = strtolower("show tables like \"$organism%\"");
//print("query is $query");
$result = mysql_query($query, $conn);
$nRows = mysql_num_rows($result);
//print"nRows is $nRows";
if ($queryType == "idList")
{
?>
<br></br>
<select name="arrType" onChange="autoSubmit();">
<option value="null">Select arrType</option>
<option value="notSure" <?php if($arrType == "notSure") echo "
selected"; ?>>Not sure</option> <br></br>
<?php
while($row = mysql_fetch_array($result))
{
echo ("<option value=\"$row[0]\" " . ($arrType ==
$row["0"] ? " selected" : "") . ">$row[0]</option>");
}
echo"</select><br>";
mysql_free_result($result);
} //end if
?> <!--//end script for arrType -->
<!--Option 5 : Enter target array type -->
<?php
$query = strtolower("show tables like
\"$organism"."_"."$genomeVer%\"");
//print("query is $query");
$result = mysql_query($query, $conn);
$nRows = mysql_num_rows($result);
echo"<br></br>";
echo "Select target array:";
echo "<br></br><select name='arrTypeTarget[]' size='6'
multiple='multiple'><br>";
//print("query is $query");
//print("result is $result");
while($row = mysql_fetch_array($result))
{
echo ("<option value=\"$row[0]\" " . ($arrTypeTarget ==
$row["0"] ? " selected" : "") . ">$row[0]</option>");
}
echo"</select>";
$val = implode(", ", $_GET["arrTypeTarget"]);
echo"<br></br>";
//print("arrTypeTarget is: $val");
//mysql_free_result($result);
echo"<br></br>";
?>
<!-- Option 6: Text box to enter id list or fasta file -->
<textarea name=\"queryVal\" cols="40" rows="5" class=\"html-text-box\">Enter
your query here...</textarea>
OR
<!-- Option 7: Upload File option -->
Select File: <input type='file' name='inpFile' size='10' />
</form>
<br />
<!-- Submit and reset button -->
<input type="submit" value="submit" name="submit" class="html-text-box">
<input type="reset" value="Reset" class="html-text-box">
<style type="text/css">
textarea.html-text-box
{background-color:FFFFFF;background-image:url(http://);
background-repeat:no-repeat;background-attachment:fixed;border-width:1;border-style:solid;
border-color:CC0000;font-family:Arial;font-size:10pt;color:000000;}
input.html-text-box
{background-color:99FF99;font-family:Arial;font-size:10pt;color:3300FF;}
</style>
<?php
print ("\n$organism, $genomeVer, $queryType, $arrType");
?>
[/php]
