[Original]php database connection class_PHP tutorial-PHP Tutorial-php.cn

[Original]php database connection class_PHP tutorial

WBOY

Release： 2016-07-20 11:06:40

Original

912 people have browsed it

[原创]php数据库连接类

class Db{
  public $conn;
  public $root='localhost';
  public $user='root';
  public $pass='root';
  public $db='111cn.cn';
  public $charset='gb2312';
  public $links='c';

  function __construct() {
   $this->connect();
  }

  function connect()
  {
   try{
    if( 'p' == $this->links )
    {
     $this->conn = mysql_pconnect($this->root,$this->user,$this->pass) or die(mysql_error());
    }
    else
    {
     $this->conn = mysql_connect($this->root,$this->user,$this->pass) or die( mysql_error());
    }
    mysql_select_db($this->db,$this->conn);
    mysql_query("set Names '$this->charset'");
   }catch (Exception $e){
    echo '数据库连接失败，请联系相关人员!';
    exit;
   }
  }

  /*
   query
  */

  function query($sql)
  {
   $this->row = mysql_query( $sql,$this->conn ) or die( mysql_error());
   return $this->row;
  }
  /*
    mysql_num_rows total
  */
  function rows($row)
  {
   return mysql_num_rows( $row );
  }
  /*
   get data store array
  */
  function fetch($row,$tag=1)
  {
   if(1 == $tag )
   {
    return mysql_fetch_array( $row );
   }
   else
   {
    $array =array();
    while( $rs = mysql_fetch_array( $row ) )
    {
     $array[] = $rs;
    }
   }
   return $array;
  }

  /*
   取得刚插入的ID号
  */

  function insert_id()
  {
    return @mysql_insert_id($this->row);
  }

   //close current database link
   function close()
   {
   return @mysql_close($this->conn);
   }


    //test mysql version
   function version()
   {
   $query = @mysql_query("SELECT VERSION()",$this->conn);
   return @mysql_result($this->$row, 0);
   }
}
?>

调用方法。

/*
  读取新闻分类
*/

function newOption()
{
  $str='';
  $Db = new Db();
  $query = $Db->query("Select id,typetitle,typeupid,orderid from cn_111cn where typeupid=0 order by orderid asc");
  $row = $Db->fetch($query,0);
  foreach( $row as $_v => $value )
  {
   $str.="n";
  }
  $Db->close();
  return $str;
}

本站原创转戴载注明 www.111cn.cn