php返回json套数组_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数组的方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持聚米学院。