phpÊý¾Ý¿âµ¼³öÀà µ¼³öJSON,XML,WORD,EXCEL
from£ºhttp://www.xland.com.cn/article/7/81/0804/28778.htm
±¾ÀàʵÏÖ£º
Êý¾Ý¿âÐÅÏ¢µ¼³ö£ºword£¬excel£¬json£¬xml£¬sql
Êý¾Ý¿â»Ö¸´£º´Ósql£¬´ÓÎļþ
¾ßÌåÓ÷¨:
Ê×ÏÈн¨²âÊÔÓÃÊý¾Ý¿âmytest£¬È»ºóÔÚÀïÃæ½¨Õűí
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
--
-- ±íµÄ½á¹¹ `test`
--
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`email` varchar(200) NOT NULL,
`age` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- µ¼³ö±íÖеÄÊý¾Ý `test`
--
INSERT INTO `test` (`id`, `name`, `email`, `age`) VALUES
(1, 'pjq518', [email=]'pjq518@126.com'[/email], 22),
(2, 'xiaoyu', [email=]'xiaoyu@126.com'[/email], 21);
1.µ¼³öextÄÜ·½±ãµ÷ÓõÄjson
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
$db=new db();
echo $db->toExtJson('test');
//Êä³ö½á¹ûΪ
//{'totalCount':'2','rows':[{'id':'1','name':'pjq518','email':'pjq518@126.com','age':'22'},{'id':'2','name':'xiaoyu','email':'xiaoyu@126.com','age':'21'}]}
toExtJson( $table, $start="0", $limit="10", $cons="")ÓÐ4¸ö²ÎÊý£¬ $tableΪ±íÃû£¬ $consΪÌõ¼þ£¬¿ÉÒÔΪstring»òarray
2µ¼³öxml
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
$db=new db();
echo $db->toExtXml('test');
//Êä³ö½á¹û
3µ¼³öexcelºÍword
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
$db=new db();
//toExcel
$map=array('No','Name','Email','Age');//±íÍ·
$db->toExcel('test', $map,'µµ°¸');
//µ¼³öword±í¸ñ
// $db->toWord('test', $map,'µµ°¸');
//Ч¹ûÈçÏÂͼ
excel.JPG (27.04 KB)
2008-4-19 11:09
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
<?php
class Db
{
var $conn;
function Db( $host="localhost", $user="root", $pass="", $db="mytest")
{
if(! $this->conn=mysql_connect( $host, $user, $pass))
die("can't connect to mysql sever");
mysql_select_db( $db,&ensp
Ïà¹ØÎĵµ£º
±±¾©´óѧPHP¹¤³Ìʦ°àÕÐÉú¼òÕÂ
꿅᣼www.pku-it.com
½üÄêÀ´£¬PHPÓïÑÔÒÔÆä¼ò½àÁé»îµÄ±à³Ìģʽ¡¢ÈÕÇ÷ÍêÉÆµÄ¼¼ÊõÌåϵÒÔ¼°Ç¿ÓÐÁ¦µÄ¿ªÔ´Ö§³Ö£¬Ñ¸ËÙ·¢Õ¹³ÉΪȫÇò»¥ÁªÍøÓ¦ÓÃ×îΪ¹ã·ºµÄ±à³ÌÓïÑÔ¡£Ä¿Ç°ÒÑÓг¬¹ý40%µÄWEB³ÌÐòʹÓÃPHPÀ´±àд£¬°Ù¶È¡¢ÌÚÑ ......
ͨ³£ÎÒÃÇдһ¸öÀàÈçÏ£º
a.php
class A
{
public function __construct()
{
echo "hello world!";
}
}
page.php
require("a.php");
$a = new A();
ÎÒÃÇÊÇͨ¹ýÊÖ¹¤ÒýÓÃij¸öÀàµÄÎļþÀ´ÊµÏÖº¯Êý»òÕßÀàµÄ¼ÓÔØ
µ«Êǵ±ÏµÍ³±È½ÏÅÓ´ó£¬ÒÔ¼°ÕâЩÀàµÄÎļþºÜ¶àµÄʱºò£¬ÕâÖÖ·½Ê½¾ÍÏԵ÷dz ......
IsolatedStorageFile£º°üº¬ÎļþºÍÊý¾ÝµÄ¶ÀÁ¢´æ´¢Çø
datasetÊý¾Ý´æ´¢µ½±¾µØxmlÎĵµ£¬´úÂë´¦ÀíÈçÏÂ
public static void WriteDataToXML(DataSet dataset, string dataname)
{
try
{
IsolatedStorageFile isoStore = IsolatedStorageFile.GetUserStoreForAssembly(); / ......
Definition comparer class,
class ItemComparer : IEqualityComparer<XElement>
{
public bool Equals(XElement x, XElement y)
{
return x.Attribute("Name").Value == x.Attribute("Name").Value;
}
public int GetHashCode(XElement obj)
......
1.phpÊý×é»ù´¡£º
<?php
$ary2 = "zqhung_hongzequan_zqhong";
$arr3 =explode("_",$ary2);//²ð·Ö×Ö·û´®
echo $arr3[1];//´òÓ¡³öÀ´µÄ½á¹ûÊÇhongzequan
$ary1 = array("aa","bb");
$ary1[0]="zqhung";//ÐÞ¸ÄÊý×éÖеÄÖµ
echo $ary1[0],"<br>";//´òÓ¡³öÀ´µÄ½á¹ûÊÇzqhung
$ary3 = array("id"=>55);
......