Sometimes you want to manipulate database rows before they are displayed. Here is an example using MySQLi, TMPL_LOOP and ARRAY_PUSH.
PHP:<?php
if ('php' == $_GET['showsource'])
{
show_source($_SERVER['SCRIPT_FILENAME']);
exit;
}
elseif ('html' == $_GET['showsource'])
{
show_source(dirname(__FILE__) . '/tmpl/db.htm');
exit;
}
require_once 'vlib/vlibTemplate.php';
require_once 'vlib/vlibDate.php';
require_once 'db_config.php';
// Creating objects
$db = new mysqli(HOST, USER, PASSWORD, DATABASE);
$tmpl = new vlibTemplate('tmpl/db.htm');
$date = new vlibDate('de'); // you may set this to 'en' (english)
// database query
$select = 'SELECT name, birthday, city FROM ' . TABLE;
$result = $db->query($select)
or die('Error on SELECT:<br />' . $db->error . '<pre>' . $select . '</pre>');
// creating LOOP-Array and parse template
$table_data = array();
while ($row = $result->fetch_assoc())
{
array_push(
$table_data,
array(
'name' => $row['name'],
'birthday' => $date->formatDate($row['birthday'], '%A, %d. %B %Y'),
'city' => $row['city']
)
);
}
$tmpl->setloop('table_data', $table_data);
$tmpl->pparse();
// Call destruct
$db->close();
unset($db);
unset($tmpl);
?>Template:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<title>MySQL data in a table using MySQLi, TMPL_LOOP and ARRAY_PUSH</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<table border="1" width="70%" summary="MySQL data in a table using MySQLi, TMPL_LOOP and ARRAY_PUSH">
<caption>MySQL data in a table using MySQLi, TMPL_LOOP and ARRAY_PUSH</caption>
<thead>
<tr>
<th align="left">name</th>
<th align="left">birthday</th>
<th align="left">city</th>
</tr>
</thead>
<tbody>
<tmpl_loop name='table_data'>
<tr>
<td valign="top">{tmpl_var name='name'}</td>
<td valign="top">{tmpl_var name='birthday'}</td>
<td valign="top">{tmpl_var name='city'}</td>
</tr>
</tmpl_loop>
</tbody>
</table>
<p><a href="db.php?showsource=php">show PHP code</a> |
<a href="db.php?showsource=html">show template (HTML code)</a></p>
</body>
</html>MySQL data in a table using MySQLi, TMPL_LOOP and ARRAY_PUSH
