Our demonstration php page is going to return the HTML for ResultsPage, along with a table full of results (with title and hits columns) using the information from the database. If you want to create the table and dummy data for the database, use the following MySQL statement:
CREATE TABLE items (
id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
title varchar(30) NOT NULL,
hits int NOT NULL DEFAULT ''
);
INSERT INTO items (title,hits) VALUES ('Test Item 1',29),('Test Item 2',15),('Test
Item 3',0);
Lets now take a look at the php code required to do this.
<?
#set the page title and query
$pagetitle = "Search Results";
$searchquery = "Dummy search";
#get the database information
$query = mysql_query("SELECT title,hits FROM items ORDER BY hits DESC LIMIT
10");
#loop through the results
while ($data=mysql_fetch_array($query)) {
#load the template for this instance, appending the
data onto $resultbits
eval("\$resultbits .= \"".gettemplate("ResultsBit")."\";");
}
#now return the whole template
eval("echo \"".gettemplate("ResultsPage")."\";");
?>
The code is actually very simple; it sets a few variables, loads the data from a template, and then outputs the data. However, it's those eval statements that do all the hard work, and need looking at more closely.
Comments