【php开源代码栏目提醒】:网学会员为广大网友收集整理了,guestbook.php,希望对大家有所帮助!
<?php
class GuestBook
{
private $userName="root";
private $userPwd="";
private $dbName="test";
private $serverName="localhost";
function __construct()
{
//连接数据库
$this->conn=mysql_connect($this->serverName,$this->userName,$this->userPwd);
//选择数据库
$this->my_db=mysql_select_db($this->dbName,$this->conn);
}
function test($name)
{
$result=mysql_query("select * from gbook where username='$name'");
$userinfo=
mysql_fetch_row($result);
return $userinfo;
}
function insertRecord($name,$msg)
{
my
sql_query("insert into gbook values (null,'$name','$msg')");
}
function getTotalLine()
{
$result=mysql_query("select count(*) from gbook");
$num=mysql_fetch_row($result);
return (int)$num[0];
}
}
?>