Advertisement
Guest User

Untitled

a guest
Jul 1st, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. // Query Parameters
  2. $params = array( 1, 5 );
  3.  
  4. // Get Products
  5. $query = "SELECT * FROM mydb.Product
  6. WHERE ProductId >= ?
  7. AND IsApproved = 1
  8. AND IsPublic = 1
  9. LIMIT ?";
  10.  
  11. // Get Database Instance
  12. $dbh = AppApp::getDatabase()->getInstance();
  13.  
  14. // Prepare Query
  15. if( $stmt = $dbh->prepare($query) )
  16. {
  17. if( $stmt->execute($params) )
  18. {
  19. // Return Records
  20. }
  21. }
  22.  
  23. object(PDOStatement)[59]
  24. public 'queryString' => string 'SELECT * FROM mydb.Product
  25. WHERE ProductId >= ?
  26. AND IsApproved = 1
  27. AND IsPublic = 1
  28. LIMIT ?'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement