Greetings gurus,
I am attempting to use a javascript function to create a date pulldown, and then pass the selected date to MySQL. The javascript is working fine, takes into account leap years (if the year var is extended), differences in the month of Feb in terms of days, etc.. But, for the life of me, I can't figure out how to pass the selected date to MySQL. If anyone can help, it would be most appreciated.
Code:
<Script>
<!--
var date_arr = new Array;
var days_arr = new Array;
date_arr[0]=new Option("January",31);
date_arr[1]=new Option("February",28);
date_arr[2]=new Option("March",31);
date_arr[3]=new Option("April",30);
date_arr[4]=new Option("May",31);
date_arr[5]=new Option("June",30);
date_arr[6]=new Option("July",31);
date_arr[7]=new Option("August",30);
date_arr[8]=new Option("September",30);
date_arr[9]=new Option("October",31);
date_arr[10]=new Option("November",30);
date_arr[11]=new Option("December",31);
function departure_date(f)
{
document.writeln("<SELECT name=\"months\" onchange=\"update_days(frm_persmove)\">");
for(x=0;x<12;x++)
document.writeln("<OPTION value=\""+date_arr[x].value+"\">"+date_arr[x].text);
document.writeln("</SELECT><SELECT name=\"days\"></SELECT>");
selection=f.months[f.months.selectedIndex].value;
}
function update_days(f)
{
temp=f.days.selectedIndex;
for(x=days_arr.length;x>0;x--)
{
days_arr[x]=null;
f.days.options[x]=null;
}
selection=parseInt(f.months[f.months.selectedIndex].value);
ret_val = 0;
if(f.months[f.months.selectedIndex].value == 28)
{
year=parseInt(f.years.options[f.years.selectedIndex].value);
if (year % 4 != 0 || year % 100 == 0 ) ret_val=0;
else
if (year % 400 == 0) ret_val=1;
else
ret_val=1;
}
selection = selection + ret_val;
for(x=1;x < selection+1;x++)
{
days_arr[x-1]=new Option(x);
f.days.options[x-1]=days_arr[x-1];
}
if (temp == -1) f.days.options[0].selected=true;
else
f.days.options[temp].selected=true;
}
function year_install(f)
{
document.writeln("<SELECT name=\"years\" onchange=\"update_days(frm_persmove)\">")
for(x=2004;x<2006;x++) document.writeln("<OPTION value=\""+x+"\">"+x);
document.writeln("</SELECT>");
update_days(f)
}
</script>
The function is then called by:
<SCRIPT>departure_date(document.frm_persmove);year_install(document.frm_persmove)</script>
