<?phpclass Mysql{     private static $host="localhost";     private static $user="root";     private static $password="123456";     private static $dbName="test";           //數(shù)據(jù)庫名     private static $charset="utf8";          //字符編碼     private static $port="3306";            //端口號(hào)     private $conn=null;     function __construct(){       $this->conn=new mysqli(self::$host,self::$user,self::$password,self::$dbName,self::$port);       if(!$this->conn)       {          die("數(shù)據(jù)庫連接失敗！".$this->conn->connect_error);       }else{         echo "連接成功！";       }       $this->conn->query("set names ".self::$charset);     }     //執(zhí)行sql語句     function sql($sql){       $res=$this->conn->query($sql);     if(!$res)       {          echo "數(shù)據(jù)操作失敗";       }       else       {          if($this->conn->affected_rows>0)          {             return $res;          }          else          {            echo "0行數(shù)據(jù)受影響！";          }       }     }     //返回受影響數(shù)據(jù)行數(shù)     function getResultNum($sql){      $res=$this->conn->query($sql);      return mysqli_num_rows($res);      }     //關(guān)閉數(shù)據(jù)庫     public function close()     {       @mysqli_close($this->conn);     }}?>

<?phprequire_once "mysql.php";$conn=new Mysql();$sql="select * from user";//執(zhí)行查詢并獲取查詢結(jié)果$result=$conn->sql($sql);//輸出受影響數(shù)據(jù)行數(shù)$num=$conn->getResultNum($sql);echo "影響的行數(shù)：".$num;//讀取并輸出記錄while ($row = mysqli_fetch_assoc($result)){  echo "{$row['name']} ";  echo "{$row['password']}";}//關(guān)閉數(shù)據(jù)庫$conn->close();