PHP»·¾³ IIS+PHP+MYSQL»·¾³µÄ¼ÜÉè
ºÜ¾ÃûÓÐЩһЩÓÐÓô¦µÄµÄ¶«Î÷ÁË£¡½ñÌì¾Í²»ºúÂÒµÄд¶«Î÷ÁË!дһЩÓÐÓõ졵±È»Ç°ÌáÏÂÊǺܸÐлºÜ¶à¾³£À´ÎÒ²©¿ÍµÄÅóÓÑһϣ¡¶àл´ó¼Ò£¡£¡£¡£¡£¡
½ñÌìдµÄÊǹØÓÚphp»·¾³¼ÜÉèµÄµÚÒ»ÖÖ·½Ê½£¡µ±È»ÎҾͲ»½ØÍ¼ÁË£¡´ó¼ÒÖ»Òª°´ÕÕ²Ù×÷¾Í¿ÉÒÔʵÏֵģ¡
Ò»¡¢°²×° PHP £º±¾ÎÄPHP°²×°Â·¾¶È¡ÎªD:\php\php4\(Ϊ±Ü»ìÏý£¬PHP5.1.x°æ±¾°²×°Â·¾¶È¡Îª
D:\php\php5\)
£¨1£©¡¢ÏÂÔØºóµÃµ½ php-4.4.0-Win32.zip £¬½âѹÖÁD:\phpĿ¼£¬½«µÃµ½¶þ¼¶Ä¿Â¼php-4.4.0-Win32£¬¸ÄÃû
Ϊ php4£¬
Ò²¼´µÃµ½PHPÎļþ´æ·ÅĿ¼D:\php\php4\
[Èç¹ûÊÇPHP5.1.2£¬µÃµ½µÄÎļþÊÇphp-5.1.2-Win32.zip£¬Ö±½ÓÈ«²¿½ÓѹÖÁD:\php\php5Ŀ¼¼´¿ÉµÃPHPÎÄ
¼þ´æ·ÅĿ¼D:\php\php5\]£»
£¨2£©¡¢ÔÙ½«D:\php\php4Ŀ¼ºÍD:\php\php4\dllsĿ¼
[PHP5ΪD:\php\php5\]ϵÄËùÓÐdllÎļþ copy µ½ c:\Windows\system32 (win2000ϵͳΪ
c:/winnt/system32/)Ï£¬¸²¸ÇÒÑÓеÄdllÎļþ£»
£¨3£©¡¢½«php.ini-distÓüÇʱ¾´ò¿ª£¬ÀûÓüÇʱ¾µÄ²éÕÒ¹¦ÄÜËÑË÷²¢Ð޸ģº
ËÑË÷ register_globals = Off
½« Off ¸Ä³É On £¬¼´µÃµ½ register_globals = On
×¢£ºÕâ¸ö¶ÔÓ¦PHPµÄÈ«¾Ö±äÁ¿¹¦ÄÜ£¬¿¼ÂÇÓкܶàPHP³ÌÐòÐèҪȫ¾Ö±äÁ¿¹¦Äܹʴò¿ª£¬´ò¿ªºóÇë×¢Òâ-PHP³ÌÐòµÄÑÏ
½÷ÐÔ£¬Èç¹û²»ÐèÒªÍÆ¼ö²»Ð޸ı£³ÖĬÈÏOff״̬
ËÑË÷ extension_dir =
Õâ¸öÊÇPHPÀ©Õ¹¹¦ÄÜĿ¼ ²¢½«Æä·¾¶Ö¸µ½ÄãµÄ PHP Ŀ¼Ï嵀 extensions Ŀ¼£¬±ÈÈ磺
ÐÞ¸Ä extension_dir = "./" Ϊ extension_dir = "D:/php/php4/extensions/"
[PHP5¶ÔÓ¦ÐÞ¸ÄΪ extension_dir = "D:/php/php5/ext/" ]
ÔÚD:\php Ͻ¨Á¢Îļþ¼Ð²¢ÃüÃûΪ tmp
²éÕÒ upload_tmp_dir =
½« ;upload_tmp_dir ¸ÃÐеÄ×¢ÊÍ·û£¬¼´Ç°ÃæµÄ·ÖºÅ" £»”È¥µô£¬
ʹ¸ÃÐÐÔÚphp.iniÎĵµÖÐÆð×÷Óá£upload_tmp_dirÊÇÓÃÀ´¶¨ÒåÉÏ´«Îļþ´æ·ÅµÄÁÙʱ·¾¶£¬ÔÚÕâÀïÄ㻹¿ÉÒÔÐ޸IJ¢
¸øÆä¶¨ÒåÒ»¸ö¾ø¶Ô·¾¶£¬ÕâÀïÉèÖõÄĿ¼±ØÐëÓжÁдȨÏÞ¡£
ÕâÀïÎÒÉèÖÃΪ upload_tmp_dir = D:/php/tmp (¼´Ç°Ã潨Á¢µÄÕâ¸öÎļþ¼ÐºÇ)
ËÑË÷ ; Windows Extensions
½«ÏÂÃæÒ»Ð©³£ÓõÄÏîÇ°ÃæµÄ ; È¥µô ,ºìÉ«µÄ±ØÐ룬À¶É«µÄ¹©Ñ¡Ôñ
;extension=php_mbstring.dll
Õâ¸ö±ØÐëÒª
;extension=php_curl.dll
;extension=php_dbase.dll
;extension=php_gd2.dll
Õâ¸öÊÇÓÃÀ´Ö§³ÖGD¿âµÄ£¬Ò»°ãÐèÒª£¬±ØÑ¡
;extension=php_ldap.dll
;extension=php_zip.dll
¶ÔÓÚPHP5µÄ°æ±¾»¹ÐèÒª²éÕÒ
;extension=php_mysql.dll
²¢Í¬ÑùÈ¥µôǰ
Ïà¹ØÎĵµ£º
MYSQL ɾ³ýͬһ±íÖÐÖØ¸´¼Ç¼
CREATE TABLE `user` (
`db_id` varchar(255) NOT NULL,
`name` varchar(45) default NULL,
`age` int(10) unsigned NOT NULL,
`address` varchar(45) default NULL,
PRIMARY KEY (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
&nb ......
CREATE TABLE `user` (
`db_id` varchar(255) NOT NULL,
`name` varchar(45) default NULL,
`age` int(10) unsigned NOT NULL,
`address` varchar(45) default NULL,
PRIMARY KEY (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
// ÉèÖÃname='888'µÄageµÈÓÚname='111' ......
ÔÚMySqlÖеÄÄ£ºý²éѯºÍÔÚMSSQLÖеIJ¶à£¬±¾¼Ç¼Ö÷ÒªÊÇ˵ÔÚJDBCÖÐʹÓÃPreparedStatementÀ´¹¹ÔìÒ»¸öÄ£ºý²éѯµÄÓï¾ä¡£
Ä£ºý²éѯSQLÓï¾ä£ºSELECT * from tableA WHERE colA LIKE '%ҪƥÅäµÄÄÚÈÝ%'
¹¹ÔìPreparedStatement£º
String sql = "SELECT * from tableA WHERE colA LIKE [-ÕâÀïÌîÊ²Ã´ÄØ£¿-]";
PreparedS ......
apacheµÄÔ´Âë°²×°
½«Ñ¹Ëõ°ü½âѹ֮ºó½øÈëÏàÓ¦µÄĿ¼
./configure \ #--------------------Ô¤±àÒëÃüÁî
"--prefix=/usr/local/apache" \ #--------------------°²×°Â·¾¶Îª“/usr/local/apache”
"--with-included-apr" \
"--enable-so" \ #--------------------¿ªÆôÏàÓ¦µÄÀ©Õ¹Ä£¿é ......
½üÀ´ÓÉÓÚ¹¤×÷µÄÐèÒª£¬¿ªÊ¼Ñ§Ï°Ê¹ÓÃPHP¡£
´Ó×òÌìÏÂÎçµ½½ñÌìÉÏÎ磬ÖÕÓÚ°Ñ¿ª·¢»·¾³´î½¨Íê±Ï¡£×ܵÄÀ´Ëµ£º³õ²½µÄÈÏʶÊÇ£ºPHPÔÚÍøÕ¾¿ª·¢ÉÏ£¬¹¦ÄÜ»¹ÊǺÜÇ¿´óµÄ¡£½ñÌìÏÂÎç³õ²½µÄ°ÑÓ﷨ʲôµÄÊìϤһÏ¡£ÒòΪ×ö¿ª·¢Õâô¶àÄêÁË£¬ºÜ¶àÓïÑÔ£¬»¹ÊÇÓеãÏàͬµÄ£¬ËùÒÔ£¬Ñ§Ï°ÆðÀ´²»ÊǺܷѾ¢¡£ºóÌì»ØÀϼң¬Ï£ÍûÄêºóÄÜÔÚPHPÉÏÓÐËùÌá¸ß¡£
Ò»¡¢± ......