Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include 'database.php';?>
- <?php
- // create a variable
- $date=$_POST['date'];
- $idemployee1=$_POST['idemployee1'];
- $idemployee2=$_POST['idemployee2'];
- //Execute the query
- mysqli_query($connect, "INSERT INTO sales
- (date, idemployee1, idemployee2) VALUES ('$date','$idemployee1','$idemployee2')");
- if(mysqli_affected_rows($connect) > 0)
- {
- Print '<script>alert("Successfully Added !");</script>';
- Print '<script>window.location.assign("service.php");</script>';
- }
- else {
- Print '<script>alert("Data Not Added !");</script>';
- echo mysqli_error ($connect);
- }
- mysqli_close($connect);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment