[TUT] Performing a simple database select query with PHP

[Calon]

Pretty simple, a lot of people use PHP files too do this,

<?php
mysql_query( "QUERY" );
?>

Here are a few things;

SELECT - Select's from your database
* - Wildcard; grabs everything matching your query critera.
WHERE - Where field name has the result of

So here's an example query, using the three of them;

SELECT * FROM `users` WHERE `id` = '1'

And a bit of PHP..

<?php
// Assume we're already connected to the database ;)

// Querying the database..
$query = mysql_query( "SELECT * FROM `users` WHERE `id` = '1'" );

// While - gets all the results and does what you want to do with them in the while statement, and continously repeats them.
while( $object = mysql_fetch_object( $query ) )
{
       echo $object->username; // You can use object or arrays, I'm an object fan. We're grabbing the field name "username"
}
?>

That above, is just a simple select statement, and will repeat any result with the field named "id" which has the result of 1.

[MasterFM]

Gee, this is a pretty good tutorial

[Calon]

Gee, this is a pretty good tutorial

Might help the new coders out! Like you! aha.

[MasterFM]

OOOooo.
FAILLLLL


Edited by Yoshimitsui (Forum Super Moderator): Please do not make pointless comments.

[Source]

INDENTATION CALON, INDENTATION!!!!

<?php
//connect here

//perform the query
$query = mysql_query( "SELECT * FROM `users` WHERE `id` = '1'" );

//while loop for echoing out zem all
while( $object = mysql_fetch_array( $query ) )
{
      echo $object['username'];
}
?>

[Excellent2]

Didn't you post this on faildev? I mean codedev.

Edited by Meti (Forum Moderator): Please don't post to cause arguments.

[MasterFM]

INDENTATION CALON, INDENTATION!!!!

<?php
//connect here

//perform the query
$query = mysql_query( "SELECT * FROM `users` WHERE `id` = '1'" );

//while loop for echoing out zem all
while( $object = mysql_fetch_object( $query ) )
{
      echo $object->username;// You can use object or arrays, I'm an object fan. We're grabbing the field name "username"
}
?>

lmaocopters


Edited by Yoshimitsui (Forum Super Moderator): Please do not continue to make pointless comments.

[Calon]

INDENTATION CALON, INDENTATION!!!!

<?php
//connect here

//perform the query
$query = mysql_query( "SELECT * FROM `users` WHERE `id` = '1'" );

//while loop for echoing out zem all
while( $object = mysql_fetch_object( $query ) )
{
      echo $object->username;// You can use object or arrays, I'm an object fan. We're grabbing the field name "username"
}
?>

It was an example, I can't indent in firefox using tab. I would have otherwise.

Didn't you post this on faildev? I mean codedev.

Nothing fails worse than you. Yes I did, the more people the tutorial helps the better.

[Source]

5 spaces, SPACES!

Ok, I'll stop with the over exaggeration now.

[Calon]

5 spaces, SPACES!

Ok, I'll stop with the over exaggeration now.

Thank you!

I never use spaces, even though firefox if I use tab they automatically convert.