PHP封装返回Ajax字符串和JSON数组的方法

实例如下：

<?php
class DBDA
{
 public $host="localhost";
 public $uid = "root";
 public $pwd = "123";
 public $dbname = "mydb";
 
 //成员方法
 public function Query($sql,$type=1)
 {
 $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
 $r = $db->query($sql);
 
 if($type==1)
 {
 return $r->fetch_all();
 }
 else
 {
 return $r;
 }
 }
 
 //返回字符串的方法
 public function StrQuery($sql,$type=1)
 {
 $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
 $r = $db->query($sql);
 
 if($type==1)
 {
 $attr = $r->fetch_all();
 $str = "";
 foreach($attr as $v)
 {
 $str .= implode("^",$v)."|";
 }
 
 return substr($str,0,strlen($str)-1);

 }
 else
 {
 return $r;
 }
 }
 
 //返回JSON
 function JSONQuery($sql,$type=1)
 {
 $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
 $r = $db->query($sql);
 
 if($type==1)
 {
 return json_encode($r->fetch_all(MYSQLI_ASSOC));
 }
 else
 {
 return $r;
 }
 }
}

以上这篇PHP封装返回Ajax字符串和JSON数组的方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持脚本之家。