Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. function pdo_mssql($sql){
  2.  
  3. $host = ***;
  4. $user = ***;
  5. $pass = ***;
  6. $db = ***;
  7.  
  8. try {
  9. $PDO = new PDO( 'dblib:host=' . $host . ';dbname=' . $db, $user, $pass );;
  10. }
  11. catch ( PDOException $e ) {
  12. echo 'MSSQL 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 = "SELECT ....";
  28. $return = pdo_mssql($sql);
  29.  
  30. foreach ($return as $row){
  31.  
  32. $sql2 = "SELECT ...."
  33. $return = pdomssql($sql2);
  34.  
  35. foreach ($return2 as $row2){
  36. // Do something
  37. }
  38.  
  39. $sql2 = "SELECT ...."
  40. $return = pdomssql($sql2);
  41.  
  42. foreach ($return2 as $row2){
  43. // Do something
  44. }
  45.  
  46. $sql2 = "SELECT ...."
  47. $return = pdomssql($sql2);
  48.  
  49. foreach ($return2 as $row2){
  50. // Do something
  51. }
  52.  
  53. // Show results
  54.  
  55. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement