Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. //request.php
  2. <?php
  3. include_once 'dbconnect.php';
  4. include_once 'functions.php';
  5.  
  6. session_start(); // Our custom secure way of starting a PHP session.
  7. //Select the database.
  8. //$db_selected = mysqli_select_db($link, $db_database);
  9. //if (!$db_selected) {
  10. // die ('Cant use database : ' . mysqli_error());
  11. if(mysqli_connect_errno()) {
  12. echo "Error: Could not connect to database.";
  13. exit;
  14. }
  15.  
  16. //Select the database.
  17. $db_selected = mysqli_select_db($link, $db_database);
  18. if (!$db_selected) {
  19. die ('Cant use database : ' . mysqli_error());
  20. }
  21.  
  22. $servicepost = $_POST['servicepost'];
  23. $duedate = $_POST['duedate'];
  24. $postdate = $_POST['postdate'];
  25. $username = $_POST['username'];
  26.  
  27. // Insert data into mysql
  28. $sql = "INSERT INTO serviceposts VALUES ('".$servicepost."', '".$duedate."', '".$postdate."', '".$username."')";
  29.  
  30. $result= $link -> query($sql);
  31.  
  32. // if successfully insert data into database, displays message "Successful".
  33. if($result){
  34. echo "request post success!";
  35. // header('Location: ../User.php?success=1');
  36. }
  37. else {
  38. echo "Possible data input error";
  39. //header('Location: ../user.php?error=1');
  40.  
  41.  
  42. }
  43. $link->close();
  44.  
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement