Chinaunix

标题: mysql简单类 [打印本页]

作者: alsonluo 时间: 2007-10-15 15:45
标题: mysql简单类

刚刚学习类，写了一个简单的mysql类。试着调用这个类后，终于对类和oop有些新的认识。
db_mysql.php
Host = $HOST;
            $this->User = $USER;
            $this->Password = $PASS;
            $this->Database = $DATABASE;
      }
      function link_id() {
            return $this->Link_ID;
      }
      function query_id() {
            return $this->Query_ID;
      }
      function connect() {
            $this->Link_ID = mysql_connect($this->Host,$this->User,$this->Password);
            return $this->Link_ID;
      }
      function select_db() {
            if ($this->Link_ID) {
                     mysql_select_db($this->Database);
            }
      }
      function query($sql) {
            $this->sql = $sql;
            $this->Result = mysql_query($this->sql,$this->Link_ID);
            return $this->Result;
      }
      function insert($sql) {
            $this->sql = $sql;
            $this->Result = mysql_query($this->sql,$this->Link_ID);
            return $this->Result;
      }
      function update($sql) {
            $this->sql = $sql;
            $this->Result = mysql_query($this->sql,$this->Link_ID);
            return $this->Result;
      }
      function delete($sql) {
            $this->sql = $sql;
            $this->Result = mysql_query($this->sql,$this->Link_ID);
            return $this->Result;
      }
      function free() {
            if ($this->Query_ID) {
                     @mysql_free_result($this->Query_ID);
                     $this->Query_ID = 0;
            }
      }
      function Close(){
            if ($this->Link_ID) {
                     mysql_close($this->Link_ID);
            }
            else {
                     @mysql_close($this->Link_ID);
            }
      }
}
?>
调用类的例子：
connect();       //调用方法
if ($mysql->Link_ID) {
  echo "success";
}else{
  echo "fail";
}
?>

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/8552/showart_400975.html

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)