Advertisement
Guest User

Untitled

a guest
Feb 2nd, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. f_log($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 'Erro ao conectar com o MySQL: ' . $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. $sql2 = "SELECT ...."
  26. $return = pdomssql($sql2);
  27.  
  28. foreach ($return2 as $row2){
  29. // Guarda dados em variáveis.
  30. }
  31.  
  32. $sql2 = "SELECT ...."
  33. $return = pdomssql($sql2);
  34.  
  35. foreach ($return2 as $row2){
  36. // Guarda dados em variáveis.
  37. }
  38.  
  39. $sql2 = "SELECT ...."
  40. $return = pdomssql($sql2);
  41.  
  42. foreach ($return2 as $row2){
  43. // Guarda dados em variáveis.
  44. }
  45.  
  46. // Exibe resultados
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement