Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $cod_service=filter_var(trim($_POST['cod_service'],FILTER_SANITIZE_STRING));
- $code_payment=filter_var(trim($_POST['code_payment'],FILTER_SANITIZE_STRING));
- $descr_service=filter_var(trim($_POST['descr_service'],FILTER_SANITIZE_STRING));
- $descr_payment=filter_var(trim($_POST['descr_payment'],FILTER_SANITIZE_STRING));
- $start_hour=$_POST['start_hour'];
- $end_hour=$_POST['end_hour'];
- $free_time=$_POST['free_time'];
- $working_hours=$_POST['working_hours'];
- $absence_hours=$_POST['absence_hours'];
- $idRecord=filter_var($_POST['idRecord'],FILTER_SANITIZE_NUMBER_INT);
- $id_operator=filter_var($_POST['id_operator'],FILTER_SANITIZE_NUMBER_INT);
- $start_date=strtotime($_POST['start_date']);
- $start_date=date('Y/m/d H:i:s',$start_date);
- $end_date= strtotime($_POST['end_date']);
- $end_date=date('Y/m/d H:i:s',$end_date);
- $id_service=filter_var($_POST['id_service'],FILTER_SANITIZE_NUMBER_INT);
- $id_payment=filter_var($_POST['id_payment'],FILTER_SANITIZE_NUMBER_INT);
- $flag=$_POST['flag'];
- $query = $db_con->prepare("UPDATE attendance_tbl SET
- row_id=:id_record,id_operator=:id_operator,start_date=:start_date,start_hour=:start_hour,end_date=:end_date,end_hour=:end_hour,free_tim
- e=:free_time,working_hours=:working_hours,absence_hours=:absence_hours,id_payment=:id_payment,code_payment=:code_payment,descr_payment=
- :descr_payment,id_service=:id_service,cod_service=:cod_service,descr_service=:descr_service,flag=:flag WHERE row_id=:id_record");
- $query->bindParam(":id_record",$id_record);
- $query->bindParam(":id_operator",$id_operator);
- $query->bindParam(":start_date",$start_date);
- $query->bindParam(":start_hour",$start_hour);
- $query->bindParam(":end_date",$end_date);
- $query->bindParam(":end_hour",$end_hour);
- $query->bindParam(":free_time",$free_time);
- $query->bindParam(":working_hours",$working_hours);
- $query->bindParam(":absence_hours",$absence_hours);
- $query->bindParam(":id_payment",$id_payment);
- $query->bindParam(":code_payment",$code_payment);
- $query->bindParam(":descr_payment",$descr_payment);
- $query->bindParam(":id_service",$id_service);
- $query->bindParam(":cod_service",$cod_service);
- $query->bindParam(":descr_service",$descr_service);
- $query->bindParam(":flag",$flag);
- if($query->execute()){
- $stmt = $db_con->prepare("SELECT * FROM attendance_tbl WHERE row_id=:id_record LIMIT 1");
- $stmt->execute(array(":id_record"=>$idRecord));
- $result = $stmt->fetch(PDO::FETCH_BOTH);
- var_dump($result);
- }else{
- echo"you failed";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement