Advertisement
Guest User

Untitled

a guest
Oct 4th, 2015
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. <?php
  2. $conn = mysqli_connect("127.0.0.1", "root", "", "todo_list");
  3.  
  4. $taskname = $_POST["taskname"];
  5. $taskcompdate = date_create($_POST["taskcompdate"]);
  6. $taskpriority = $_POST["taskpriority"];
  7. $datenow = date("H:i:s d/m/y");
  8.  
  9. $insert_date1 = date_format($taskcompdate, "d/m/y");
  10. $insert_date2 = date('H:i:s d/m/y', strtotime($datenow));
  11.  
  12. $sql_priority = "INSERT INTO task_priority (taskpr) VALUES ($taskpriority)";
  13.  
  14.  
  15. $sql_main = "INSERT INTO task_main (task, complete_date, added_date) VALUES ('$taskname', '$insert_date1', '$insert_date2')";
  16. $result = mysqli_query($conn, $sql_main);
  17. if ($result) {
  18. echo 'success'; } else {
  19. echo 'failure' . mysqli_error($conn); } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement