簡單實用MySQL資料庫PHP操作類

例子

代碼如下

複製代碼

<?php class SqlTool{ private $conn; private $host=”localhost”; private $user=”root”; private $password=”"; private $db=”bbs”; function sqlTool(){ $this->conn=mysql_connect(“$this->host”,”$this->user”,”$this->password”); mysql_select_db($this->db,$this->conn); mysql_query(“set names gbk”); } function executedql($sql){ $res=mysql_query($sql); return $res; } function executedml($sql){ $b=mysql_query($sql); if(!$b){ echo “操作失敗”; }else{ if(mysql_affected_rows($this->conn)>0){ echo “操作成功”; }else{ echo “沒有影響到行數”; } } mysql_close($this->conn); } } ?>