PHP Fast Template - MySQL Data parsed through FastTemplates
(Page 4 of 6 )
Using the above information as a guide, look at this code that works on data taken from a MySQL database and parses it through HTML templates.
<?php
//getData.php
include "class.FastTemplate.php3";
//instantiate a new FastTemplate instance
$tpl = new FastTemplate("../templates");
//associate an HTML template to a variable
$tpl->define(array(
"toplevel" => "phone_numbers.tpl"
));
//Connect to database
mysql_connect (localhost, root, passwd);
//select database to use
mysql_select_db (testDB);
//select data from MySQL database for example code
$GetData = mysql_query ("select Phone from Business where Name = '$Name'");
//Get array results
$GetDataArray = mysql_fetch_array($GetData);
//Associate contents of hash array with variable
$Phone = $GetDataArray["Phone"];
//assign $Phone to FastTemplate instance
$tpl->assign("PHONE", $Phone);
//pass the data to the HTML template
$tpl->parse(MAIN, "toplevel");
$tpl->FastPrint();
?>
From here, the phone number data taken from the database will
be passed to the HTML template, "phone_numbers.tpl". Here are the contents of phone_numbers.tpl :
<HTML>
<BODY>
<P>
Here is the phone number you wanted:
{PHONE}
</P>
</BODY>
</HTML>
On the web page it will look like this:
Here is the phone number you wanted:
555-5555
Next: Multiple templates: Rows of data into a table >>
More PHP Articles
More By Ian Felton
