nginx+php cgi+mysqlÒ»¼ü°²×°°ü¸üаæ
[part1] http://download.csdn.net/source/2076258
[part2] http://download.csdn.net/source/2076272
[part3] http://download.csdn.net/source/2076276
[part4] http://download.csdn.net/source/2076283
[part02-04] http://www.ytgps.com/Images/nginx.rar
±¾ÎļþÌå»ý¹ý´ó·Ö4¸ö°ü£¬php-cgi+mysql+nginx.7z.001-.004¡£ÇëÏÂÈ«¡£ÏְѺóÃæ3¸ö°üÕûºÍÒ»¸ö°ü£¬http://www.ytgps.com/Images/nginx.rar
±¾°²×°ÎļþÐÞ¸ÄÁËÔ´ÂëÍøµÄ“CentOS ¼¯³Élinux+php-cgi+nginx+mysql°²×°°ü“ÀïÃæµÄ²¿·ÖÎļþ£¬Ö÷ÒªÊÇÐÞ¸ÄÁËinstall.shÄڵö´íÎóλÖá£Ä¿Ç°ÎÒ²âÊÔÔÚcentos 5.4Ï£¬°²×°Ò»ÇÐÕý³££¡
ʹÓÃÕâ¸ö°²×°Ö®Ç°ÇëÒ»¶¨¿´Ò»Ï±¾ËµÃ÷Îļþ£¡
˵Ã÷£º
1¡¢±¾°²×°°ü²¢·Ç±¾ÈËÔ´´£¬½ö½öÊǶÔÔ°²×°°ü½øÐÐÁËһЩϸ΢µÄÐ޸ģ¬Èôó¼ÒÄܸü·½±ãµÄ°²×°nginx+php-cgi+mysqlƽ̨£¬½øÐвâÊÔºÍѧϰËùÓᣱ¾×ÅѧϰµÄ¾«Éñ£¬Ï£Íû´ó¼ÒÄܸü¿ìÕÆÎÕÕâ¸öƽ̨¡£
2¡¢ÎļþÈ«²¿½âѹËõµ½/usr/local/src,¶ø²¢·Ç/usr/src¡£ËùÒÔ´ó¼ÒÇë×¢ÒâÕâÒ»µã£¬ÒÔÃâÔÚÔËÐÐ./install.shµÄʱºòÔì³ÉÕÒ²»µ½ÎļþµÄÎÊÌâ¡£Èç¹ûÄãÏë½âѹËõµ½/usr/srcÀïÃæ£¬ÄǾÍÖ»ÓÐÔÙÐÞ¸ÄÒ»ÏÂ./install.shÀïÃæµÄ¼¸¸ö¶ÔÓ¦µÄµØ·½¾Í¿ÉÒÔÁË¡£Õâ¸öÆäʵÎÞËùν¡£Ö»ÒªÖªµÀÁ˾ͺÃÁË¡£
3¡¢°²×°Ö®Ç°È·¶¨£¬±¾»úûÓÐÔËÐÐmysql£¬È·¶¨Ã»ÓÐÀàËÆapacheµÈ³ÌÐòÕ¼ÓÃ80¶Ë¿Ú£¬Èç¹ûÓУ¬É±Ö®£¡
4¡¢Ô°²×°°üµÄ˵Ã÷Îĵµ£º
centos 5.2ÀïÒ»¼ü°²×° ¼¯³Élinux+php-cgi+nginx+mysql°²×°°ü£¬Ö»ÒªÖ´ÐÐÒ»ÏÂÀïÃæµÄinstall.sh¾Í¿ÉÒÔÍê³É°²×°£¡mysql rootÃÜÂëΪ¿Õ£¬°²×°Â·¾¶ÔÚ/usr/local/mysqlÀï
web·¾¶ÔÚ/var/www/html£¬Èç¹ûÏë¸ü¸ÄÖ»ÒªÐÞ¸Ä/usr/local/nginx/conf/nginx.confÀïrootµÄ·¾¶¾ÍÐÐÁË¡£
¸ÐлÏÂÔØ¡£±¾ÈËÒ²ÊÇÐÂÊÖ£¬Ï£Íû´ó¼Ò¹ÄÀø£¡ÔÚ´Ë£¬¸ÐлÔ×÷ÕßµÄÎÞ˽·ÖÏí£¡ËäÈ»ÎÒ²¢²»ÖªµÀÄúÊÇË£¡¸ÐлGNU£¡¸ÐлCSDN£¡±¾ÎļþÓÉÓÚÌå»ý¹ý´ó£¬ËùÒÔ´ò³É4¸ö°ü£¬·Ö±ðΪ£ºphp-cgi+mysql+nginx.7z.001¡¢php-cgi+mysql+nginx.7z.002¡¢php-cgi+mysql+nginx.7z.003¡¢php-cgi+mysql+nginx.7z.004¡£ÇëÏÂÔØµÄÅóÓÑÒ»¶¨ÒªÏÂÔØÈ«¡£
Ïà¹ØÎĵµ£º
æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......
ÏÔʾËùÓÐÊý¾Ý¿â show databases;
´´½¨Êý¾Ý¿â create dababase stu;
ɾ³ýÊý¾Ý¿âdrop database stu;
Çл»µ½Êý¾Ý¿âuse stu;
È¡µÃµ±Ç°µÄÊý¾Ý¿â,´ø£¨£©±íʾº¯Êý:select database();
´´½¨±í£¨ÒªÇл»µ½Êý¾Ý¿âÖУ©
mysql> create table stu_info(
-> stu_id int(8) ......
1¡¢ÉçÍżò½é£º
LAMPÐÖµÜÁ¬ÉçÍÅ£¨¼ò³ÆÐÖµÜÁ¬£©ÊÇÒ×µÚÓŽÌÓýѧԺÁ쵼ϵÄÉçÍÅ×éÖ¯£¬ÊÇѧԺÁªÏµ¹ã´óLAMP°®ºÃÕßµÄÇÅÁººÍŦ´ø£¬ÊÇѧԺÉçÍŹÜÀíе÷µÄ»ú¹¹¡£
2¡¢ÉçÍÅÐÔÖÊ£º
ÓÉLAMPÐÖµÜÁ¬·¢Æð£¨www.lampbrother.net£©µÄÈ«¹úרҵÐÔ¡¢¹«ÒæÐÔÉç»áɳÁú×éÖ¯¡£
3¡¢ÉçÍÅÄ¿µÄ£º
a¡¢Îª°®ºÃLAMPµÄÅóÓÑÃǴһ¸öѧϰ½»Á÷µÄƽ̨
b¡¢Îª ......
<?php
/*
* Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
* ×÷Õß : pjx
* °æ±¾ : v 2010/02/25 v 1.0
* ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
* ʾÀý £º
* ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
* ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_st ......