Mysql result all - PHP Best Codes

Php Code: Mysql result all

Next Code

There is a PHP function named odbc_result_all which returns the query results in a table. I have frequently found it useful to have the same function for MySQL queries. This function will create a table populated with the data as well as the field names.

Usage:

$result = dbQuery("SELECT * FROM tableName");

mysql_result_all($result);

I am not a PHP master, so any improvement suggestions are welcome.

function mysql_result_all($result) { $nrow = 0; echo("<table border=1 cellpadding=5 cellspacing=0><tr><th>Row</th>\n"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<th>".mysql_field_name($result, $i)."</th>\n"); echo("</tr>\n"); while($row = mysql_fetch_array($result)) { echo("<tr><td>$nrow</td>"); for($i = 0; $i < mysql_num_fields($result); $i++) echo("<td>$row[$i]</td>\n"); echo("</tr>\n"); $nrow++; } echo("</table>\n"); } <br><font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/"><span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font>

If you don't know how to use this code or need more information Click here!

Go to Homepage

PHP Best Codes

Php Code: Mysql result all

You can leave comments once you sign in/up.

Review

Links

Visitor

Find Us

Link Us