Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. function pdo_mysql($sql){
  2.  
  3. $host = *;
  4. $user = *;
  5. $pass = *;
  6. $db = *;
  7.  
  8. try {
  9. $PDO = new PDO( 'mysql:host=' . $host . ';dbname=' . $db, $user, $pass );
  10. }
  11. catch ( PDOException $e ) {
  12. echo 'MySQL error: ' . $e->getMessage(); exit;
  13. }
  14.  
  15. $result = $PDO->query( $sql );
  16.  
  17. if (is_array($result)){
  18. $row = $result->fetchAll( PDO::FETCH_ASSOC );
  19. }else{
  20. $row = $result;
  21. }
  22.  
  23. return $row;
  24.  
  25. }
  26.  
  27. $sql = "...";
  28. $return = pdo_mysql($sql);
  29.  
  30. foreach ($return as $row){
  31.  
  32. // Execute some functions and show the results in a table (using datatables plugin)
  33.  
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement