Posted By

ginoplusio on 02/01/10

Tagged

mysql
table
html

Versions (?)

Last Edited at 02/01/10 05:47am

Statistics

Viewed 1012 times

Favorited by 2 user(s)

Related snippets

MySQLi convert a result set to an HTML table

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function getHtmlTable($rs){
	// receive a record set and print
	// it into an html table
	$out = '<table>';
	while ($field = $rs->fetch_field()) $out .= "<th>".$field->name."</th>";
	while ($linea = $rs->fetch_assoc()) {
		$out .= "<tr>";
		foreach ($linea as $valor_col) $out .= '<td>'.$valor_col.'</td>';
		$out .= "</tr>";
	}
	$out .= "</table>";
	return $out;
}