Advertisement
Guest User

Untitled

a guest
Aug 17th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. function dataBaseConnect(){
  2.             $dbuser = 'xx';
  3.             $dbpassword = 'xxx';
  4.             try {
  5.                 $this->handler = new PDO('mysql:host=localhost;dbname=x', $dbuser, $dbpassword);
  6.                 $this->handler->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  7.             } catch (PDOException $err) {
  8.                 echo $err->getMessage();
  9.                 die();
  10.             }
  11.         }
  12. function getTimeValue(){
  13.         //$this->start= "SELECT `start_time` FROM `table_ex` WHERE id=(SELECT MAX(id) FROM `table_ex`)";
  14.         //$this->handler->exec($this->start);
  15.  
  16.         $sql = "SELECT `start_time` FROM `table_ex` WHERE id=(SELECT MAX(id) FROM `table_ex`)";
  17.         $this->start = $this->handler->query($sql, PDO::FETCH_COLUMN, 0);
  18.     }
  19.  
  20. function printVal(){
  21.         //tak w skrócie jak chcę wykorzystać tę zmienną
  22.  
  23.         dataBaseConnect();
  24.         getTimeValue();
  25.         $this->messOuput = "Sth text " .$this->startTime;
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement