ÔÚFedora 12Öа²×°Apache2+PHP5+MySQL£¨LAMP£©
1.
ǰÑÔ
ÎÒʹÓõÄÖ÷»úÃûΪserver1.example.com
£¬ip
µØÖ·ÊÇ192.168.0.100
¡£ÕâЩÉèÖÿÉÄÜÓëÄãÏëÒªµÄÓÐËù²»Í¬£¬ËùÒÔÄã±ØÐëÔÚÊʵ±µÄµØ·½ÐÞ¸Äһϡ£
2
°²×°MySQL5
ÓÃÏÂÁÐÃüÁî°²×°MySQL
£º
yum install mysql mysql-server
È»ºóÎÒÃÇΪMySQL
´´½¨ÏµÍ³Æô¶¯Á´½Ó£¨ÕâÑùµÄ»°£¬MySQL
¾Í»áËæ×ÅϵͳÆô¶¯¶øÆô¶¯£©£¬²¢Æô¶¯MySQL
·þÎñÆ÷£º
chkconfig --levels 235 mysqld on
/etc/init.d/mysqld start
ÔËÐÐ
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
À´Îªroot
Óû§ÉèÖÃÒ»¸öÃÜÂ루·ñÔòÈκÎÈ˶¼¿ÉÒÔ·ÃÎÊÄãµÄMySQL
Êý¾Ý¿â£¡£©
3
°²×°Apache2
Fedora
ĬÈÏÓÐApache2
Õâ¸ö°ü£¬ÎÒÃÇ¿ÉÒÔÓÃÏÂÁÐÃüÁî°²×°Ëü£º
yum install httpd
ÏÖÔÚÅäÖÃÏÂϵͳʹµÃApache
Äܹ»Ëæ×ÅϵͳÆô¶¯¶øÆô¶¯…
chkconfig --levels 235 httpd on
...
Æô¶¯Apache:
/etc/init.d/httpd start
ÏÖÔÚ´ò¿ªä¯ÀÀÆ÷£¬·ÃÎÊhttp://192.168.0.100
£¬Äã¾ÍÓ¦¸ÃÄÜ¿´µ½Apache2
µÄÔ¤ÁôÒ³ÁË£º
ÔÚFedora
ÖÐApache
µÄĬÈÏÎĵµÂ·¾¶ÔÚ/var/www/html
£¬ÅäÖÃÎļþÊÇ/etc/httpd/conf/httpd.conf
¡£ÆäÓàµÄÅäÖÃÎļþ´æ´¢ÔÚ/etc/httpd/conf.d/
¡£
4
°²×°PHP5
ÎÒÃÇÓÃÏÂÁÐÃüÁî°²×°PHP5
ºÍApache
PHP5
Ä£¿é£º
yum install php
È»ºóÎÒÃÇÆô¶¯ÏÂApache
£º
/etc/init.d/httpd restart
5
²âÊÔPHP5/
»ñÈ¡PHP5
°²×°ºóµÄÏêϸÐÅÏ¢
ÍøÕ¾µÄĬÈÏÎĵµÂ·¾¶ÊÇ/var/www/html
¡£ÎÒÃÇÏÖÔÚÔÚÕâ¸öÎļþ¼ÐÖд´½¨Ò»¸öСÐÍPHP(info.php)
Îļþ£¬²¢ÔÚ£»ä¯ÀÀÆ÷ÖзÃÎÊËü¡£Õâ¸öÎļþ»áÏÔʾ¹ØÓÚPHP
°²×°µÄ´óÁ¿µÄϸ½Ú£¬ÀýÈçPHP
µÄ°æ±¾¡£
vi /var/www/html/info.php
<?php
phpinfo();
?>
ÏÖÔÚÎÒÃÇÔÚä¯ÀÀÆ÷ÖзÃÎÊÕâ¸öÎļþ(
ÀýÈçhttp://192.168.0.100/info.php
)
£º
ÕýÈçÄãËù¿´µ½µÄÒ»Ñù£¬PHP5
ÒѾÕý³£¹¤×÷ÁË£¬²¢ÇÒÔÚServer
API
ÕâÒ»ÐÐÖÐÏÔʾµÄApache
ÊÇÒÔApache2.0
Handler
ģʽ¹¤×÷µÄ¡£Èç¹ûÄãÏòÏ·ҳ£¬Ä㽫»á¿´µ½ÒѾ°²×°ÁËPHP5
µÄËùÓеÄÄ£¿é¡£MySQL
ûÓÐÔÚÕâÀïÁгöÀ´£¬Ò²¾ÍÒâζ×ÅĿǰPHP5
²¢²»Ö§³Ö
MySQL
¡£
6
ÈÃPHP5
Ö§³ÖMySQL
ÎÒÃǰ²×°php-mysql
Õâ¸ö°ü¼È¿ÉÒÔʹMySQL
Ö§³Öphp
ÁË¡£ÔÚÕâÀï×îºÃÒ²°²×°ÆäËûµÄPHP5
Ä£¿é£¬ÕâЩģ¿éÒ²ÐíÄã»áÔÚÆäËûµÄÓ¦ÓÃÖÐÓõ½¡£Äã¿ÉÒÔʹÓÃÏÂÁÐÃ÷ÐÇÏÈËÑË÷Ò»ÏÂPHP5
µÄÄ£¿é£º
yum search php
ѡȡÄãÐèÒªµÄÄ£¿é£¬²¢Ê¹ÓÃÏÂÁÐÃüÁî°²×°Ëü
Ïà¹ØÎĵµ£º
C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿âÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£º
http://sourceforge.net/projects/mysqldrivercs
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using System; ......
ÔÚPHPÍøÕ¾¿ª·¢ÖУ¬ÎªÁËÂú×ãÍøÕ¾µÄÐèÒª£¬Ê±³£ÐèÒª¶ÔPHP»·¾³±äÁ¿½øÐÐÉèÖúÍÓ¦Óã¬ÔÚÐéÄâÖ÷»ú»·¾³Ï£¬ÓÐʱÎÒÃǸüÐèҪͨ¹ýPHP»·¾³±äÁ¿²Ù×÷º¯ÊýÀ´¶ÔPHP»·¾³±äÁ¿Öµ½øÐÐÉèÖá£Îª´ËÎÒÃÇÓбØÒª¶ÔPHP»·¾³±äÁ¿ÏÈÓÐËùÊìϤ¡£½ñÌìºÍ´ó¼Ò·ÖÏíPHP»·¾³±äÁ¿$_SERVERºÍPHPϵͳ³£Á¿µÄ²¿·ÖÏêϸ˵Ã÷¡£
¡¡¡¡PHP»·¾³±äÁ¿Ö÷ÒªÓÐ$GLOBALS[]¡¢$_SERVER ......
Àý×Ó³ÌÐò¡£
<?php
define('CLIENT_MULTI_RESULTS', 131072);
$link = mysql_connect("127.0.0.1", "root", "",1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());
mysql_select_db("vs") or die("Could not select database");
?> ......
php½Ì³Ì mysql½Ì³Ì_connect Óëmysql_pconnectº¯ÊýÓëʵÀý½Ì³Ì
mysql_connect
mysql_connect($this->root,$this->user,$this->pass)
/*
mysql_connect ,µ¥¸ö·´ÎÊÓû§²»»áƵ·±µÄµ÷ÓÃÊý¾Ý¿â½Ì³Ì£¬Ã»±ØÒª±£³ÖÁ¬½Ó£¬¶øÇÒmysqlµÄÁ¬½ÓÊýÒ²ÊÇÓÐÏÞÖÆµÄ£¬ ʹÓà ¼°Ê±·ÃÎÊ±È½ÏÆµ·±£¬Ò²×îºÃʹÓÃmysql_connect£¬ÕâÑùÊ¹Ó ......
dz̸PHPÓï·¨(1)
¡¡¡¡ÔÚÄãѧ¹ý»ù±¾µÄHTMLÓï·¨,¾Í¿ÉÒÔ±à³öÒ»¸ö¾²Ì¬µÄWebÒ³£¬¿É¶¯Ì¬½»»¥ÐÅÏ¢ÊǺÜÖØÒªµÄ¡£ÈçÒ»Ð©ÍøÕ¾µÄ»áÔ±ÖÆµÄ»áÔ±×¢²á¡¢µÇ¼¶¼Ðèºó¶Ë³ÌÐòµÄÔËÐС£ºÜ¶àÍøÕ¾ËùÓõÄCGI³ÌÐòÖ÷ÒªÓÃPerl¡¢ASP¡¢Java¡¢PHP±àд£¬¶øÎÒÃÇÏÖÔÚËùÒªÓõľÍÊÇPHP¡£ËüÊÇÍêÈ«Ãâ·ÑµÄ£¬Õâ¾ÍÒª¸ÐлÄÇЩĬĬÎÞÎŵıà³ÌÈËÔ±ÁË¡£PHPµÄ½á¹¹ÀàËÆÓÚ£ ......