¹ØÓÚJQuery ²å¼þGridµÄѧϰʹÓÃ±Ê¼Ç (PHP°æ)
¹ØÓÚJQuery ²å¼þGridµÄѧϰʹÓÃ±Ê¼Ç (PHP°æ)
ÔÚ¿ª·¢WEBÓ¦ÓóÌÐòʱ£¬ÎÒÃǻᾳ£ºÍÊý¾Ý´ò½»µÀ£¬¶øÊý¾Ýͨ³£¶¼ÊÇͨ¹ý±í¸ñµÄÐÎʽÀ´½øÐÐÏÔʾ¡£¶øÔÚjQueryÖУ¬ÓÐÒ»¸öGrid²å¼þ£¬
ËüÔÚ´¦ÀíÊý¾Ýʱ¹¦ÄÜÒì³£µÄÇ¿´ó£¬Äܼ¸ºõÂú×ãÎÒÃǵÄËùÓÐÐèÇ󡣿ÉνÎ޵С£×ÁÄ¥ÁËGridºÃ¼¸Ì죬ÖÕÓÚÔÚÍøÉÏÕÒµ½ÁËÒ»¸ö·Ç³£°ôµÄѧϰʹÓÃ
µÄÀý×Ó¡£ÔÚÕâÀïhttp://www.trirand.net/demophp.aspxÓи÷ÖÖGridЧ¹ûµÄÑÝʾ£¬ÄãÖ»ÐèÔÚ¸ÃÕ¾µãµÄDownloadÏÂÔØjqGrid for PHP·ÅÔÚÄã×Ô¼ºµÄ±¾µØ»·¾³ÖоͿÉÒÔ×Ô¼ºËæÊ±·½±ãÑÝʾ¡£ËüµÄÀý×ӷdz£¶à£¬Ö±½ÓÌ×Óü´¿É¡£
ÔÚÓöµ½ÐèÒªGridЧ¹ûµÄʱºò£¬ÎÒÃÇͨ³£Ê×ÏȾö¶¨×Ô¼ºµÄÏîÄ¿ÐèÒªÒ»¸öʲôÑùЧ¹ûµÄGrid¡£
¸öÈ˶ÔGrid³£Óù¦ÄÜ´óÖÂ×ܽáÈçÏ£º
ÿÁÐÊý¾ÝµÄÅÅÐò¹¦ÄÜ
·ÖÒ³¹¦ÄÜ
ÁпíµÄÍÏ×§¸Ä±ä¹¦ÄÜ
Grid±êÌâÏÔʾ
ÁÐÓëÁÐÖ®¼äµÄÍÏ×§ÅÅÐò¹¦ÄÜ
µ¥»÷Ðб³¾°±äÉ«
»¬¹ýÐиßÁÁÏÔʾ
ÐкŵÄÏÔʾ
¶ÔÊý¾ÝµÄÌí¼Ó ±à¼ ɾ³ý ËÑË÷¹¦ÄÜ
¶ÔGridÊý¾Ýµ¼³öµ½excelÖй¦ÄÜ
¶ÔÁÐÊý¾ÝµÄSUM AVERAGE MAX MIN COUNT¹¦ÄÜ
¶àÐÐÑ¡Ôñ¹¦ÄÜ
GridÖеÄÊý¾ÝÀ´Ô´ÓÐÊý¾Ý¿âÖеıí xmlÎļþ Êý×é¡£
Ïà¹ØÎĵµ£º
°²×°»·¾³£ºVMware Workstation 5.5.0 build-18463
Linux°æ±¾£ºRed Hat Enterprise Linux AS (2.6.9-42.EL)
Èí¼þ°æ±¾£ºMySQL5 - mysql-5.0.37.tar.gz
¡¡¡¡¡¡¡¡¡¡Apache2 - httpd-2.2.4.tar.gz
¡¡¡¡¡¡¡¡¡¡PHP5 - php-5.2.1.tar.gz
¡¡¡¡¡¡¡¡¡¡(½«ÒÔÉÏÎļþ±£´æÖÁ/home/tmpĿ¼)
[MySQL]
# cd /home/tmp (½øÈëѹËõ°ü ......
±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......
Á¬½Óµ½Êý¾Ý¿âÖ®ºó£¬²»µ«¿ÉÒÔÔÚÊý¾Ý¿âÖд´½¨±í£¬Ò²¿ÉÒÔɾ³ýÒѾ´æÔÚµÄ±í¡£É¾³ý±íÒ²ÊÇͨ¹ýmssql_query()º¯ÊýÖ´ÐÐÏàÓ¦µÄɾ³ý±íSQLÓï¾äÀ´ÊµÏÖ¡£
<?php
$hostname="datahost";
$dbuser="sa";
$dbpasswd="123";
$dbname="tempdb";
$conn=mssql_connect($hostname,$dbuser,$dbpasswd);
mssql_select_db($dbname);
$t_na ......
Òªä¯ÀÀ±íÖеļǼÐèÒªÖ´ÐÐÒÔϼ¸²½²Ù×÷£º
(1) Ö´ÐÐÒÔÏÂSQLÓï¾ä£º
select field1,field2,field3,...from $table_name
ÆäÖÐfield1,field2,field3±íʾµÄÊÇÐèÒª´Ó±íÖвéѯµÄ×Ö¶ÎÃû³Æ£º$table_nameΪ±íµÄÃû³Æ¡£
(2)ʹÓÃPHP MSSQLÀà¿âÖеÄmssql_fetch_array()º¯Êý¶ÁȡִÐÐSQLÓï¾äËù·µ»ØµÄ½á¹û¼¯¡£¸Ãº¯ÊýµÄÓï·¨¸ñʽÈçÏ´úÂ룺 ......