Output of mySQL in PHP

pharess

Can someone give me a good example of formatting output of a record with PHP accessing mySQL? I currently pulling one record into one long string, in a table, but need to echo back one record with each field individually, in seperate variables, in a table. I'm fairly new to this, so would appreciate any help, thanks.
My current code looks like this:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "\t<tr>\n";
foreach ($line as $col_value)
{
echo "\t\t<td>$col_value</td>\n";

}
echo "\t</tr>\n";
}
echo "</table>\n";

Instead of $col_value containing the whole record, I need a bunch of variables containing parts of the $line.....

I am doing this to format the output.
AGain, Thanks.

coreyp_1

instead of

 foreach ($line as $col_value)
{
echo "\t\t<td>$col_value</td>\n";

}

try:

foreach ($line as $key => $col_value)
{
  echo "\t\t<td>$col_value</td>\n";
}

coreyp_1

BAH! :glare: on second reading, this probably won't change your output.

On to another issue: You said that the variables are being returned in a string, but I don't see how this can be. mysql_fetch_array() returns an array of variables, the key of which is the column names of your MySQL query.

If this doesn't make sense, then can you show me what query you are using?

Or, can you give us an example of what output you are getting, as opposed to what output you want to get?

pharess

// Performing SQL query
$query = "SELECT * FROM Password_List WHERE Client_Name='$Client_Query'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table align=center border=2>\n";
echo "\t<tr align=center>\n";
echo "\t\t<td><b><u>Client Name</td>";
echo "\t\t<td><b><u>App Name</td>";
echo "\t\t<td><b><u>App Version</td>";
echo "\t\t<td><b><u>User Name</td>";
echo "\t\t<td><b><u>Password</td>";
echo "\t\t<td><b><u>Tech</td>";
echo "\t\t<td><b><u>Name</td>";

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr align=center>\n";
foreach ($line as $col_value1) {
echo "\t\t<td>$col_value1</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

I must have misunderstood what my code was passing back. I thought it was passing back a string of the entire record but you are saying it's actually passing back each field, seperately?
If that is the case, how do I break it up? Meaning, if I wanted to move the second variable to the next line, ie:in my table????
Thanks.

pharess

Or maybe show me a better way of passing back the ouput?
Instead of hardcoding the column headers, maybe automating it to automatically pass them back???

Thanks for all the help!

coreyp_1

Your data is being pulled from mysql into an array. You can access specific parts of it using $line['whatever_field_you_want']

if you want to automatically print out your column headers as well, then you can use the foreach( $key => $val ) loop, in which $key will contain the column name from MySQL. In all honesty, though, I do not see a reason to use loops to create your content, other than the loop that calls mysql_fetch_array(). Unless you are creating a massive table, and the MySQL column names are exactly how you want them to appear in the table, then using loops is (to me) overkill. Just hand code what you want to appear, in the order you want it to appear.

Clear as mud? 🙂