数据访问类

数据访问类

访问类

<?php
class DBDA{
    public $host="localhost"; //服务器地址
    public $uid="root"; //用户名
    public $pwd="123"; //密码
    public $dbname="mydb"; //数据库名称
    
    /*
        执行一条SQL语句的方法
        @param sql 要执行的SQL语句
        @param type SQL语句的类型,0代表查询 1代表增删改
        @return 如果是查询语句返回二维数组,如果是增删改返回true或false
    */
    public function query($sql,$type=0){
        $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
        $result = $db->query($sql);
        if($type){
            return $result;
        }else{
            return $result->fetch_all();
        }
    }
}

 

示例

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>

<table width="100%" border="1" cellpadding="0" cellspacing="0">
    <tr>
        <td>民族代号</td>
        <td>民族名称</td>
    </tr>
    <?php
    require_once "./DBDA.class.php";
    $db = new DBDA();
    $sql = "select * from nation";
    $arr = $db->query($sql);
    foreach($arr as $v){
        echo "<tr>
        <td>{$v[0]}</td>
        <td>{$v[1]}</td>
    </tr>";
    }
    
    ?>
</table>

<div style="width:200px; height:20px;border:1px solid red">
    <div style=" background-color:#F00; float:left;height:20px; width:50%"></div>
</div>


</body>
</html>

 

posted @ 2018-02-22 09:05  桃花灬仙人  阅读(128)  评论(0编辑  收藏  举报