help needed to insert the data in database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
raj86
Forum Commoner
Posts: 25
Joined: Tue Sep 29, 2009 12:28 am

help needed to insert the data in database

Post 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']);
raj86
Forum Commoner
Posts: 25
Joined: Tue Sep 29, 2009 12:28 am

Re: help needed to insert the data in database

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