ʵÀýÏê½âPHP serializeÓëJSON½âÎö
JSON
»ù
ÓÚJavaScript Programming Language, Standard ECMA-262 3rd Edition -
December 1999µÄÒ»¸ö×Ó¼¯¡£JSON²ÉÓÃÍêÈ«¶ÀÁ¢ÓÚÓïÑÔµÄÎı¾¸ñʽ£¬µ«ÊÇҲʹÓÃÁËÀàËÆÓÚCÓïÑÔ¼Ò×åµÄϰ¹ß£¨°üÀ¨C, C++, C#, Java
, JavaScript, Perl, PythonµÈ£©¡£ÕâÐ©ÌØÐÔʹJSON³ÉΪÀíÏëµÄÊý¾Ý½»»»ÓïÑÔ¡£
JSON½¨¹¹ÓÚÁ½Öֽṹ£º
“Ãû
³Æ/Öµ”¶ÔµÄ¼¯ºÏ£¨A collection of name/value
pairs£©¡£²»Í¬µÄÓïÑÔÖУ¬Ëü±»Àí½âΪ¶ÔÏó£¨object£©£¬¼Í¼£¨record£©£¬½á¹¹£¨struct£©£¬×ֵ䣨dictionary£©£¬¹þÏ£±í
£¨hash table£©£¬ÓмüÁÐ±í£¨keyed list£©£¬»òÕß¹ØÁªÊý×é £¨associative array£©¡£
ÖµµÄÓÐÐòÁÐ±í£¨An ordered list of values£©¡£Ôڴ󲿷ÖÓïÑÔÖУ¬Ëü±»Àí½âΪÊý×飨array£©¡£
PHP
µÄserialize
Êǽ«±äÁ¿ÐòÁл¯£¬·µ»ØÒ»¸ö¾ßÓбäÁ¿ÀàÐͺͽṹµÄ×Ö·û´®±í´ïʽ£¬
˵ÆðÀ´Á½Õß¶¼ÊÇÒÔÒ»ÖÖ×Ö·û´®µÄ·½Ê½À´ÌåÏÖÒ»ÖÖÊý¾Ý½á¹¹£¬ÄÇËüÃÇÖ®¼äÓÐÊ²Ã´Çø±ðÄØ¡£
ÏÈ´ÓJSON˵Æð£¬¿´Ò»¸ö¼òµ¥µÄʵÀý
¡£
ÀýÒ»:
var
test = {
"Name"
:
"Peter"
,
"Age"
:20};
document.write(test.Name +
": "
+ test.Age);
ÏÔʾ½á¹û:
Peter: 20
±äÁ¿testÖÐ{"Name":"Peter","Age":20}Ϊһ¸öÓÐ2¸öÔªËØµÄ¶ÔÏ󣨸оõ¾ÍÏñPHPµÄÊý×飩£º
NameΪPeter£¬AgeΪ20¡£
µ±È»Ò²¿ÉÒÔ±äµÃ¸´ÔÓЩ¡£
Àý¶þ:
var
test
= {"User":{"Name":"Peter","Age":20},"Company":"FORD"};
document.write(test.User.Name + ": " + test.Company);
ÏÔʾ½á¹û:
Peter: FORDÕâ¸öÀý×ÓÖÐUserÔªËØÖаüº¬ÁËNameºÍAge¡£
Èç¹ûÒªÌåÏÖ¶à¸öUser£¬ÔòÐèҪʹÓÃÊý×é£¬Çø±ðÓÚ¶ÔÏóµÄ"{}"£¬Êý×éʹÓÃ"[]"¡£
JSON½âÎöÀýÈý:
var
test
= [
{"User":{"Name":"Peter","Age":20},"Company":"FORD"},
{"User"
Ïà¹ØÎĵµ£º
ÕâÊǸöÔÚ±ðÈ˵Ļù´¡ÉÏ×öÐ޸ĵĴúÂ룬Ìí¼ÓÁË Åжϵ¥Ôª¸ñÖµÊÇ·ñΪÊýÖµ£¬Êǵϰ£¬½«¸Ãµ¥Ôª¸ñµÄÀàÐÍת³É Number£¬±ÜÃâÉú²úµÄEXCELÖÐû·¨½øÐÐÊýÖµµÄ¼Ó¼õ¡£¡£¡£
<?php
/**
* Simple excel generating from PHP5
*
* This is one of my utility-classes.
*
* The MIT License
*
* Copyright (c) 2007 Oliver Sc ......
TIOBEÊÀ½ç±à³ÌÓïÑÔÅÅÐаñÕ¹ÏÖÁ˱à³ÌÓïÑÔµÄÁ÷ÐÐÇ÷ÊÆ¡£Ã¿¸öÔ£¬¶¼ÓÐ×îеÄÊý¾Ý±»¸üС£Õâ·ÝÅÅÐаñµÄÊý¾ÝÈ¡ÑùÀ´Ô´ÓÚ»¥ÁªÍøÉϸ»ÓоÑéµÄ³ÌÐòÔ±¡¢ÉÌ ÒµÓ¦Óá¢ÖøÃûµÄËÑË÷ÒýÇæ£¨ÖîÈç¹È¸è¡¢ MSN ¡¢ÑÅ»¢£©µÄ¹Ø¼ü×ÖÅÅÃû¡¢ Alexa ÉϵÄÅÅÃûµÈ¡£Çë×¢ÒâÕâ¸öÅÅÐаñÖ»ÊÇ·´Ó³ÁËij¸ö±à³ÌÓïÑÔµÄÈÈÃÅ³Ì¶È , Õâ²¢²»´ú±íËüÊÇÒ»¸ö×îºÃµÄ±à³ÌÓïÑÔ» ......
×î½üÔÚ×öÒ»¸öÏîÄ¿£¬Óöµ½AJAXÖÐÎÄÂÒÂëÎÊÌ⣬¾¹ýÒ»¸öÏÂÎçµÄŬÁ¦ÖÕÓÚÍêÃÀ½â¾ö£¬ÏÖ½«ÐĵÃдÏÂÀ´£¬Ï£Íû¶ÔÄÇЩ»¹À§ÈÆÔÚÕâ¸öÎÊÌâ¶øÍ·Í´²»ÒѵÄÈËÃÇÓÐËù°ïÖú¡£
ÖÚËùÖÜÖª£¬Ê¹ÓÃAJAX´«ËͺͽÓÊÕÖÐÎIJÎÊýʱ£¬Èç¹û²»ÔÚ¿Í»§¶ËºÍ·þÎñÆ÷×öÏàÓ¦µÄ´¦Àí¾Í»á³öÏÖÂÒÂëÎÊÌ⣬ÔÚÍøÉÏÏàÓ¦µÄÎÄÕÂÒ²²»ÉÙ£¬µ«ÊÇÓеÄÇé¿öϺÜÄÑ´ÓÖÐÕÒµ½·ûºÏ×Ô¼ºÀíÏëµÄ´ð ......
ÓÅÐãµÄPHP´úÂëÓ¦¸ÃÊǽṹ»¯µÄ¡£´ó¶ÎµÄ´úÂëÓ¦¸Ã±»·Ö¸îÕûÀí³ÉÒ»¸ö¸öº¯Êý»ò·½·¨£¬¶øÄÇЩ²»ÆðÑÛµÄС¶Î´úÂëÔòÓ¦¸Ã¼ÓÉÏ×¢ÊÍ£¬ÒÔ±ãÈÕºóÇå³þËüÃǵÄÓÃ;¡£
¶øÇÒÓ¦¸Ã¾¡¿ÉÄܵذÑǰ̨´úÂëÈçHTML¡¢CSS¡¢JavascriptµÈ´Ó³ÌÐòÖзÖÀë³öÀ´¡£PHPµÄÃæÏò¶ÔÏó±à³ÌÌØÐÔ¿ÉÒԺܺõذïÖú³ÌÐòÔ±½«´úÂëÕûÀíÓÐ
Ðò¡£
&n ......
phpÁ¬½Óaccess
$conn=new COM("ADODB.Connection");
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("data.mdb").";Uid=Admin; Pwd=BDC2002Data;";
$conn->open($dsn);
$sql="select * from dict";
$rs=$conn->Execute($sql);
$row="0";
while(!$rs->EO ......