0) { $rs = mysql_fetch_array($rs); extract($rs); $employee_name = $first_name_of_employee_english.' '.$middle_name_of_employee_english.' '.$last_name_of_employee_english; $rank = $present_rank; $training_code = $_REQUEST['tcode']; $center_code= $_REQUEST['ccode']; $training_duration_from_date = $fdate; $training_duration_to_date= $tdate; $REMARK = $_REQUEST['remark']; $courseDuration = $_REQUEST['courseDuration']; } $isApplicableInPromotion=0; if(isset($_POST['isApplicableInPromotion'])){ $isApplicableInPromotion=1; } mysql_query("insert into training_detail(personal_number,employee_name, rank, training_code, center_code, training_duration_from_date,training_duration_to_date, REMARK, isApplicableInPromotion,courseDuration) values('$personal_number', '$employee_name', '$rank', '$training_code', '$center_code', '$training_duration_from_date', '$training_duration_to_date', '$REMARK',$isApplicableInPromotion,'".$_REQUEST['courseDuration']."')") ; header("Location: confirm_training.php?id=".$personal_number); } function makeDate1($dt) { $dt = trim(str_replace('00:00:00', '', $dt)); //echo $dt.' lenth is: '.strlen($dt).'
'; if(strlen($dt) > 10) { $dt = trim(substr($dt,0,10)); } $dt = explode('-', $dt); $month = ''; switch($dt[1]) { case 1: $month = 'Jan'; break; case 2: $month = 'Feb'; break; case 3: $month = 'Mar'; break; case 4: $month = 'Apr'; break; case 5: $month = 'May'; break; case 6: $month = 'Jun'; break; case 7: $month = 'Jul'; break; case 8: $month = 'Aug'; break; case 9: $month = 'Sep'; break; case 10: $month = 'Oct'; break; case 11: $month = 'Nov'; break; case 12: $month = 'Dec'; break; } return $dt[2]. ' '.$month. ' '.$dt[0]; } function findrank($id = null) { $results=mysql_query("select serial_number,rank_id,rank_eng,rank_hin from rank_master where rank_id=".$id) ; if($x = mysql_fetch_array($results)) { return $x['rank_eng']; } else { return 'N/A'; } } $results=mysql_query("select key_id,personal_number,present_address,present_address_hindi,present_phone_residence_mobile,present_phone_office,present_range,present_state_name,present_district_name,present_rank,present_designation,proficiency_of_employee,present_grad,date_of_selection_grad,s_selection_grad_date,s_selection_grad,higher_selection_grad_date,higher_selection_grad,transfer_posting_flag,transfer_order_date,order_no,release_date,type_of_joining,joining_unit,joining_sub_unit,transfer_reason,posting_date,posting_time,pormotion_date,alloted_to,first_name_of_employee_english,middle_name_of_employee_english,last_name_of_employee_english,archive_date from new_posting_detail where personal_number='".$_REQUEST['id']."' ") ; $arow=mysql_fetch_array($results); extract($arow); ?> Uttar Pradesh Police Nominol Roll System
जनपद/इकाई का नाम
बैक  |  होम  |  लॉग आऊट  

प्रशिक्षण विवरण

पर्सनल नम्बर:

नाम: emp hindi name error = No database selected