Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en" dir="ltr">
- <head>
- <meta charset="utf-8">
- <title>s</title>
- </head>
- <body>
- <form action="" method="post">
- Went to bed at<br>
- <input type="time" name="time1"><br>
- Woke up at:<br>
- <input type="time" name="time2">
- <input type="submit" >
- </form>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "db1";
- $conn = new mysqli($servername, $username, $password, $dbname);
- checkConnectivity($conn);
- function checkConnectivity($conn){
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- echo "Connected successfully";
- }
- ini_set('display_errors', 0);
- $current_time = strtotime($_POST['time2']);
- $old_time = strtotime($_POST['time1']);
- $difference = $current_time -= $old_time;
- echo "You slept for: " .
- "<b>" .
- number_format((float) abs($difference / 60 / 60 ), 2, '.', '') .
- "</b>" .
- " hours.";
- $conn->query("INSERT INTO table1 (fell_asleep)
- VALUES ('23')");
- ini_set('display_errors', 1);
- ?>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement