Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.84 KB | None | 0 0
  1. $cod_service=filter_var(trim($_POST['cod_service'],FILTER_SANITIZE_STRING));
  2.  
  3. $code_payment=filter_var(trim($_POST['code_payment'],FILTER_SANITIZE_STRING));
  4.  
  5. $descr_service=filter_var(trim($_POST['descr_service'],FILTER_SANITIZE_STRING));
  6.  
  7. $descr_payment=filter_var(trim($_POST['descr_payment'],FILTER_SANITIZE_STRING));
  8.  
  9. $start_hour=$_POST['start_hour'];
  10.  
  11. $end_hour=$_POST['end_hour'];
  12.  
  13. $free_time=$_POST['free_time'];
  14.  
  15. $working_hours=$_POST['working_hours'];
  16.  
  17. $absence_hours=$_POST['absence_hours'];
  18.  
  19. $idRecord=filter_var($_POST['idRecord'],FILTER_SANITIZE_NUMBER_INT);
  20.  
  21. $id_operator=filter_var($_POST['id_operator'],FILTER_SANITIZE_NUMBER_INT);
  22.  
  23. $start_date=strtotime($_POST['start_date']);
  24.  
  25. $start_date=date('Y/m/d H:i:s',$start_date);
  26.  
  27. $end_date= strtotime($_POST['end_date']);
  28.  
  29. $end_date=date('Y/m/d H:i:s',$end_date);
  30.  
  31. $id_service=filter_var($_POST['id_service'],FILTER_SANITIZE_NUMBER_INT);
  32.  
  33. $id_payment=filter_var($_POST['id_payment'],FILTER_SANITIZE_NUMBER_INT);
  34.  
  35. $flag=$_POST['flag'];
  36.  
  37. $query = $db_con->prepare("UPDATE attendance_tbl SET
  38.  
  39. 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
  40.  
  41. e=:free_time,working_hours=:working_hours,absence_hours=:absence_hours,id_payment=:id_payment,code_payment=:code_payment,descr_payment=
  42.  
  43. :descr_payment,id_service=:id_service,cod_service=:cod_service,descr_service=:descr_service,flag=:flag WHERE row_id=:id_record");
  44.  
  45. $query->bindParam(":id_record",$id_record);
  46.  
  47. $query->bindParam(":id_operator",$id_operator);
  48.  
  49. $query->bindParam(":start_date",$start_date);
  50.  
  51. $query->bindParam(":start_hour",$start_hour);
  52.  
  53. $query->bindParam(":end_date",$end_date);
  54.  
  55. $query->bindParam(":end_hour",$end_hour);
  56.  
  57. $query->bindParam(":free_time",$free_time);
  58.  
  59. $query->bindParam(":working_hours",$working_hours);
  60.  
  61. $query->bindParam(":absence_hours",$absence_hours);
  62.  
  63. $query->bindParam(":id_payment",$id_payment);
  64.  
  65. $query->bindParam(":code_payment",$code_payment);
  66.  
  67. $query->bindParam(":descr_payment",$descr_payment);
  68.  
  69. $query->bindParam(":id_service",$id_service);
  70.  
  71. $query->bindParam(":cod_service",$cod_service);
  72.  
  73. $query->bindParam(":descr_service",$descr_service);
  74.  
  75. $query->bindParam(":flag",$flag);
  76.  
  77. if($query->execute()){
  78. $stmt = $db_con->prepare("SELECT * FROM attendance_tbl WHERE row_id=:id_record LIMIT 1");
  79.  
  80. $stmt->execute(array(":id_record"=>$idRecord));
  81.  
  82. $result = $stmt->fetch(PDO::FETCH_BOTH);
  83.  
  84. var_dump($result);
  85.  
  86. }else{
  87.  
  88. echo"you failed";
  89. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement