当前位置：首页 → 问答吧 → mysqli写的一个数据库访问类

mysqli写的一个数据库访问类

时间：2007-03-17

来源：互联网

采用mysqli函数,utf8编码

写的比较简单,希望大家帮我看下,哪里写的不好,我好做做修改,..谢谢了

复制PHP内容到剪贴板

PHP代码:

<?php
class db
{
public $db_host;
public $db_user;
public $db_pass;
public $db_data;
public $cn;
public $result;
function __construct($db_host,$db_user,$db_pass,$db_data)
{
  $this->db_host=$db_host;
  $this->db_user=$db_user;
  $this->db_pass=$db_pass;
  $this->db_data=$db_data;
  $cn=mysqli_connect($this->db_host,$this->db_user,$this->db_pass) or die("err!mysql");
  mysqli_select_db($cn,$this->db_data) or die("err!database");
  //echo mysqli_error();
  $this->cn=$cn;
  mysqli_query($this->cn,'set names utf8') ;

}

function sql($sql)
{
  $this->result=mysqli_query($this->cn,$sql);
  return $this->result;
}

function select($result)
{
  $arr=mysqli_fetch_array($result);
  return $arr;
  //mysql_close($this->cn);
}

function query($sql)
{
  return $this->sql($sql);
}

function num($sql)
{
  return mysqli_num_rows($this->sql($sql));
}

}
echo '<html>'."\r\n";
echo '<head>'."\r\n";
echo '<title>test</title>'."\r\n";
echo '<meta http-equiv="Content-Type" c >'."\r\n";
echo '</head>'."\r\n";
echo '<body>'."\r\n";
$db=new db('localhost','root','root','ye55');
$result=$db->sql("select * from test");
while($arr=$db->select($result)){
echo "<li>$arr[name]------$time</li> \r\n" ;
}

//$dates=time();
echo "<br>".$dates;

$num=$db->num("select * from test");
echo ($num);
echo '</body>'."\n";
echo '</html>'
?>

作者: dmkf 发布时间: 2007-03-16

学习！

作者: Nickboy 发布时间: 2007-03-17

没什么功能啊

作者: sanler 发布时间: 2007-05-28