PHP封装返回Ajax字符串和JSON数组的方法
author:一佰互联 2019-04-26   click:176

实例如下:

<?phpclass 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数组的方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持网页设计。