Pixel2Life Forum > [PHP] - [Simplifying MySQL Results]

Full Version: [PHP] - [Simplifying MySQL Results] - [Apache]

Pixel2Life Forum > Member Tutorials and Requests > Forum Tutorial Archives > PHP Tutorials

Apache

Mar 23 2005, 06:23 PM

Now we all know this sort of query to get some simple from the Database:

QUOTE

include('connect.php');
$query = "SELECT * FROM table WHERE name = 'Apache'";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result) {
echo $row['name'];
}

NOw this is a great way, but imagin you had 20 pieces of data, and dont want to write $row[''] every time. Well here the solution

QUOTE

include('connect.php');
$query = "SELECT * FROM table WHERE name = 'Apache'";
$result = mysql_query($query);

while($row = mysql_fetch_assoc($result) {
extract($row);
echo $name;
}

This simple line of code pulls the $row out of the variablkes, so now you can call on them using the name of the mysql row, without that nasty $row['']

adrian

May 18 2005, 10:53 AM

Will this work with register_globals off?

Ruben K

May 18 2005, 12:03 PM

This has no point.

MalDON

May 18 2005, 07:33 PM

yea, it does. Although, I name all my viables first that way i know what I need rather than doing it this way.

rus321

Feb 10 2006, 06:16 AM

this is really good... my site im working on i had to extract each 1 and i had about 20 fields...this comes in handy

austen

Feb 10 2006, 11:56 AM

This would be a big help to those who are semi-new to PHP as it was for me at that time, but for experienced PHP developers, this should be common knowledge.

Indigo

Feb 13 2006, 03:01 AM

I like this one, since I have about 20 nasty $row['']´s in some of my systems.

Matthew.

May 17 2006, 03:28 PM

QUOTE(Apache @ Mar 24 2005, 12:22 AM)

NOw this is a great way, but imagin you had 20 pieces of data, and dont want to write $row[''] every time. Well here the solution

Or you were using mysql_fetch_object and hadto write $row -> field;

I've never used this as i deem it pointless, if you gonna code something well then time isnt an issue and just removing $row[''] had no effect on load time really. Also say you did a query within a query then used extract but they had the same field names your kinda screwed.

Enter $row['']

BTW: Why does everyone use $row[''] lol. how about $madbannanstickytoffepudding[''] lol. Kiddin.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.