index.php
<?php
require './libs/Smarty.class.php';
// This is a file which abstracts the DB connecting functionality (Check out PEAR)
$smarty = new Smarty;
$smarty->template_dir = './templates/default/';
$smarty->compile_check = true;
//$smarty->debugging = true;
//$smarty->use_sub_dirs = false;
//$smarty->caching = true;
$db = mysql_connect("localhost","root","");
mysql_select_db("test");
// This SQL statement will get the 5 most recently added new items from the database
$sql = 'SELECT * ';
$sql .= 'FROM `news` ';
$sql .= 'ORDER BY `id` DESC';
$result = mysql_query($sql) or die("Query failed : " . mysql_error());
// For each result that we got from the Database
while ($line = mysql_fetch_assoc($result))
{
$value[] = $line;
// Assign this array to smarty...
}
$smarty->assign('news', $value);
/*@!@!#@$!$!#!@$!@$!$!@#@~!$
yes ,i change it here ,
i learn just a little,knowing that $**[] main autoincrease from 0
then assign an array called $** to 'news' in *.tpl
hahahahah^^ ,now my que~ has been solved!
*/
// Display the news page through the news template
$smarty->display('news.tpl');
?>
news.tpl
<!-- This is the DOC type declaration and links in the CSS stylesheet etc -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />
<meta name="author" content="Steve Rendell" />
<meta name="generator" content="EditPlus" />
<link rel="stylesheet" type="text/css" href="style.css" title="Default CSS Sheet" />
<!-- For the page title, we will pass this through from the PHP -->
<title>{$title}</title>
</head>
<body id="top">
<!-- OK display the page header to keep it nice-->
<div id="header">
<span>Steve's News Page</span>
</div>
<!-- This is where the news article will be going -->
<div id="bodyText">
<!-- Have a title -->
<h1 id="welcome">Read All About It</h1>
<!-- OK this is a section which will loop round for every item in $news (passed in through from PHP) -->
{section name=news loop=$news}
<!-- For every item, display the Title -->
<h2 id="{$news[news].id}">{$news[news].title}</h2>
<!-- Write out the Author information and the date -->
<h3>{$news[news].author}, {$news[news].date}</h3>
<!-- Now show the news article -->
{$news[news].article}
{/section}
</div>
<!-- Show copyright information etc -->
<div id="footer">All Contents Copy Written :)</div>
<!-- Close the html tags -->
</body>
</html>
