Advertisement
Guest User

Untitled

a guest
May 8th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. <?php
  2.  
  3. $dbhost = 'localhost';
  4. $dbuser = 'gps';
  5. $dbpass = 'abcd4321';
  6. $dbtable = 'route';
  7. $conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbtable);
  8. if(! $conn )
  9. {
  10. die('Could not connect: ' . mysqli_error());
  11. }
  12.  
  13. date_default_timezone_set("Asia/Kolkata");
  14.  
  15. $atime = date("g:i A");
  16. $rid = "1";
  17. $rloc = $_GET['cloc'];
  18.  
  19. $sql = " UPDATE routes SET atime = '$atime', rid = '$rid' WHERE rloc = '$rloc' ";
  20.  
  21. if ($conn->query($sql) === TRUE) {
  22. echo "Record updated successfully";
  23. } else {
  24. echo "Error updating record: " . $conn->error;
  25. }
  26.  
  27. $conn->close();
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement