php json增减,PHP 处理 JSON

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);}//singletonstatic 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 datafunction 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//jsonif($format_=='json'){header('Content-type: application/json');echo $this->toJson($messages);}}//insert datafunction 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 datafunction 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;}?>