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
$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-->
<!-- First option: 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>
<!--Second option: 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";
?>
<!--Thirsd option: 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>
<!--Optional Fourth option: 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 -->
<!--Fifth Option : 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");
?>
