IIS+PHP+MYSQLÅäÖù¦ÂÔ
PHPµÄÖ´ÐÐЧÂÊÊÇÓÐÄ¿¹²¶ÃµÄ£¬ÕâÒ²ÊÇÎÒϲ»¶ËüµÄÔÒòÖ®Ò»£¬ºÍËü³ÆÎª¾øÃî´îµµµÄMysqlÒÔ¼°ApacheÏëÈںϣ¬²»Äܲ»¾ªÌ¾ÆäЧÂÊÁË¡£PHP¸üÐÂÒ²ºÜ¿ì£¬ÕâÀïÁоÙÁËĿǰ×îа汾PHP4.3.2RC4£¨¼¸ºõûÓÐBUGÁË£¬¹À¼ÆÐ´ÍêÕâÆª²»¾ÃºóÕýʽ°æ¾Í³öÁË£©£¬ºÍ×îа汾µÄMysql4.0.13µÄ°²×°¹ý³Ì¡£
¡¡¡¡PHPµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.php.net/ ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü£¨5.8M£©
¡¡¡¡MysqlµÄ°²×°Îļþ¿ÉÒÔÖ±½Óµ½ http://www.mysql.com ÏÂÔØ£¬»ñµÃfor win32µÄ.zip°ü
¡¡¡¡ÁíÍâÈç¹ûÏëÌåÑéApacheºÍPHPµÄÅäºÏЧ¹û¶øÒª·ÅÆúIISµÄ»°£¬Çëµ½ http://www.apache.org ÏÂÔØ×îеÄfor win31µÄ.MSI°²×°°ü£¬Ä¿Ç°×îа汾ÊÇ2.0.45¡£
¡¡¡¡ÁíÍ⣬¿ÉÒÔÏÂÔØZend OptimizerÀ´¶ÔPHP½øÐмÓËÙ¡£¾ßÌå¿ÉÒÔ·ÃÎÊ http://www.zend.com
http://www.netbei.com/Article/zz7/s1/200409/2593.html
<1>°²×°ÅäÖÃPHP
¡¡¡¡1.½âѹËõPHPѹËõ°üµ½C:\PHP£¨Õâ¸ö·¾¶¿ÉÒÔËæÒ⣬²»¹ýÒÔÏÂÒªÊÇÓõ½Õâ¸ö·¾¶£¬ÇëÏàÓ¦µÄÐ޸ģ©¡£
¡¡¡¡2.¸´ÖÆC:\PHPĿ¼ÏµÄphp4ts.dll¼°C:\PHP\dllsĿ¼ÏµÄËùÓÐÎļþµ½windowsµÄϵͳÎļþ¼ÐÀÎļþ¼ÐÊÓWindows°æ±¾µÄ²»Í¬¶ø²»Í¬
¡¡¡¡Èç¹ûÊÇWindows 9x/ME ÔòΪc:\windows\system
¡¡¡¡Èç¹ûÊÇWindows NT/2000 ÔòΪc:\winnt\system32
¡¡¡¡Èç¹ûÊÇWindows XP/server2003 ÔòΪc:\windows\system32
ÆäÖÐC:\ΪÄãÏÖÔÚËùʹÓõIJÙ×÷ϵͳµÄϵͳÅÌ£¬Èç¹ûÄãĿǰ²Ù×÷ϵͳ²»Êǰ²×°ÔÚC:\windowsÏ£¬ÇëÏàÓ¦×ö³öÐ޸ġ£
¡¡¡¡¸´ÖÆphp.ini-distµ½C:\windows\(XP/2003/9x/Me)»òC:\Winnt\(2000/nt)Ï£¬²¢½«Æä¸ÄÃûΪphp.ini¡£ÓüÇʱ¾´ò¿ª£¬ÐÞ¸ÄÒ»ÏÂÐÅÏ¢£º
¡¡¡¡ËÑË÷extension_dir = ./ ÕâÐУ¬²¢½«Æä·¾¶Ö¸µ½ÄãµÄPHPĿ¼ÏµÄextensionsĿ¼£¬±ÈÈ磺
¡¡¡¡extension_dir = C:\PHP\extensions
¡¡¡¡ÈçÈôÏëÖ§³Ö¸ü¶àÄ£¿é£¬Çë½ÓÏÂÃæÈ¥×ö£¬Èç¹û²»ÏëµÄ»°£¬Ö±½Ó±£´æphp.iniÎļþ¼´¿É.
¡¡¡¡PHPËùÖ§³ÖÄ£¿éºÜ¶à£¬²»¹ýÓÐЩdll²»ÊÇÃâ·ÑµÄ£¬Ë
Ïà¹ØÎĵµ£º
ÔÚMySqlÖеÄÄ£ºý²éѯºÍÔÚMSSQLÖеIJ¶à£¬±¾¼Ç¼Ö÷ÒªÊÇ˵ÔÚJDBCÖÐʹÓÃPreparedStatementÀ´¹¹ÔìÒ»¸öÄ£ºý²éѯµÄÓï¾ä¡£
Ä£ºý²éѯSQLÓï¾ä£ºSELECT * from tableA WHERE colA LIKE '%ҪƥÅäµÄÄÚÈÝ%'
¹¹ÔìPreparedStatement£º
String sql = "SELECT * from tableA WHERE colA LIKE [-ÕâÀïÌîÊ²Ã´ÄØ£¿-]";
PreparedS ......
½ñÌìΪÁËһЩÒÑÓÐÊý¾Ýµ¼ÈëMYSQLµÄÊý¾Ý¿â£¬ÎÒдÁËÒ»¸öºÜ¼òµ¥µÄPHP³ÌÐò¡£
³ÌÐò˼·ºÜ¼òµ¥£¬¾ÍÊǶÁÒ»ÌõÊý¾Ý£¬È»ºóÍùMYSQLÀï²åÈëÒ»Ìõ¡£
½á¹û×ÜÊÇ·¢ÏÖ Ã¿´Îµ¼ÈëÖ»Äܵ¼Èë2000Ìõ£¬¾Í×Ô¶¯Í£Ö¹ÁË£¬¶øÇÒûÓÐÈκÎÌáʾ¡£
ÔÚÍøÉÏËѽâ¾ö·½°¸¸÷ÖÖËѲ»µ½¡£
¸Õ¿ªÊ¼»³ÒÉÊÇÄڴ滺³å¸øÉÙÁË£¬µ÷ÁËһϣ¬»¹ÊDz»ÐС£¡£
×îºó·¢ÏÖÒ»¸ö¹æÂÉ£¬¾ÍÊÇ ......
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>PHP·ÖÒ³</tit ......
< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......