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·þÎñ£¬ÓÐʱÐèÒªÖØÆôµçÄÔ£»
°²×°ºóÎÒ×ö¸ö²âÊÔ£
Ïà¹ØÎĵµ£º
ʵÀýÒ»£ºÎ޲εĴ洢¹ý³Ì
$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µÄ´æ´¢¹ý³Ì
......
¡¡¡¡ÓÃC++²Ù×÷MySQLÊý¾Ý¿âÀࣺ
¡¡¡¡×¢ÊÍ£ºÕ⼸¸öÀà¶Ô´¦Àí²»ÊǺܴóÊý¾ÝÁ¿µÄ²Ù×÷ÊǺÜÀíÏëµÄ£¬ µ«²»ÊÊÒËÌØ´óÐ͵ÄÊý¾ÝµÄ²éѯ£¬ÒòΪԴÂëÖн«²éѯµ½µÄÊý¾ÝÖ±½Ó·ÅÈëÁËÄÚ´æ¡£
¡¡¡¡/*
¡¡¡¡* project:
¡¡¡¡* ͨÓÃÄ£¿é ( Óà c++ ´¦Àí mysql Êý¾Ý¿âÀ࣬ÏñADO )
¡¡¡¡*
¡¡¡¡* description:
¡¡¡¡*
¡¡¡¡* ͨ¹ýDataBase,Reco ......
Èç¹ûÄãÊǸöÈü³µÊÖ£¬²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇʲô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQLµÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸ ......
ÔõÑù½øÐÐMysqlÔ¶³ÌÁ¬½Ó
ÎÒÓÃ:
grant all privileges on *.* to ´´½¨µÄÓû§Ãû@localhost identified by "ÃÜÂë";
flush privileges; \* ˢиղŵÄÄÚÈÝ*\
========================
mysqlĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ÒòΪÓкܴóµÄ°²È«Òþ»¼¡£¡£
ËùÒÔÐèÒªÊÖ¶¯Ôö¼Ó¿ÉÒÔÔ¶³Ì·ÃÎÊÊý¾Ý¿âµÄÓû§¡£
ÏÂÃæÊÇÁ¬½Ó·½Ê½£º
# m ......