Page 1 of 1

help needed to insert the data in database

Posted: Wed Oct 28, 2009 10:59 pm
by raj86
hello friends....
i am having a working javascript....when i am selecting any designation and refresh the form than it 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........

Code: Select all

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>

Code: Select all

<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>

Code: Select all

$desig=($_POST['desig']);

Re: help needed to insert the data in database

Posted: Thu Oct 29, 2009 1:19 am
by raj86
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

i am using this code to insert the data in database

$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" )';
}