Posted By

Roaa on 01/26/11

Tagged

array

Versions (?)

Who likes this?

9 people have marked this snippet as a favorite

Ult1Mate
Roaa
BuRn
Solblem
fomigo
Some0ne
HelloKit
jbyerson
ringo380

Simple Pretty MySQL Fetch arrays

/ Published in: PHP

Highlighted TextExpand

<?php

/*
**  AUTHOR  - Ronnie Aarebrot.
**  Script  - Simple MySQL fetch array helper.
**  WebSite - www.RonnieAarebrot.com
**  
**  
**  Description
**  
**  This will return your mysql_fetch_array's into
**  some readable / simple arrays to use. The array
**  key will be the same name as used in your database columns.
**  
**  * HOW TO USE ? *
**
**  $query = mysql_query("SELECT * FROM users");
**  $array = sqlFetch($query);
**  echo "<pre>"; 
**  print_r($array);
**  echo "</pre>";
**
*/

* OUTPUT EXAMPLE *

Array
(
    [0] => Array
        (
            [id] => 1
            [username] => roaa
            [password] => 446bcd0025e013351288b5f7999434b42d40916c
            [mail] => mydomain@domain.com
            [sex] => male
        )

[1] => Array
        (
            [id] => 2
            [username] => fungirl
            [password] => 446bcd0025e013351288b5f7999434b42d40916c
            [mail] => mydomain@domain.com
            [sex] => female
        )

[2] => Array
        (
            [id] => 3
            [username] => dem0ns
            [password] => 446bcd0025e013351288b5f7999434b42d40916c
            [mail] => mydomain@domain.com
            [sex] => male
        )

[3] => Array
        (
            [id] => 4
            [username] => hell0
            [password] => 446bcd0025e013351288b5f7999434b42d40916c
            [mail] => mydomain@domain.com
            [sex] => male
        )

[4] => Array
        (
            [id] => 5
            [username] => meddoo
            [password] => 446bcd0025e013351288b5f7999434b42d40916c
            [mail] => mydomain@domain.com
            [sex] => female
        )

)

Report this snippet Tweet

Comments

Subscribe to comments

Posted By: Ult1Mate on January 26, 2011: Nice! love this function, makes it so easy!
Posted By: BuRn on January 27, 2011: Thanks! nice function, works great and so easy to use
Posted By: Solblem on January 27, 2011: thanks for sharing!
Posted By: nilambar on February 9, 2011: Nice. Very useful function. :-)

Comment:

You need to login to post a comment.