Guest User

Untitled

a guest
Nov 18th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. $con=mysqli_connect("abc", "abc", "abc", "abc");
  2. if (mysqli_connect_errno()) {
  3. echo "Failed to connect to MariaDB: " . mysqli_connect_error();
  4. }
  5. /* check connection */
  6. if ($con->connect_errno) {
  7. printf("Connect failed: %sn", $con->connect_error);
  8. exit();
  9. }
  10.  
  11. $t = new Timer($con);
  12. // lots of irrelevant code
  13. unset($t);
  14.  
  15. class Timer {
  16. private $time = null;
  17. private $con;
  18. public function __construct($con) {
  19. $this->$con = $con;
  20. $this->time = time();
  21. echo 'Working - please wait..<br/>';
  22. }
  23.  
  24. public function __destruct() {
  25. $basename = basename($_SERVER['PHP_SELF']);
  26. $query = "SELECT ScriptID FROM scripts WHERE `ScriptURL` = '$basename';";
  27. $scriptIDResult = mysqli_fetch_assoc(mysqli_query($con, $query)) or die(mysqli_error($con));
  28. $t->scriptID = $scriptIDResult['ScriptID'];
  29. $elapsed = (time()-$this->time);
  30. echo '<br/>Job finished in '.($elapsed).' seconds.';
  31. $scriptQuery = "UPDATE `scriptruns` SET `ScriptExecutedTime` = '$elapsed', `ScriptRunDate` = NOW() WHERE `ScriptID` = '$scriptID'";
  32. $result = mysqli_query($con, $scriptQuery) or die(mysqli_error($con));
  33. }
  34. }
Add Comment
Please, Sign In to add comment