require_once 'Zend/Db.php';
require_once 'Zend/Db/Table.php';
$params = array ('host' => 'localhost',
'username' => 'root',
'password' => 'yourpassword',
'dbname' => 'yourdbname');
$db = Zend_Db::factory('PDO_MYSQL', $params);
$db->query('set names utf8');
Zend_Db_Table::setDefaultAdapter($db);
class ContentTable extends Zend_Db_Table {
protected $_name = 'jos_content';
}
$table = new ContentTable();
$rowset = $table->fetchAll(null, 'id ASC', 10, 0);
$title = '';
foreach ($rowset as $row) {
$title.=$row->title;
}
注意这一行:$db->query('set names utf8');
因为数据库的默认字符集是是utf8 ,所以这一行是必须的,否则你读出来的中文就成了乱码了。