从数据库查询数据，浏览器以表格形式显示

注意区别index 和iteration

index为数组下标索引

iteration为序号

模板页面

<tableborder="1"width="800"align="center"><caption>用户信息表</caption><thalign="center">index</th><thalign="center">iteration</th><{foreach$tdnameas$val}><thalign="center"><{$val}></th><{/foreach}><{sectionname="one"loop=$usersstep=2start=2}><{if$smarty.section.one.first}><trbgcolor="red"align="center"><{elseif$smarty.section.one.last}><trbgcolor="yellow"align="center"><{elseif$smarty.section.one.iterationiseven}><trbgcolor="pink"align="center"><{else}><trbgcolor="green"align="center"><{/if}><td><{$smarty.section.one.index}></td><td><{$smarty.section.one.iteration}></td><td><{$users[one].id}></td><td><{$users[one].username}></td><td><{$users[one].password}></td><td><{$users[one].email}></td></tr><{sectionelse}>没有用户查询出来！<{/section}></table>

php页面

<?php//创建smarty对象require_once'./libs/Smarty.class.php';//定义根目录define('ROOT',str_replace("\\","/",dirname(__FILE__))."/");//实例化Smarty类$smarty=newSmarty();//设定定界符$smarty->left_delimiter="<{";$smarty->right_delimiter="}>";//设置为false定界符号左右可以有空格$smarty->auto_literal=false;//添加一个插件的目录//$smarty->setPluginsDir(ROOT."/libs/myplugins/");//注意添加一个插件,要把系统默认设置的路径加入否则不能使用默认系统的插件$smarty->setPluginsDir(array(ROOT."/libs/plugins/",//系统默认设置的路径ROOT."/libs/myplugins/",//自定义的));//连接数据库constDSN='mysql:host=localhost;dbname=test';constDBUSER='root';constDBPWD='root';try{$pdo=newPDO(DSN,DBUSER,DBPWD);}catch(PDOException$e){echo"数据库连接失败:".$e->getMessage();exit;}$query="selectid,username,password,emailfromusers";$stmt=$pdo->prepare($query);$stmt->execute();$users=$stmt->fetchAll(PDO::FETCH_ASSOC);$smarty->assign('users',$users);//var_dump($users);$query="descusers";$stmt=$pdo->prepare($query);$stmt->execute();$tdname=$stmt->fetchAll(PDO::FETCH_COLUMN);//var_dump($tdname);$smarty->assign('tdname',$tdname);//变量输出$smarty->display('hello.tpl');?>

浏览器输出