PHP处理JSON实例代码

//BaseClassWithDB.php 抽象型别，主要是与数据库建立联机的基底类别和一些Method<?php  abstract html' target='_blank'>class BaseClassWithDB  {      protected $dbLink;      public function __construct()      {          $this->dbLink = mysql_connect('localhost', 'xuan', 'xuan')or die('fail to connect DB');        mysql_query("SET NAMES 'utf8'");          mysql_select_db('touchide_xuan',$this->dbLink)or die('fail to select DB');      }            public function __destruct()      {          mysql_close($this->dbLink);      }          protected function toJson($code)    {        $code = json_encode($code);        return $code;    }                protected function toJsonWithKey($key, $code)    {        $code = json_encode(array($key=>$this->urlencodeAry($code)));        return urldecode($code);    }     protected function urlencodeAry($data)    {        if(is_array($data))        {            foreach($data as $key=>$val)            {                $data[$key] = $this->urlencodeAry($val);            }            return $data;        }        else        {            return urlencode($data);        }    }    /*         用途：取得日期的年月        参数：无        回传型别：201206    */     public static function getDateYM()     {        $date = date("Ym");        return $date;      }    /*         用途：取得日期        参数：无        回传型别：20120601    */     public static function getDate()     {        $date = date("Ymd");        return $date;      }    /*         用途：取得日期        参数：无        回传型别：2012/06/01    */     public static function getDateWithSlash()     {        $date = date("Y/m/d");        return $date;      }    /*         用途：取得日期        参数：无 www.it165.net        回传型别：2012/06/01    */     public static function getDateTime()     {        $date = date("YmdHis");        return $date;      }     public static function getDateTimeWithSlash()     {        $date = date("Y/m/d H:i:s");        return $date;      }          public static function base64ToImage($base64String=NULL, $filePath=NULL)     {        $img = imagecreatefromstring(base64_decode($base64String));        if($img != false)        {            imagepng($img, $filePath);        }     }          public static function createFolder($folderPath=NULL)     {         if(!file_exists($folderPath))         {             if(!file_exists(dirname($folderPath)))             {                 mkdir($folderPath, 0700);             }                      }     }  } ?>//wsLine.php 主要用来   接受/产生JSON，继承自BaseClassWithDB<?php  include("BaseClassWithDB.php");  class Message extends BaseClassWithDB  {      static private $instance = NULL;    private $dirId = NULL;    private $fullDirPath = NULL;          public function __construct($dirId = NULL)      {          parent::__construct();        $this->dirId = $dirId;        $this->fullDirPath = 'Line_Pics/'.$dirId.'/';        //建立数据夹        //parent::createFolder($this->fullDirPath);      }      //singleton      static public function getInstance($dirId = NULL)      {                  if(self::$instance == NULL)          {              self::$instance = new Message($dirId);          }          return self::$instance;      }            function __get($property)      {          echo "get property values";      }            function __set($property, $value)      {          echo "set property values ";      }      //query data      function getMessages($format_='json', $term = NULL)      {        //query           $query = "select * from Line_MSG where 1 = 1 ";        if($term!=NULL)          $query = $query + $term;                              $result = mysql_query($query,$this->dbLink)or die('fail to query data!');        $messages = array();          if(mysql_num_rows($result))          {              while($message = mysql_fetch_assoc($result))              {                     $messages[] = $message;              }            //var_dump($messages);          }          //output          //json        if($format_=='json')        {            header('Content-type: application/json');            echo $this->toJson($messages);        }      }       //insert data      function insertMessage()      {        //        $message__ = file_get_contents('php://input');        //MainArray = [{"id":"a0001", "name":"王小明"},{"id":"a0002", "name":"李小华"}]        $MainArray = json_decode($message__, true);        if (is_array($MainArray))        {            foreach ($MainArray as $KVArray){                $dir = NULL;                $insFields = NULL;                $insValues = NULL;                foreach ($KVArray as $key => $value){                    if (strcasecmp($key,'msg_date')==0){                        $value = parent::getDateTimeWithSlash();                        //$imageName = $value;                    }                    if (strcasecmp($key,'id')==0){                        $dir = $value;                    }                                                                if (strcasecmp($key,'misc')==0){                        $imageName = parent::getDateTime();                        parent::base64ToImage($value, $this->fullDirPath . $imageName . '.png');                    }                         $insFields .= sprintf("%s,", $key);                    $insValues .= "'" . $value ."',";                 }                $digi = strlen($insFields)-1;                $insFields = substr($insFields, 0, $digi);                                $digi = strlen($insValues)-1;                $insValues = substr($insValues, 0, $digi);                                $insert = "insert into Line_MSG(". $insFields .")" .                        "values(". $insValues .")";                if(!mysql_query($insert, $this->dbLink))                {                    echo 'insert fail '. $insert ;                } else echo 'insert success ';                sleep(1);                        }        }      }      //delete data      function deleteMessage()      {          $message__ = file_get_contents('php://input');        $obj = json_decode($message__);        $id = $obj->{'id'};        $msg_date = $obj->{'msg_date'};                        $delete = "delete from Line_MSG where id='". $id ."' and msg_date='". $msg_date ."'";        if(!mysql_query($delete, $this->dbLink))            echo 'delete fail';        else echo 'delete success';      }  }   $format = isset($_GET['format'])?strtolower($_GET['format']):'json';  $action = isset($_GET['action'])?($_GET['action']):NULL;  $dirId = isset($_GET['dirId'])?($_GET['dirId']):NULL;  $message_ = Message::getInstance($dirId);    if($dirId!=NULL)  {      $folderPath = 'Line_Pics/'.$dirId.'/';    if(!file_exists($folderPath))    {        if(!file_exists($folderPath))        {            mkdir($folderPath,0700);        }                 }  }  switch($action)  {      case 'insert':        $message_->insertMessage();         break;       case 'delete':        $message_->deleteMessage();         break;                     default:        $message_->getMessages($format);        break;  }?>

郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。