数据库编码是GBK,页面中要怎么写才不至于出现乱码呢?
用discuz!的cdb_pms表测试
<?php
$hostname='localhost';
$username='root';
$password='123456';
$dbname='rate';
$table_name='cdb_pms';$id_link=@mysql_connect($hostname,$username,$password);
if (!$id_link)
{
echo '连接失败,用户名或密码有误';
}
$str_sql="SELECT * FROM $table_name";
$result=@mysql_db_query($dbname,$str_sql,$id_link);
if(!$result)
{
echo 'SQL查询语句执行失败';
exit();
}
$number_of_rows=@mysql_num_rows($result);
echo "<p>当前记录数:$number_of_rows</p>";
?>
<table border="1" cellpadding="3" cellspacing="0">
<?php
require('7hdr.inc.php');
for ($iindex=0;$iindex<$number_of_rows;$iindex++)
{
$record=@mysql_fetch_object($result);
require('7rec.inc.php');
}
?>
</table>那两个文件没什么内容的,一个是表格标题,另一个如下:
<tr>
<td>
<?php echo $record->msgfrom ?>
</td>
<td>
<?php echo $record->subject ?>
</td>
</tr>
请问该如何修改呢?
用discuz!的cdb_pms表测试
<?php
$hostname='localhost';
$username='root';
$password='123456';
$dbname='rate';
$table_name='cdb_pms';$id_link=@mysql_connect($hostname,$username,$password);
if (!$id_link)
{
echo '连接失败,用户名或密码有误';
}
$str_sql="SELECT * FROM $table_name";
$result=@mysql_db_query($dbname,$str_sql,$id_link);
if(!$result)
{
echo 'SQL查询语句执行失败';
exit();
}
$number_of_rows=@mysql_num_rows($result);
echo "<p>当前记录数:$number_of_rows</p>";
?>
<table border="1" cellpadding="3" cellspacing="0">
<?php
require('7hdr.inc.php');
for ($iindex=0;$iindex<$number_of_rows;$iindex++)
{
$record=@mysql_fetch_object($result);
require('7rec.inc.php');
}
?>
</table>那两个文件没什么内容的,一个是表格标题,另一个如下:
<tr>
<td>
<?php echo $record->msgfrom ?>
</td>
<td>
<?php echo $record->subject ?>
</td>
</tr>
请问该如何修改呢?
既然楼主有了discuz!的数据库,可以参考下dz的代码O(∩_∩)O~
<meta HTTP-EQUIV="Content-Type" Content="text-html; charset=gbk">连接数据库时用GBK怎么写呢?我刚开始学php,DZ的代码博大精深,不过我现在就能看懂的,某个功能的代码在哪里都不知道.
大侠多多指点.
mysql_query("SET NAMES GBK");