$settings="active"; $caller1="open"; $staff_detil="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); session_start(); ?> if($_REQUEST['id']!='') { $update_option =1; } if(isset($_POST['sumbit'])) { date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $tablename = "`tbl_staff`"; $date=trim(addslashes($_REQUEST['date'])); $date = date("Y-m-d", strtotime($date)); $name=trim(addslashes($_REQUEST['name'])); $email_id=trim(addslashes($_REQUEST['email_id'])); $password=trim(addslashes($_REQUEST['password'])); //$reason_to_hour=trim(addslashes($_REQUEST['reason_to_hour'])); //$reason_to_min=trim(addslashes($_REQUEST['reason_to_min'])); //$reason_to_am=trim(addslashes($_REQUEST['reason_to_am'])); if ($_REQUEST["form_action"] == "Update") { $Query="UPDATE `tbl_staff` SET `name`='" .$name. "',`email_id`='" .$email_id. "',`password`='" .$password. "' WHERE `id`='".$_REQUEST['id']."'"; $DB->query($Query); $flag="sucess"; } if ($_REQUEST["form_action"] == "Insert") { $Query_last_invoice = "SELECT email_id from tbl_staff where (email_id='".$email_id."' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); /*if($noo==0) {*/ $Query = "insert into $tablename values( NULL,'". $name . "','". $email_id . "','". $password . "','0')"; $DB->query($Query); $flag="sucess"; /*}*/ /* else { $flag="failure"; }*/ } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_job_details'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from tbl_staff where id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $name=$row_12_123['name']; $email_id=$row_12_123['email_id']; $password=$row_12_123['password']; //$app_date = date("m/d/Y", strtotime($datea)); } ?>