展开全部
举个例子636f707962616964757a686964616f31333339653739:require('../libs/SmartySQL.class.php');
$smarty = new SmartySQL( array('pdo_dsn' => 'mysql:dbname=db_name;host=localhost',
'pdo_username' => 'username',
'pdo_password' => 'password',
'pdo_driver_options' => array() ) );
$smarty->display('index.tpl');
模板内容:
ID | Name | Details |
{foreach from=$res item=i sql="SELECT id, name, email FROM contacts"}
{$i.id}{$i.name}{$i.email} Info{/foreach}
{if $smarty.request.id}
User info:
{foreach from=$res item=i
sql="SELECT id, name, email FROM contacts WHERE id = {$smarty.request.id}"}
ID: {$i.id}
Name: {$i.name}
E-Mail: {$i.email}
{/foreach}
{/if}
数据库:DROP TABLE IF EXISTS contacts;
CREATE TABLE contacts (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
name VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name',
email VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'E-Mail',
PRIMARY KEY (id)
) ENGINE=InnoDB CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' COMMENT='User contacts';
INSERT INTO contacts VALUES
(1, 'John Doe', 'jd@gm.com'),
(2, 'Mary Smith', 'ms@gm.com'),
(3, 'James Johnson', 'jj@gm.com'),
(4, 'Henry Case', 'hc@gm.com');