 |  |  |  |  |  |  |  |
dynamic dropdown selection
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hi Friends,
since i am new to this script, I need your help, well this is my problem, i need to compare userdate with my backend date. for that i have used a dynamic dropdown combo as an id and i need to fetch the date associated with that id and need to compare with the user date in a hidden format. once the user press the calculate button it has to compare the user date and the hidden backend date and it has to display some values based on some condition.. this is the task. well i am displaying the coding also. Thank you friends.
<?php
$con=mysql_connect("localhost","root","");
if(!con)
{
die("could not connect to the database".mysql_error());
}
$db=mysql_select_db("srijesh",$con);
echo "connection succed";
$qry="select DISTINCT C from sheet1 ORDER BY C";
$result=mysql_query($qry);
?>
<html>
<head>
<title> service calculator </title>
<script type="javascript">
function fnsubmit()
{
window.document.f1.method="post";
window.document.f1.submit();
}
</script>
</head>
<body bgcolor="pale red">
<form name="f1" method="post" action="1.php">
<h1>Date comparing</h1>
<hr>
<center><p>Taxable Service:</td><td><select name="taxservice" onChange="fnsubmit()">
<option value=""></option>
<?php
while($row=mysql_fetch_array($result))
{
if($_POST['taxservice']== $row['C'])
{
$selected = 'selected';
}
else
{
$selected = '';
}
echo $selected;
echo "<option value='".$row['C']."' $selected;>.$row['C']."</option>";
}
?>
</select></p>
<p>user date:<input type="text" name="userdt" value=""></p>
<p>date compare:<input type="button" name="dtcompare" value="datecompare"> </p>
<p>ess:<input type="text" name="ess" value=""> </p>
<p>total:<input type="text" name="tot" value=""> </p>
</center> </form></body></html>
since i am new to this script, I need your help, well this is my problem, i need to compare userdate with my backend date. for that i have used a dynamic dropdown combo as an id and i need to fetch the date associated with that id and need to compare with the user date in a hidden format. once the user press the calculate button it has to compare the user date and the hidden backend date and it has to display some values based on some condition.. this is the task. well i am displaying the coding also. Thank you friends.
<?php
$con=mysql_connect("localhost","root","");
if(!con)
{
die("could not connect to the database".mysql_error());
}
$db=mysql_select_db("srijesh",$con);
echo "connection succed";
$qry="select DISTINCT C from sheet1 ORDER BY C";
$result=mysql_query($qry);
?>
<html>
<head>
<title> service calculator </title>
<script type="javascript">
function fnsubmit()
{
window.document.f1.method="post";
window.document.f1.submit();
}
</script>
</head>
<body bgcolor="pale red">
<form name="f1" method="post" action="1.php">
<h1>Date comparing</h1>
<hr>
<center><p>Taxable Service:</td><td><select name="taxservice" onChange="fnsubmit()">
<option value=""></option>
<?php
while($row=mysql_fetch_array($result))
{
if($_POST['taxservice']== $row['C'])
{
$selected = 'selected';
}
else
{
$selected = '';
}
echo $selected;
echo "<option value='".$row['C']."' $selected;>.$row['C']."</option>";
}
?>
</select></p>
<p>user date:<input type="text" name="userdt" value=""></p>
<p>date compare:<input type="button" name="dtcompare" value="datecompare"> </p>
<p>ess:<input type="text" name="ess" value=""> </p>
<p>total:<input type="text" name="tot" value=""> </p>
</center> </form></body></html>
Honestly. I'd use xmlhttp (Ajax) and do it on the server. If you *need* it to be hidden from the user, then COMPLETELY hide it from the user by removing it from the page. Just have ONCHANGE call an xmlhttp function with only the apropriate user/date, and your php page on the server does the comparison and just hands you back the appropriate values.
Need a simple, powerful knowledgebase? Bigattichouse Knowledge Base finds the solution while you're still typing the problem.
http://www.bigattichouse.com/knowledgebase.html
http://www.bigattichouse.com/knowledgebase.html
|
Similar Threads
- Affiliate Commerce System And Method (Promotion and Marketing Plans)
- Dynamic dropdown list (ASP.NET)
- Storing dynamic form values in Arrays for display & insert (PHP)
- Dropdown box in Python (Python)
- IPB vs. phpBB (Social Media and Online Communities)
- Help with dynamic menu (HTML and CSS)
Other Threads in the PHP Forum
- Previous Thread: Gd
- Next Thread: Can PHP talk to a VB msmdb?
Views: 1798 | Replies: 1
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email encode error file files folder form forms function functions google howtowriteathesis href htaccess html image include insert integration ip java javascript joomla jquery limit link login loop mail menu methods mlm mod_rewrite multiple multipletables mysql oop parse paypal pdf php problem provider query radio random recursion regex remote script search select server sessions sms soap source space speed sql structure syntax system table template tutorial update updates upload url validation validator variable video web xml youtube
