windows»·¾³ÏµÄPHP+Apache+MySqlµÄ»·¾³´î½¨
²Ù×÷ϵͳ: windows xp
php°æ±¾:5.2.5 http://www.php.net/downloads.php
Apache http server °æ±¾:2.2.6http://httpd.apache.org/download.cgi
Mysql°æ±¾: 6.0.3http://dev.mysql.com/get/Downloads/MySQL-6.0
1.apacheµÄ°²×°:
1)Ë«»÷apache_2.2.6-win32-x86-no_ssl.msiͼ±ê£¬Æô¶¯apache°²×°³ÌÐò£»
2£©°²×°ÒÔÒ»¸ö»¶ÓÆÁÄ»¿ªÊ¼£¬µã»÷next£»
3£©Ðí¿ÉÐÒ飬×ÐϸÔĶÁºó£¬ÈçͬÒ⣬next£»
4£©Óëapache·þÎñÆ÷ÓйصÄ˵Ã÷£¬ÔĶÁºónext£»
5£©apache·þÎñÆ÷²Ù×÷Ïà¹ØÏ°üÀ¨ÍøÂçÓò¡¢·þÎñÆ÷ÃûºÍ¹ÜÀíÔ±E-mail¡£Ç°Á½ÏîʹÓÃlocalhost£¬×îºóÒ»ÏîÈÎÒ⣬ÒÔºó¿ÉÔÚ httpd.confÎļþÖÐÐÞ¸ÄÕâЩÐÅÏ¢¡£°²×°³ÌÐò»áÌáʾÄãÏ£ÍûΪËùÓÐÓû§Ìṩapache·þÎñ»¹Êǽö×÷Ϊµ±Ç°Óû§µÄ·þÎñ£¬Èç¹ûÄãÏ£ÍûapacheÓë²Ù×÷ ϵͳһÆðÆô¶¯£¨ÍƼö£©£¬¾ÍÑ¡Ôñ½«apache×÷ΪËùÓÐÓû§µÄ·þÎñ£¬Íê³Éºónext£»
6£©°²×°ÀàÐÍ£ºÕâÀïÑ¡Ôñ“µäÐÍ”£¬next
7£©Ñ¡Ôñ°²×°µÄλÖã¬ÎÒ°²×°ÔÚc:apache2
8£©µã»÷InstallÍê³É°²×°¡£
ÒòΪÎҵĻú×Ó80¶Ë¿ÚÒѾ±»Õ¼Óã¬ËùÒÔÔÚhttpd.confÐÞ¸ÄÁ˶˿ڡ£
Èç¹û°²×°µÄʱºò³öÏÖ´íÎ󣬲»Òª½ôÕÅ£¬È·¶¨¡£È»ºó´ò¿ªC:Apache2confϵÄhttpd.confÎļþ£¬²éÕÒ“80”£¬
#Listen 12.34.56.78:80
Listen 80
½«Listen 80 ¸ÄΪ Listen 81»òÕ߯äËû£¬ÕâÀï¸Ä³É81¡£ÈÎÎñÀ¸Àï³öÏÖÁ˸öͼ±ê£¬apacheÒѾ³É¹¦Æô¶¯¡£
2.php5µÄ°²×°:
1£©½âѹphpµÄzip°ü£¬ÕÒ¸öºÏÊʵÄλÖ÷Åһϣ¬½¨ÒéÓëapache·ÅÔÚͬһ¼¶Ä¿Â¼Ï¡£ÎÒÕâÀïÊÇC:\php5
2£©Ê¹apacheÄܹ»Ê¹ÓÃphp5ts.dllÎļþ£¬×î¼òµ¥µÄ·½·¨Êǽ«php5°²×°Â·¾¶Ôö¼Óµ½windowsµÄpath»·¾³±äÁ¿ÖС£ÓÒ»÷“ÎҵĵçÄÔ”——“ÊôÐÔ”——“¸ß¼¶”¡£ÈçͼËùʾ£º
Ñ¡Ôñ“»·¾³±äÁ¿”£¬Ñ¡ÖÐpath£¬µã»÷“±à¼”£¬ÔÚºóÃæ¼ÓÉÏ“;C:\php5”
3)´ò¿ªapache2conf,ÕÒµ½httpd.conf£¬²éÕÒ“LoadModule”,ÔÚ“LoadModule”¿éµÄ×îºó£¨¼´#LoadModule ssl_module modules/mod_ssl.soÒ»¾äºóÃæ£©¼ÓÉÏÏÂÃæÈýÐÐÄÚÈÝ£¨ÈçÉÏͼ£©£º
LoadModule php5_module c:/php5/php5apache2_2.dll
AddType application/x-httpd-php .php
4£©ÔÚphp5Îļþ¼ÐÖÐÕÒµ½php.ini-dist£¬ÖØÃüÃûΪphp.ini£¬±£´æÔÚphp5Îļþ¼Ð¡£
£¨Èç²»·ÅÔÚphp5Ŀ¼Ҳ¿É£¬µ«ÐèʹÓÃ--with-config-file-path½øÐÐÅäÖ㬲»ÍƼöʹÓÃÕâÖÖ·½·¨£©
5£©ÖØÆôapache·þÎñ£¬ÓÐʱÐèÒªÖØÆôµçÄÔ£»
°²×°ºóÎÒ×ö¸ö²âÊÔ£
Ïà¹ØÎĵµ£º
Ò») Á¬½ÓMYSQL£º
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëmysql°²×°Ä¿Â¼ÏµÄbinĿ¼Ï£¬ÀýÈ磺 D:\mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë
£¬Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµÄ£¬¹ÊÖ±½Ó»Ø³ ......
PHPÓëASP.NET±È½ÏµÄ¸÷¸ö·½ÃæÊÇÊ²Ã´ÄØ£¿PHPÓëASP.NET±È½ÏµÄ±ØÒªÐÔÊÇÊ²Ã´ÄØ£¿ÄÇô±¾Îľ͸øÄãÒ»¸ö´ð°¸¡£
PHPÓëASP.NET±È½ÏµÄǰÑÔ£¬²»¹ÜÄãÊDz»ÊÇÒѾѡÔñÁËPHP£¬¸ù¾ÝËüÔÚÈçϱí¸ñÖÐÔÚ¼Û¸ñ¡¢ËÙ¶È¡¢Ð§ÂÊ¡¢°²È«ÐÔ¡¢Æ½Ì¨Ö§³ÖÐԺͿªÔ´Óë·ñÉϵıíÏÖ£¬ÎÒÃǶ¼ÄÜÅжϳöËüµÄÇ¿ÏîÊÇԶʤÓÚÈõµãµÄ¡£Î¨Ò»²»×ãµÄÊÇȱÉÙÃæÏò¶ÔÏóµÄÖ§ ......
ʵÀýÒ»£ºÎ޲εĴ洢¹ý³Ì
$conn = mysql_connect('localhost','root','root') or die ("Êý¾ÝÁ¬½Ó´íÎó!!!");
mysql_select_db('test',$conn);
$sql = "
create procedure myproce()
begin
INSERT INTO user (id, username, sex) VALUES (NULL, 's', '0');
end;
";
mysql_query($sql);//´´½¨Ò»¸ömyproceµÄ´æ´¢¹ý³Ì
......
ÎÒµÄmysql×°ÔÚ/usr/local/mysqlĿ¼ÏÂÆô
¶¯Åöµ½¹ýºÜ¶àÎÊÌâ¡£×î³£¼ûµÄÊÇ£º
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
½â¾ö°ì·¨£º
[root@test mysql]# /usr/local/mysql/bin/mysqladmin -u root /
> -S /var/lib/mysql/mysql.sock password 'your.passwd'
......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ ......