Im just making this as a resource for people who do not know how to/can't remember how to make a loop for mysql data in PHP
READ THIS FIRST:
Kae's Mysql and PHP Basics
This thread will show you how to utilize the while function in php loops to help with outputting mysql data.
1. How to setup the while loop for data processing
PHP Code:
$i=0; // This is what we will use to know where we are in our loop
$num = mysql_num_rows($mysqlresults); // Can be named whatever you want and is compared to $i to know where we are
The two variables above are very important...
To get mysql data into a variable, it's basically the same as putting a number in a variable
PHP Code:
$mysqlresults = mysql_query($query);
Now we must initiate the while loop :D
PHP Code:
while($i < $num){
// Our processing will go here
}
Now if your wondering why we used a < symbol instead of a <= is because mysql row numbers start at 0 and increase by 1
Let's pretend we have 2 columns in our table
We currently have 5 rows inserted into our table also...
- firstname lastname
- Glenn Quagmire
- Peter Griffin
- Joe Swanson
- Cleveland Brown
- Robo Chicken
Were are going to make our page output for each row: Hello My Name is (firstname) of the (lastname) family.
A nifty little function we will be using is called mysql_result()
Heres basically how it works
PHP Code:
$variable = mysql_result($mysql_data,$rownumber,$columnname);
In this case we will have to use it twice, and your $rownumber will be $i
Also, before i forget If you don't already know, there is a nice shortcut for upping your $vars by 1, its $var++;
Now let's start the actual coding
First Let's get our data from our table and initiate the while loop
PHP Code:
$names = mysql_query("SELECT * FROM ".$prefix."tablename"); // As you should know this will get ALL rows from table '$prefix'tablename
$num = mysql_num_rows($names); // Get how many rows (5)
$i=0; // I don't put in spaces because... its a habit... and it technically takes more time to type
$allnames = ""; // This will hold all of the names when we are done
while($i < $num){
}
OK, Now that that is ready, lets get the data from the row's (specified by $i) data in firstname
PHP Code:
while($i < $num){
$firstname = mysql_result($names,$i,"firstname");
}
This stores the rows firstname into a var to make it easier to manipulate
Now we get the second row:
PHP Code:
while($i < $num){
$firstname = mysql_result($names,$i,"firstname");
$lastname = mysql_result($names,$i,"lastname");
}
There, we are getting both columns of each row
Now we use a simple method to echo the results onto the page
PHP Code:
while($i < $num){
$firstname = mysql_result($names,$i,"firstname");
$lastname = mysql_result($names,$i,"lastname");
echo "Hello, my name is ".$firsname." of the ".$lastname." family.<br>";
}
The output of this would be
Code:
Hello, my name is Glenn of the Quagmire family.
Hello, my name is Peter of the Griffin family.
Hello, my name is Joe of the Swanson family.
Hello, my name is Cleveland of the Brown family.
Hello, my name is Robo of the Chicken family.
And there ya go, that's how you use while loops to output mysql data :D
I hope this helped
