Advanced Search

Simple Pretty MySQL Fetch arrays

/ Published in: PHP
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php
  2.  
  3. /*
  4. **  AUTHOR  - Ronnie Aarebrot.
  5. **  Script  - Simple MySQL fetch array helper.
  6. **  WebSite - www.RonnieAarebrot.com
  7. **  
  8. **  
  9. **  Description
  10. **  
  11. **  This will return your mysql_fetch_array's into
  12. **  some readable / simple arrays to use. The array
  13. **  key will be the same name as used in your database columns.
  14. **  
  15. **  * HOW TO USE ? *
  16. **
  17. **  $query = mysql_query("SELECT * FROM users");
  18. **  $array = sqlFetch($query);
  19. **  echo "<pre>"; 
  20. **  print_r($array);
  21. **  echo "</pre>";
  22. **
  23. */
  24.  
  25. function sqlFetch($query) {
  26.  
  27.     $numFields = mysql_num_fields($query);
  28.     $y = 0;
  29.     while($row = mysql_fetch_array($query)) {
  30.         $x = 0;
  31.         while($x < $numFields) {
  32.             $fieldName = mysql_field_name($query, $x);
  33.             $array[$y][$fieldName] = $row["$fieldName"];
  34.             $x++;
  35.         }
  36.         $y++;
  37.         $x = 0;
  38.     }
  39.  
  40.     return $array;
  41.  
  42. }
  43.  
  44. /*
  45.  
  46. * OUTPUT EXAMPLE *
  47.  
  48. Array
  49. (
  50.     [0] => Array
  51.         (
  52.             [id] => 1
  53.             [username] => roaa
  54.             [password] => 446bcd0025e013351288b5f7999434b42d40916c
  55.             [mail] => [email protected]
  56.             [sex] => male
  57.         )
  58.  
  59.     [1] => Array
  60.         (
  61.             [id] => 2
  62.             [username] => fungirl
  63.             [password] => 446bcd0025e013351288b5f7999434b42d40916c
  64.             [mail] => [email protected]
  65.             [sex] => female
  66.         )
  67.  
  68.     [2] => Array
  69.         (
  70.             [id] => 3
  71.             [username] => dem0ns
  72.             [password] => 446bcd0025e013351288b5f7999434b42d40916c
  73.             [mail] => [email protected]
  74.             [sex] => male
  75.         )
  76.  
  77.     [3] => Array
  78.         (
  79.             [id] => 4
  80.             [username] => hell0
  81.             [password] => 446bcd0025e013351288b5f7999434b42d40916c
  82.             [mail] => [email protected]
  83.             [sex] => male
  84.         )
  85.  
  86.     [4] => Array
  87.         (
  88.             [id] => 5
  89.             [username] => meddoo
  90.             [password] => 446bcd0025e013351288b5f7999434b42d40916c
  91.             [mail] => [email protected]
  92.             [sex] => female
  93.         )
  94.  
  95. )
  96.  
  97. */
  98.  
  99. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.