Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $task = $_POST["task"];
- $payCode = $_POST["payCode"];
- $startTime = $_POST["startTime"];
- $finishTime = $_POST["finishTime"];
- $totalBreaks = $_POST["totalBreaks"];
- $totalHours = $_POST["totalHours"];
- $comments = $_POST["comments"];
- $title = $_POST["title"];
- $value = $_POST["value"];
- $receipt = $_POST["receipt"];
- $converted_receipt = ($receipt) ? 'true' : 'false';
- $servername = "localhost";
- $username = "root";
- $pass = "pass";
- $dbName = "SheetPal";
- $conn = mysqli_connect($servername , $username , $pass , $dbName);
- echo ()
- if(!$conn){
- die("Connection failed: " . mysqli_connect_error());
- }
- $expenseSql = $conn->prepare("INSERT INTO expenses(title , value , receipt)
- VALUES (? , ? , ?)");
- $expenseSql->bind_param("sss" , $title , $value , $receipt);
- $expenseID = $expenseSql->insert_id;
- $shiftsSql = $conn->prepare( "INSERT INTO shifts (task , paycode , starttime , finishtime, breaks , totalhours , expenseid , comments)
- VALUES (? , ? , ? , ? , ? , ? , ? , ?)");
- $shiftsSql->bind_param("ssssssss" , $task , $payCode , $startTime , $finishTime , $totalBreaks , $totalHours , $expenseID , $comments);
- if(mysqli_query($conn , $expenseSql)) {
- echo true;
- }
- else{
- echo "Error: " . $expenseSql . "\n" . mysqli_error($conn);
- }
- if(mysqli_query($conn, $shiftsSql)) {
- echo true;
- }
- else {
- echo "Error: " . $shiftsSql . "\n" . mysqli_error($conn);
- }
- mysqli_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement