Guest User

process service

a guest
Nov 18th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1.  
  2. <?php include 'database.php';?>
  3.  
  4. <?php
  5. // create a variable
  6. $date=$_POST['date'];
  7. $idemployee1=$_POST['idemployee1'];
  8. $idemployee2=$_POST['idemployee2'];
  9.  
  10.  
  11. //Execute the query
  12.  
  13. mysqli_query($connect, "INSERT INTO sales
  14. (date, idemployee1, idemployee2) VALUES ('$date','$idemployee1','$idemployee2')");
  15.  
  16. if(mysqli_affected_rows($connect) > 0)
  17. {
  18. Print '<script>alert("Successfully Added !");</script>';
  19. Print '<script>window.location.assign("service.php");</script>';
  20.  
  21. }
  22. else {
  23. Print '<script>alert("Data Not Added !");</script>';
  24. echo mysqli_error ($connect);
  25. }
  26. mysqli_close($connect);
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment