Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.78 KB | None | 0 0
  1.     public function getBusinessInfo ($id)
  2.     {    
  3.     try {              
  4.         $sql = "SELECT * FROM businesses WHERE id=:id";
  5.         $stmt = $this->db->prepare($sql);
  6.         $stmt->bindValue(':id',$id);
  7.         $stmt->execute();
  8.         $result = $stmt->fetchAll();
  9.         if(time()-$result[0]['updated'] > $this->age){
  10.             $this->yelp->updateBusiness($result[0]['phone'],"update");
  11.             $sql = "SELECT * FROM businesses WHERE id=:id";
  12.             $stmt = $this->db->prepare($sql);
  13.             $stmt->bindValue(':id',$id);
  14.             $stmt->execute();
  15.             $result = $stmt->fetchAll();
  16.         }
  17.         print_r($result[0]);
  18.         return $result[0];
  19.     }
  20.         catch (PDOException $e) {
  21.             die($e->getMessage());
  22.         }
  23.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement