首先应确认PHP代码中使用的编码都是统一的。
<pre name="code" class="php"><?php
$conn=mysql_connect("localhost","root","") or die("数据库服务器连接错误".mysql_error());
mysql_select_db("db_database18",$conn) or die("数据库访问错误".mysql_error());
mysql_query("set names gb2312");
$title=$_POST[txt_title];
$content=$_POST[txt_content];
$createtime=date("Y-m-d H:i:s");
$sql=mysql_query("insert into `tb_affiche`(`title`,`content`,`createtime`)values('$title','$content','$createtime')");
echo "<script>alert('公告信息添加成功!');='add_affiche.php';</script>";
mysql_free_result($sql);
mysql_close($conn);
?>
上面展示的是与数据库连接PHP代码,使用gb2312编码。
下面展示的PHP代码中,网页使用gb2312编码。
<html>
<head>
<title>公告信息管理</title>
<meta http-equiv="Content-Type" content="text/html; <span style="color:#ff0000;">charset=gb2312</span>">
<link href="css/" rel="stylesheet">
</head>
<body>
<script language="javascript">
function check(form){
if(form.txt_title.value==""){
alert("请输入公告标题!");form.txt_title.focus();return false;
}
if(form.txt_content.value==""){
alert("请输入公告内容!");form.txt_content.focus();return false;
}
();
}
</script>
<table width="828" height="522" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td background="images/image_01.gif"> </td>
<td height="140" background="images/image_02.gif"> </td>
</tr>
<tr>
<td width="202" rowspan="3" valign="top"><table width="202" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="34" background="images/image_03.gif"> </td>
</tr>
<tr>
<td height="310" valign="top"><img src="images/image_09.gif" width="202" height="310" border="0" usemap="#Map"></td>
</tr>
</table></td>
<td height="34" background="images/image_04.gif"> </td>
</tr>
<tr>
<td height="38" background="images/image_06.gif"> </td>
</tr>
<tr>
<td height="270" valign="top">
<table width="626" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="257" align="center" valign="top" background="images/image_08.gif"><table width="600" height="257" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="22" align="center" valign="top" class="word_orange"><strong>添加公告信息</strong></td>
</tr>
<tr>
<td height="235" align="center" valign="top"><table width="500" height="226" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="226" align="center" valign="top">
<form name="form1" method="post" action="check_add_affiche.php">
<table width="520" height="212" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="87" align="center">公告主题:</td>
<td width="433" height="31"><input name="txt_title" type="text" size="40">
* </td>
</tr>
<tr>
<td height="124" align="center">公告内容:</td>
<td><textarea name="txt_content" cols="50" rows="8" ></textarea></td>
</tr>
<tr>
<td height="40" colspan="2" align="center"><input name="Submit" type="submit" class="btn_grey" value="保存" onClick="return check(form1);">
<input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
<tr>
<td bgcolor="#F0F0F0"></td>
<td height="43" background="images/image_12.gif"></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="30,45,112,63" href="add_affiche.php">
</map>
</body>
</html>
此种情况多出现于苹果系统下的PHP编程。此时应点击屏幕上方的【显示】,将【文本编码】设置为gb2312编码即可解决。如下图所示。
改正后该页面显示如下:
该页面另一PHP文件代码如下:主要实现PHP语言的页面访问数据库,记录并弹窗显示成功。可在后台数据库中求证数据确已录入。
<html>
<head>
<title>公告信息管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/" rel="stylesheet">
</head>
<body>
<table width="828" height="522" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td background="images/image_01.gif"> </td>
<td height="140" background="images/image_02.gif"> </td>
</tr>
<tr>
<td width="202" rowspan="3" valign="top"><table width="202" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="34" background="images/image_03.gif"> </td>
</tr>
<tr>
<td height="310" valign="top"><img src="images/image_09.gif" width="202" height="310" border="0" usemap="#Map"></td>
</tr>
</table></td>
<td height="34" background="images/image_04.gif"> </td>
</tr>
<tr>
<td height="38" background="images/image_06.gif"> </td>
</tr>
<tr>
<td height="270" valign="top">
<table width="626" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="257" align="center" valign="top" background="images/image_08.gif"><table width="600" height="257" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="22" align="center" valign="top" class="word_orange"> </td>
</tr>
<tr>
<td height="235" align="center" valign="top"> </td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
<tr>
<td bgcolor="#F0F0F0"></td>
<td height="43" background="images/image_12.gif"></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="30,45,112,63" href="add_affiche.php">
</map>
</body>
</html>