php+MySQL留言板-增删改查

<?php class Connection { private $mysql_server_host="localhost"; //数据库服务名称 private $mysql_server_username="root"; //连接数据库的用户名 private $mysql_server_password="ppcx0855"; //用户名的密码 private $mysql_database="mydb"; //数据库的名称 private $CONN;//数据库连接 // Connection类的构造函数 function Connection() { // 连接数据库 $conn = mysql_connect($this -> mysql_server_host, $this->mysql_server_username, $this->mysql_server_password); //选择数据库 mysql_select_db($this->mysql_database); $this -> CONN = $conn; } //添加操作 function insert($username,$title,$content) { if ( empty($this -> CONN) ) return false; date_Default_TimeZone_set("PRC"); $curTime = date('Y-n-d H:i:s'); $sql = "insert into messagebook (title,content,username,time) VALUES ('$title','$content','$username','$curTime')"; $result = mysql_query($sql,$this -> CONN); $result = mysql_insert_id(); return $result; } // 定义查询操作 function select($id=0) { if ( empty($this -> CONN) ) return false; $conn = $this -> CONN; if($id<=0) { $sql="select * from messagebook"; }else { $sql="select * from messagebook where id=$id"; } // 发送sql语句，获得结果 $result = mysql_query($sql, $conn); if ( (!$result) or (empty($result)) ) { return false; } $num = 0; $data = array(); // 将查询结果放二维数组中 while ( $row = mysql_fetch_array($result) ) { $data[$num] = $row; $num++; } return $data; } //修改操作 function update($eid,$username,$title,$content) { if ( empty($this -> CONN) ) return false; $sql = "update messagebook set username='$username',title='$title',content='$content' where id=".$eid; $result = mysql_query($sql,$this ->CONN); return $result; } // 删除操作 function delete($did) { $sql ="delete from messagebook where id = $did"; $result = mysql_query($sql, $this -> CONN); return $result; } } ?>