本文实例讲述了 php 封装的连接 Mysql 类及用法分享给大家供大家参考, 具体如下:
- class mysql {
- private $db_name;
- private $db_host;
- private $db_user;
- private $db_pwd;
- private $conn;
- private $querysql;
- private $result;
- private $resultarray = array();
- private $row;
- // 创建构造函数 数据库名 主机名 用户名 密码
- function __counstruct($dbname, $dbhost, $dbuser, $dbpwd) {
- $this - >db_name = $dbname;
- $this - >db_host = $dbhost;
- $this - >db_pwd = $dbpwd;
- $this - >db_user = $dbuser;
- $this - >dbconnect();
- $this - >selectdb();
- }
- // 连接数据库
- private
- function db_connect() {
- $this - >conn = mysql_connect($this - >db_host, $this - >db_user, $this - >db_pwd) or die("Could not Connect MySql Server");
- }
- private
- function selectdb() {
- mysql_select_db($this - >db_name) or die("unable to select dbname")
- }
- private
- function query() {
- return $this - >result = mysql_query($this - >querysql);
- }
- private
- function get_result($sql) {
- $this - >querysql = $sql;
- $this - >query();
- if ($this - >get_num() > 0) {
- //mysql_fetch_assoc() 和 mysql_fetch_array(,MYSQL_ASSOC) 从结果集中取得一行作为关联数组 没有则返回 false
- while ($this - >rows = mysql_fetch_array($this - >result)) {
- // 赋值 数组赋值 resultarray[]= 将影响的行数赋值给数组
- $this - >resultarray[] = $this - >rows
- }
- return $this - >resultarray;
- }
- }
- //$result 返回值为 bool 类型 false 为没有数据
- private
- function get_num() {
- return $this - >num = mysql_num_rows($this - >result);
- }
- }
- $m = new mysql("testuser", "localhost", "root", "root");
- $arreresult = $m - >get_result("select * from userinfo");
希望本文所述对大家 php 程序设计有所帮助
来源: https://www.php1.cn/detail/php-1749cc9990.html