raj86 Posted October 28, 2009 Share Posted October 28, 2009 hello friends.... i am having a working javascript....when i am selecting any designation and refresh/validation problem the form is resetting the designation value and the designation value is not going into the database.....please look at the below code and suggest me how to make it work... function changeList(list1,list2) { list2.length = 0; if(list1.options[list1.selectedIndex].value == 2) { addOption(list2,"ACTD","ACTD"); addOption(list2,"ALEC","ALEC"); addOption(list2,"ASOP","ASOP"); addOption(list2,"ASTP","ASTP"); addOption(list2,"DIRO","DIRO"); addOption(list2,"DLIB","DLIB");addOption(list2,"LECT","LECT"); addOption(list2,"PFAT","PFAT"); addOption(list2,"PROF","PROF");addOption(list2,"TA","TA"); addOption(list2,"VFAC","VFAC"); addOption(list2,"VPRF","VPRF"); } else if(list1.options[list1.selectedIndex].value == 3) { addOption(list2,"ACCO","ACCO"); addOption(list2,"APRG","APRG"); addOption(list2,"ASTR","ASTR"); addOption(list2,"COCH","COCH"); addOption(list2,"CSHR","CSHR"); addOption(list2,"CTOR","CTOR"); addOption(list2,"DRVR","DRVR"); addOption(list2,"DUDT","DUDT"); addOption(list2,"ELER","ELER"); addOption(list2,"FINO","FINO"); addOption(list2,"HSPT","HSPT"); addOption(list2,"JAAT","JAAT"); addOption(list2,"JOAT","JOAT"); addOption(list2,"JTEC","JTEC"); addOption(list2,"LABT","LABT"); addOption(list2,"LBST","LBST"); addOption(list2,"LIST","LIST");addOption(list2,"MEDA","MEDA"); addOption(list2,"MO","MO"); addOption(list2,"OFST","OFST"); addOption(list2,"PA","PA");addOption(list2,"PAST","PAST");addOption(list2,"PRGR","PRGR"); addOption(list2,"SCOP","SCOP"); addOption(list2,"SLAT","SLAT"); addOption(list2,"SMDA","SMDA"); addOption(list2,"SMDO","SMDO"); addOption(list2,"SNRS","SNRS"); addOption(list2,"STCH","STCH");addOption(list2,"SUPV","SUPV"); addOption(list2,"WSPT","WSPT"); } else if(list1.options[list1.selectedIndex].value == 4) { addOption(list2,"ATDT","ATDT");addOption(list2,"CHWK","CHWK"); addOption(list2,"LIDT","LIDT"); addOption(list2,"NRSE","NRSE"); addOption(list2,"OAST","OAST"); } } </script> <body bgcolor="#cccccc" style="color:#000099" onload="changeList(document.forms.form2.emptyp,document.forms.form2.desig)" > <label>3. Employee Type</label> <font color="##FF0000" >*</font> <select name="emptyp" onChange="changeList(document.forms.form2.emptyp,document.forms.form2.desig)"> <option value="2" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '2') { echo "selected='selected'"; }?> >2 (Teaching faculty)</option> <option value="3" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '3') { echo "selected='selected'"; }?> >3 (Supporting staff)</option> <option value="4" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '4') { echo "selected='selected'"; }?> >4 (Helping staff)</option> </select> <br> <br> <label >9. Designation</label> <select name="desig" id="desig" value=""> </select> <br><br> $desig=($_POST['desig']); Quote Link to comment Share on other sites More sharing options...
seanlim Posted October 28, 2009 Share Posted October 28, 2009 Do you have FORM tags in your HTML code for form2? If you do, please include them in the code you provide as it is vital. If you don't, you need them. Quote Link to comment Share on other sites More sharing options...
raj86 Posted October 28, 2009 Author Share Posted October 28, 2009 this is the form tag in my php for <form action="" id="form2" method="post" name="form1" class="style1"> Quote Link to comment Share on other sites More sharing options...
raj86 Posted October 29, 2009 Author Share Posted October 29, 2009 please help me to solve this problem....... Quote Link to comment Share on other sites More sharing options...
seanlim Posted October 29, 2009 Share Posted October 29, 2009 I would have if you had described your problem better. I've only a vague understanding of your problem after much re-reading of your original post. I believe these are your 2 problems: 1. Dynamically-created SELECT loses its previously-selected value You will have to use Javascript to dynamically-select the option you want, after changeList() is called in the onload event. 2. Designation field not inserted into DB Please post your PHP code which handles the form submission. Quote Link to comment Share on other sites More sharing options...
raj86 Posted October 29, 2009 Author Share Posted October 29, 2009 hello friends... In my form i am using 32 fields.....1) name 2)dob etc..... now the problem is, suppose i have entered 12345 insted of my name so at that time it will show error message : Please enter a valid name after this my selected value of designation will be reset...........so after every validation error i have to select the designation value.... I want the output like when i select any designation : TA from employee type 2 , this value should not reset every time and the same value TA should go in the database i dont know whether i have to change in the javascript or in php code I am putting complete code of the form.....3rd is the dynamice drop down and its value i am getting in the 9th field Designation <?php //f2003862 //otw824 session_start(); $_POST['psrn']=0; $_POST['desig']=""; $error_msg=" "; $_SESSION['psrn_no']=$_POST['psrn']; require($_SERVER["DOCUMENT_ROOT"]."/config/config.php"); $connection = mysql_connect($host, $user, $password) or die("error connecting"); mysql_select_db('bits_sap') or die("cannot select database"); $str="select MAX(PSRN) from paymajor"; $result=mysql_query($str) or die(mysql_error()); while($row=mysql_fetch_assoc($result)) { $psrn=$row['MAX(PSRN)']+1; } ?> <script language="javascript"> function highlight(field) { field.focus(); field.select(); } </script> <script language="javascript"> function checkName(str) { var name = new RegExp("^[a-zA-Z .]+$"); if (!str.match(name) && (name!="")) alert('Invalid characters in Name.'); } </script> <script language="javascript"> function checkNumber(str) { var number = new RegExp("^[0-9]+$"); if (!str.match(number) && (number!="")) alert('Invalid Numbers.'); } </script> <script language="javascript"> function addOption(selectList,optionText,optionValue) { var newOption = document.createElement('OPTION'); newOption.text = optionText; newOption.value = optionValue; selectList.options.add(newOption); } function changeList(list1,list2) { list2.length = 0; if(list1.options[list1.selectedIndex].value == 2) { addOption(list2,"ACTD","ACTD"); addOption(list2,"ALEC","ALEC"); addOption(list2,"ASOP","ASOP"); addOption(list2,"ASTP","ASTP"); addOption(list2,"DIRO","DIRO"); addOption(list2,"DLIB","DLIB");addOption(list2,"LECT","LECT"); addOption(list2,"PFAT","PFAT"); addOption(list2,"PROF","PROF");addOption(list2,"TA","TA"); addOption(list2,"VFAC","VFAC"); addOption(list2,"VPRF","VPRF"); } else if(list1.options[list1.selectedIndex].value == 3) { addOption(list2,"ACCO","ACCO"); addOption(list2,"APRG","APRG"); addOption(list2,"ASTR","ASTR"); addOption(list2,"COCH","COCH"); addOption(list2,"CSHR","CSHR"); addOption(list2,"CTOR","CTOR"); addOption(list2,"DRVR","DRVR"); addOption(list2,"DUDT","DUDT"); addOption(list2,"ELER","ELER"); addOption(list2,"FINO","FINO"); addOption(list2,"HSPT","HSPT"); addOption(list2,"JAAT","JAAT"); addOption(list2,"JOAT","JOAT"); addOption(list2,"JTEC","JTEC"); addOption(list2,"LABT","LABT"); addOption(list2,"LBST","LBST"); addOption(list2,"LIST","LIST");addOption(list2,"MEDA","MEDA"); addOption(list2,"MO","MO"); addOption(list2,"OFST","OFST"); addOption(list2,"PA","PA");addOption(list2,"PAST","PAST");addOption(list2,"PRGR","PRGR"); addOption(list2,"SCOP","SCOP"); addOption(list2,"SLAT","SLAT"); addOption(list2,"SMDA","SMDA"); addOption(list2,"SMDO","SMDO"); addOption(list2,"SNRS","SNRS"); addOption(list2,"STCH","STCH");addOption(list2,"SUPV","SUPV"); addOption(list2,"WSPT","WSPT"); } else if(list1.options[list1.selectedIndex].value == 4) { addOption(list2,"ATDT","ATDT");addOption(list2,"CHWK","CHWK"); addOption(list2,"LIDT","LIDT"); addOption(list2,"NRSE","NRSE"); addOption(list2,"OAST","OAST"); } } </script> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <body bgcolor="#cccccc" style="color:#000099" onload="changeList(document.forms.form2.emptyp,document.forms.form2.desig)" > <hr style="color:#000099"> <h2 align="center" class="style1">PAY ENTRY</h2> <hr style="color:#000099"> <title>Pay Entry</title> <style type="text/css"> <!-- .style1 { font-family: Arial, Helvetica, sans-serif; background-color: #CCCCCC; color: #000099; } --> <style> .error{ color:#F00; } /* Displays Star in Red color */ .default_star{ color: red; font-weight: bold; } </style> <script language="javascript" type="text/javascript" src="scripts/datetimepicker_css.js"></script> </head> <form action="" id="form2" method="post" name="form1" class="style1"> <td width="50%" valign="top"> <font color="##FF0000" >*</font> <label>indicates mandatory field</label> <table border="0" width="100%" cellpadding="10"> <tr> <td width="50%" colspan="2" valign="top" > <?php echo "1. PSRN: ",$psrn; ?> <br><br> <label>2. BSRN</label> <input type="text" name="bsr" size="3" maxlength="3" onclick='highlight(this);' value="<?php if (isset($_POST['submit'])) echo $_POST['bsr'];?>"> <br><br> <label>3. Employee Type</label> <font color="##FF0000" >*</font> <select name="emptyp" onChange="changeList(document.forms.form2.emptyp,document.forms.form2.desig)"> <option value="2" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '2') { echo "selected='selected'"; }?> >2 (Teaching faculty)</option> <option value="3" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '3') { echo "selected='selected'"; }?> >3 (Supporting staff)</option> <option value="4" <?php if (isset($_POST['emptyp']) && $_POST['emptyp'] == '4') { echo "selected='selected'"; }?> >4 (Helping staff)</option> </select> <br> <br> <label>4. Name</label> <font color="##FF0000" >*</font> <input type="text" name="name" size="30" maxlength="30" onKeyUp="checkName(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['name']; ?>"><br><br> <label>5. Sex</label> <select name="sx"> <option value='M' <?php if (isset($_POST['sx']) && $_POST['sx'] == 'M') { echo "selected='selected'"; }?> >Male</option> <option value='F' <?php if (isset($_POST['sx']) && $_POST['sx'] == 'F') { echo "selected='selected'"; }?> >Female</option> </select> <br><br> <!-- <?php if (trim($_POST["sx"]) == "M") echo " selected ";?> --> <label>6. Date of Birth</label> <input id="dob" name="dob" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['dob'];?> "><a href="javascript:NewCssCal('dob','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label>7. Date of Joining</label> <input id="doj" name="doj" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['doj'];?> "><a href="javascript:NewCssCal('doj','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label>8. Date of Term Expiry</label> <input id="dot" name="dot" size="10" value="<?php if (isset($_POST['submit'])) echo $_POST['dot'];?> "><a href="javascript:NewCssCal('dot','yyyyMMdd')"><img src="scripts/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a><br> <br> <label >9. Designation</label> <select name="desig" id="desig" value="<?php if (isset($_POST['submit'])) echo selected ?>" > </select> <br><br> <label>10. Family Pens</label> <select name="fp_mem_yn"> <option value='T' <?php if (isset($_POST['fp_mem_yn']) && $_POST['fp_mem_yn'] == 'T') { echo "selected='selected'"; }?> >Yes</option> <option value='F' <?php if (isset($_POST['fp_mem_yn']) && $_POST['fp_mem_yn'] == 'F') { echo "selected='selected'"; }?> >No</option> </select><br><br> <label>11. Internal Division Code</label> <select name="intdiv"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> <option value="20">20</option><option value="21">21</option> <option value="22">22</option> <option value="23">23</option> </select><br><br> <label>12. Budget Division Code</label> <select name="buddiv"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> <option value="20">20</option><option value="21">21</option> <option value="22">22</option> <option value="23">23</option> </select><br><br> <label>13. Grade Code</label> <select name="grdcode"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option><option value="4">4</option> <option value="5">5</option><option value="6">6</option> <option value="7">7</option> <option value="8">8</option><option value="9">9</option> <option value="10">10</option><option value="11">11</option> <option value="12">12</option> <option value="13">13</option><option value="14">14</option> <option value="15">15</option><option value="16">16</option> <option value="17">17</option> <option value="18">18</option><option value="19">19</option> </select><br><br> <label>14. Basic Pay</label> <font color="##FF0000" >*</font> <input type="text" name="basic" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['basic'];?>"> </select> <br> <br> <label>15. Allowance without PF</label> <input type="text" name="alwopf" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['alwopf'];?>"> </select> <br> <br> </td> <td width="50%" valign="top"> <label>16. Allowance with PF</label> <input type="text" name="alwipf" size="6" maxlength="6" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['alwipf'];?>"> </select> <br> <br> <label>17. Bank code</label> <select name="bankcode"> <option value="SBI">SBI</option> </select><br><br> <label>18. Bank A/C No.</label> <input type="text" name="bankac" size="11" maxlength="11" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['bankac'];?>"> </select> <br> <br> <label>19. Draft Code</label> <font color="##FF0000" >*</font> <input type="text" name="draftcode" size="2" maxlength="2" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['draftcode'];?>"> </select> <br> <br> <label>20. Fixed Pay Code</label> <select name="fixpcode"> <option value="0" <?php if (isset($_POST['fixpcode']) && $_POST['fixpcode'] == '0') { echo "selected='selected'"; }?> >0 (not fixed)</option> <option value="1" <?php if (isset($_POST['fixpcode']) && $_POST['fixpcode'] == '1') { echo "selected='selected'"; }?>>1 (fixed)</option> </select><br><br> <label>21. Increment(Month)</label> <select name="incmon" value="<?php if (isset($_POST['submit'])) echo $_POST['incmon'];?>"> <option value="0">0 (no increment)</option> <option value="1" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '1') { echo "selected='selected'"; }?> >1 </option> <option value="2" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '2') { echo "selected='selected'"; }?> >2 </option> <option value="3" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '3') { echo "selected='selected'"; }?> >3 </option> <option value="4" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '4') { echo "selected='selected'"; }?> >4 </option> <option value="5" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '5') { echo "selected='selected'"; }?> >5 </option> <option value="6" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '6') { echo "selected='selected'"; }?> >6 </option> <option value="7" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '7') { echo "selected='selected'"; }?> >7 </option> <option value="8" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '8') { echo "selected='selected'"; }?> >8 </option> <option value="9" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '9') { echo "selected='selected'"; }?> >9 </option> <option value="10" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '10') { echo "selected='selected'"; }?>>10</option> <option value="11" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '11') { echo "selected='selected'"; }?> >11</option> <option value="12" <?php if (isset($_POST['incmon']) && $_POST['incmon'] == '12') { echo "selected='selected'"; }?> >12</option> </select><br><br> <label>22. Increment Year</label> <input type="text" name="incyr" size="4" maxlength="4" value="<?php if (isset($_POST['submit'])) echo $_POST['incyr'];?>"> </select> (yyyy) <br> <br> <label>23. PF OWN</label> <input type="text" name="pfown" value="12" size="2" maxlength="2" onBlur="checkNumber(this.value)" onclick='highlight(this);' > </select> <br> <br> <label>24. PF EMPLOYER</label> <input type="text" name="pfemp" value="12" size="2" maxlength="2" onBlur="checkNumber(this.value)" onclick='highlight(this);' > </select> <br> <br> <label>25. House No.</label> <input type="text" name="houseno" size="7" maxlength="7" value="<?php if (isset($_POST['submit'])) echo $_POST['houseno'];?>"> </select> <br> <br> <label>26. House Rent</label> <input type="text" name="house_rent" size="4" maxlength="4" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['house_rent'];?>"> </select> <br> <br> <label>27. TCC</label> <input type="text" name="tcc" size="4" maxlength="4" onKeyUp="checkNumber(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['tcc'];?>"> </select> <br> <br> <label>28. Meter Rent</label> <select name="meter_rent"> <option value="0">0 </option> <option value="1">1 </option> <option value="2">2 </option> <option value="3">3 </option> <option value="4">4 </option> <option value="5">5 </option> <option value="6">6 </option> <option value="7">7 </option> <option value="8">8 </option> <option value="9">9 </option> <option value="10">10 </option> <option value="11">11 </option> <option value="12">12</option> </select> <br> <br> <label>29. STAFF ASSOCIATION</label> <select name="stf_assoc"> <option value="0" <?php if (isset($_POST['stf_assoc']) && $_POST['stf_assoc'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="3" <?php if (isset($_POST['stf_assoc']) && $_POST['stf_assoc'] == '3') { echo "selected='selected'"; }?> >3 </option> </select> <br> <br> <label>30. BITS COOP</label> <select name="bits_coop"> <option value="0" <?php if (isset($_POST['bits_coop']) && $_POST['bits_coop'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="1" <?php if (isset($_POST['bits_coop']) && $_POST['bits_coop'] == '1') { echo "selected='selected'"; }?> >1 </option> </select> <br> <br> <label>31. Vacation Days</label> <select name="vacday"> <option value="0" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '0') { echo "selected='selected'"; }?> >0 </option> <option value="30" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '30') { echo "selected='selected'"; }?> >30 </option> <option value="60" <?php if (isset($_POST['vacday']) && $_POST['vacday'] == '60') { echo "selected='selected'"; }?>>60 </option> </select> <br> <br> <label>32. Name of Father/Husband</label> <font color="##FF0000" >*</font> <input type="text" name="fathhusb" size="25" maxlength="25" onKeyUp="checkName(this.value)" value="<?php if (isset($_POST['submit'])) echo $_POST['fathhusb'];?>"> </select> <br> <br> </td> </tr> </table> <br><br> <center> <label><b>Are the entries correct?</b></label> <input type="submit" name="submit" value="Submit" style="width:50px" onclick="ConfirmDelete;" /> <input type="button" name="submit2" value="Main Menu" onclick='window.location="http://localhost/bitssap/index.php"' /> </center> </form> </body> </html> <?php if( isset($_POST['submit'])) { $bsr=0; $flg=0; $emptyp=0;$intdiv=0;$buddiv=0;$grdcode=0;$basic=0;$tempda=0;$intrel=0;$alwopf=0;$alwipf=0;$draftcode=0;$fixpcode=0;$incmon=0;$incyr=0;$pfown=0;$pfemp=0;$vacday=0;$intgroup=0;$tcch=0;$budgroup=0;$house=0;$houserent=0;$meterrent=0;$stfassoc=0;$bitscoop=0;$nam='fg';$fathhusb='ui';$desig='abc';$admdesig='jio';$grdcode=0; $bankac='r';$bankcode='78';$sx='M';$fp_mem_yn='T'; $bsr=($_POST['bsr']); if(preg_match('/[^0-9]/', $bsr)) { die ("Error: BSRN should be a numeric value."); } $emptyp=($_POST['emptyp']); if (isset($_POST['emptyp']) && ($_POST['emptyp'] == 'Select')) { die("Please select employee type."); } $name=($_POST['name']); if(trim($_POST['name']) == "") { die ('<font color="##FF0000">Please enter a valid name.</font>'); } else if(preg_match('/[^A-Za-z .]/', $_POST['name'])) { die ("Error: Name should be a character value."); } $sx=($_POST['sx']); $current_date=date('Y-m-d'); $dob = $_POST['dob']; function birthday($dob){ list($year,$month,$day)=explode("-",$dob); $year_diff= date("Y") - $year; $month_diff= date("m") - $month; $day_diff= date("d") - $day; if($month_diff < 0) { $year_diff--; }elseif(($month_diff==0) && ($day_diff <0)) $year_diff--; return $year_diff; } $age=birthday($dob); if(trim($_POST['dob']) == "") { die ('<font color="##FF0000">Please select the date of birth</font>'); } else if($dob >= $current_date) { die ('<font color="##FF0000">Birth date is greater than or equal to Current date</font>'); } else if($age < 18) { die('<font color="##FF0000">Sorry You are under 18</font>'); } else $date_birth = $_POST['dob']; //echo "Date of birth: $dob"; //echo "Current date: $current_date"; $date_join = $_POST['doj']; if(trim($_POST['doj']) == "") { die ('<font color="##FF0000">Please select the joining date</font>'); } else if($current_date < $date_join) { die ('<font color="##FF0000">Joining date can not be greater current date</font>'); } else if($date_join <= $date_birth) { die ('<font color="##FF0000">Birth date can not be greater than or equal to joining date.</font>'); } $date_term = $_POST['dot']; if(trim($_POST['dot']) == "") { die ('<font color="##FF0000">Please select the termination date</font>'); } else if($date_term < $current_date ) { die ('<font color="##FF0000">Enter a valid termination date, Termination date should be later than current date</font>'); } $desig=($_POST['desig']); echo"sekfjkejsfseflsekf: $desig"; $fp_mem_yn=($_POST['fp_mem_yn']); $intdiv=($_POST['intdiv']); $buddiv=($_POST['buddiv']); $grdcode=($_POST['grdcode']); $basic=($_POST['basic']); if(trim($_POST['basic']) == "") { die ("Please enter basic pay."); } else if(preg_match('/[^0-9]/', $basic)) { die ("Error: Basic pay should be a numeric value."); } else if(($basic<2300 | $basic>50000) ) { die ("ERROR: Invalid Basic Pay.Enter between 2300 and 50000"); } $alwopf=($_POST['alwopf']); if(preg_match('/[^0-9]/', $alwopf)) { die ("Allowance without PF should be a numeric value."); } $alwipf=($_POST['alwipf']); if(preg_match('/[^0-9]/', $alwipf)) { die ("Allowance with PF should be a numeric value."); } $bankcode=($_POST['bankcode']); $bankac=($_POST['bankac']); if(preg_match('/[^0-9]/', $bankac)) { die ("Please enter only integer value for account number."); } else if(is_numeric($bankac)) { if(strlen($bankac)!=11) { die ("ERROR: Enter the 11 digit integer value for bank account number."); } } $draftcode=($_POST['draftcode']); if(strlen($bankac)==0 ) { $draftcode=($_POST['draftcode']); if(trim($_POST['draftcode']) == "") { die ("Please enter valid draft code."); } else if(preg_match('/[^0-9]/', $draftcode)) { die ("Error: Draft code should be a numeric value."); } else if(($draftcode<1 | $draftcode>99)) { die ("ERROR: Invalid Draft code.Enter between 1 and 99"); } } $fixpcode=($_POST['fixpcode']); if($fixpcode==0) //&& $basic>=2300 && $basic<=15000 { $query = "SELECT DDA FROM newdatab WHERE newdatab.RANGE1<=$basic AND newdatab.RANGE2>=$basic"; $result1= mysql_query($query, $connection) or die ("Error in query: $query"); $dda=mysql_result($result1,0,"DDA"); if ($result1) { $tempda=$dda; } else die("ERROR:No DA exists for this Basic Pay"); } $incmon=($_POST['incmon']); $incyr=($_POST['incyr']); if($incmon==0 && $incyr!=0){ die("Please select the increment month."); } else if($incmon!=0){ $year=date("Y"); $month=date("m"); if(trim($_POST['incyr']) == "") { die ('Please enter increment year value.'); } if(preg_match('/[^0-9]/', $incyr)) { die ("Please enter only integer value for increment year."); } if(is_numeric($incyr)) //PHP function to check the date entered. { if(strlen($incyr)!=4) { die ('ERROR: Enter a valid 4 digit increment year.'); } } if(($incyr <= $year) && ($incmon < $month)) { die ("Error: Increment year can not be less than current year."); } } $pfown=($_POST['pfown']); if($pfown>0) { $pfemp=12; } $houseno=($_POST['houseno']); $houserent=($_POST['house_rent']); if(preg_match('/[^0-9]/', $houserent)) { die ("House rent should be a numeric value."); } $tcch=($_POST['tcc']); if(preg_match('/[^0-9]/', $tcch)) { die ("TCC should be a numeric value."); } $meterrent=($_POST['meter_rent']); $stfassoc=($_POST['stf_assoc']); $bitscoop=($_POST['bits_coop']); $vacday=($_POST['vacday']); $fathhusb=($_POST['fathhusb']); if(trim($_POST['fathhusb']) == "") { die ("Please enter a valid Father/Husband name."); } else if(preg_match('/[^A-Za-z .]/', $_POST['fathhusb'])) { die ("Error: Father/Husband name should be a character value."); } $query = "INSERT INTO `paymajor` (`PSRN`, `BSRN`, `FLAG`, `EMP_TYPE`, `NAME`,`GENDER`, `DATE_BIRTH`, `DATE_JOIN`, `DATE_TERM`, `DESIG`, `ADM_DESIG`, `INT_DIV`, `INT_GROUP`, `BUD_DIV`, `BUD_GROUP`, `GRADE_CODE`, `BASIC_PAY`, `DA`, `INT_RELIEF`, `AL_WO_PF`, `AL_W_PF`, `BANK_CODE`, `BANK_AC`,`DRAFT_CODE`, `FIX_P_CODE`, `INC_MONTH`, `INC_YEAR`, `PF_OWN`, `PF_EMP`, `HOUSE_NO`, `HOUSE_RENT`, `TCC`, `METER_RENT`, `STF_ASSOC`, `BITS_COOP`, `VAC_DAYS`, `FATH_HUSB`) VALUES ('$psrn','$bsr','$flg','$emptyp','$name','$sx','$date_birth','$date_join','$date_term','$desig','$admdesig','$intdiv','$intgroup','$buddiv','$budgroup','$grdcode','$basic','$tempda','$intrel','$alwopf','$alwipf','$bankcode','$bankac','$draftcode','$fixpcode','$incmon','$incyr','$pfown','$pfemp','$houseno','$houserent','$tcch','$meterrent','$stfassoc','$bitscoop','$vacday','$fathhusb')"; $result = mysql_query($query) or die ("Error in query: $query"); if($result) { header ('Location: http://localhost/bitssap/success.php?psrn=' .$psrn); //print 'alert("Data entered successfully. The PSRN generated is" )'; } else { echo "Error. Please enter again.";} $query1 = "INSERT INTO `payminor` (`PSRN`) VALUES ('$psrn')"; $query2 = "INSERT INTO `paysumer` (`PSRN`) VALUES ('$psrn')"; $result = mysql_query($query1) or die ("Error in query: $query1. " . mysql_error()); $result = mysql_query($query2) or die ("Error in query: $query2. " . mysql_error()); } ?> Quote Link to comment Share on other sites More sharing options...
raj86 Posted October 29, 2009 Author Share Posted October 29, 2009 is it possible to convert javascript values(jvascript pasted above) into php values so that we can send that value into database... Quote Link to comment Share on other sites More sharing options...
seanlim Posted October 29, 2009 Share Posted October 29, 2009 Since you don't seem to have read my post, i'll repeat myself: You will have to use Javascript to dynamically-select the option you want, after changeList() is called Call the changeList() function again once the form has loaded. Thereafter, select the desired designation from the populated designation drop down. Your other option will to populate and select the option through PHP. Both methods will work, but the first requires lesser coding. To the best of my knowledge, "javascript values" and "php values" are the same - values. There is no need to "convert" them. Quote Link to comment Share on other sites More sharing options...
raj86 Posted October 30, 2009 Author Share Posted October 30, 2009 Hello seanlim you wrote: Your other option will to populate and select the option through PHP. 1. Dynamically-created SELECT loses its previously-selected value You will have to use Javascript to dynamically-select the option you want, after changeList() is called in the onload event. 2. Designation field not inserted into DB Please post your PHP code which handles the form submission. i am not able to write javascript to make it work........can you please help me to wrie it so that the above problems do not come. thank you Quote Link to comment Share on other sites More sharing options...
seanlim Posted October 30, 2009 Share Posted October 30, 2009 Sorry, i'm not currently in the mood to dish out free snippets of code, especially if you don't even try to help yourself. I might oblige to correct and improve on any code you post here though. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.