$conn = @mysql_connect("localhost","root","");
if (!$conn){
die("连接数据库失败:" . mysql_error());
}
//可以不带连接句柄变量,若不带,为最新创建的数据库服务连接
$dbSelect=@mysql_select_db("myitem",$conn);
mysql_query("SET NAMES utf8",$conn);
//屏蔽宽字符集漏洞
mysql_query("SET character_set_client=binary",$conn);
$sql = "SELECT * FROM msg";
$result = mysql_query($sql); //得到查询结果数据集
//循环从数据集取出数据
while( $row = mysql_fetch_array($result) ){
echo "留言主题:".$row['title']."<br />";
echo "性别:".$row['sex']."<br />";
echo "联系电话:".$row['tel']."<br />";
echo "联系人:".$row['conect']."<br />";
echo "留言内容:".$row['content']."<br />";
// echo "注册日期:".date("Y-m-d", $row['regtime']);
}
mysql_close($conn);
if (!$conn){
die("连接数据库失败:" . mysql_error());
}
//可以不带连接句柄变量,若不带,为最新创建的数据库服务连接
$dbSelect=@mysql_select_db("myitem",$conn);
mysql_query("SET NAMES utf8",$conn);
//屏蔽宽字符集漏洞
mysql_query("SET character_set_client=binary",$conn);
$sql = "SELECT * FROM msg";
$result = mysql_query($sql); //得到查询结果数据集
//循环从数据集取出数据
while( $row = mysql_fetch_array($result) ){
echo "留言主题:".$row['title']."<br />";
echo "性别:".$row['sex']."<br />";
echo "联系电话:".$row['tel']."<br />";
echo "联系人:".$row['conect']."<br />";
echo "留言内容:".$row['content']."<br />";
// echo "注册日期:".date("Y-m-d", $row['regtime']);
}
mysql_close($conn);