Hi Fahim,
A quick google search and I found this.
http://groups.google.com/group/jquery-en/browse_thread/thread/
203077d18a0b9823
Hopefully some other PHP programers can find use of it too.
If you have any more jQuery questions though, go to their forum, they
have plenty.
jquery.com
Or email me directly and I'll try to help what I can. :)
Best,
Karl
On May 25, 2011, at 5:04 AM, Fahim Mohammad wrote:
Thanks Karl
I am trying my hands on that.
Thanks again
fahim
On Tue, May 24, 2011 at 11:55 PM, Karl DeSaulniers
<karl@xxxxxxxxxxxxxxx> wrote:
You could try using Ajax to get the field values from your database.
And you wouldn't have to refresh the page.
jQuery ajax does a nice job of this.
HTH,
Karl
On May 24, 2011, at 10:27 PM, Jim Giner wrote:
not an expert but from some things that I've done...
When you handle the selection use JS and set a hidden field on your
form
wiht the choice. Do the same with your second dropdown and then
let them
click on a 'submit' <input>
"Fahim Mohammad" <fahim.md@xxxxxxxxx> wrote in message
news:BANLkTim47cjrUsXYz=t-Yfhaoz_iUntesA@xxxxxxxxxxxxxxxxx
Hi Php users,
I have a form that has two (has more but for sake of brevity I am
assuming
it to be two) dropdown menu.
menu 1: select organism.
menu 2: select genome. This menu depends on the selected value in the
first
menu. It query into database and populate the result in this menu.
Once both are selected, I want a submit button that takes me to
another
page
where I can process these values to perform some specific task on the
database.
I am using the following form tag
<form name="theForm" method="get" enctype="multipart/form-data"
action =
'processForm.php' >
I have the following problem now:
1. If I keep the action value in the form tag above, after
selecting the
first option it direct me to the second page and I am not able to
select
the
seconf option in the form.
2. If I remove the action value above then I can not submit the
form as
intended.
3. If I remove the "onChange="autoSubmit();"" from select tag then
I am
not
able to pass the selected value in first option to mysql to get the
result.
I think I reached a place from where it is not possible for me to
proceed
ahead. I may need to change something which I am not aware of.
Help needed.
Thanks
[php]
<?php
include'login.php';
$conn = mysql_connect($db_hostname, $db_username, $db_password );
$db = mysql_select_db('rugit',$conn);
if (!$db) die("Unable to connect to MySQL: " . mysql_error());
?>
<?php
$organism = $genomeVer = 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"];
}
?>
<script language="JavaScript">
function autoSubmit()
{
var formObject = document.forms['theForm'];
formObject.submit();
}
</script>
<!-- Form tag -->
<form name="theForm" method="get" enctype="multipart/form-data" >
<!-- 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\"";
$result = mysql_query($sql,$conn);
?>
<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>";
?>
<!-- Submit button -->
<br></br>
<input type="submit" value="submit" class="html-text-box">
</form>
[/php]
--
Fahim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Fahim Mohammad
Bioinforformatics Lab
University of Louisville
Louisville, KY, USA
Ph: +1-502-409-1167
Karl DeSaulniers
Design Drumm
http://designdrumm.com
