Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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
ѡȡÄãÐèÒªµÄÄ£¿é£¬²¢Ê¹ÓÃÏÂÁÐÃüÁî°²×°Ëü


Ïà¹ØÎĵµ£º

ÓйØphpǰ;¶þ

¹ØÓÚPHPµÄǰ;£¨¶þ£© £¨À´×Ô±¾Õ¾µÄÏûÏ¢£©
3.2ÔÚWindows 95/98/NT/2000ÉÏ¿ìËÙ°²×°Apache Web·þÎñÆ÷£¨10ÃëÖÓ£©
ÔÚWindowsÉÏÔËÐÐPHP£¬ÄãÐèÒªÒ»¸öWeb·þÎñÆ÷£¬Äã¿ÉÒÔʹÓÃ΢ÈíµÄIIS£¬Ò²¿ÉÒÔʹÓÃÃâ·ÑµÄApache ¡£ÒòΪ¿ÉÒÔͨ¹ýApacheµÄ°²×°Îļþsetup.exe½øÐа²×°£¬¿ÉÒÔΪÄã½ÚÊ¡Ðí¶àʱ¼ä¡£
PHPTtriadÊÇÒ»¸ö°üÀ¨Apache¡¢PHP¡¢MySQ ......

phpµ÷Óô洢¹ý³Ì

Àý×Ó³ÌÐò¡£
<?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º¯ÊýÓëʵÀý½Ì³Ì

php½Ì³Ì mysql½Ì³Ì_connect Óëmysql_pconnectº¯ÊýÓëʵÀý½Ì³Ì
mysql_connect
 mysql_connect($this->root,$this->user,$this->pass)
/*
mysql_connect ,µ¥¸ö·´ÎÊÓû§²»»áƵ·±µÄµ÷ÓÃÊý¾Ý¿â½Ì³Ì£¬Ã»±ØÒª±£³ÖÁ¬½Ó£¬¶øÇÒmysqlµÄÁ¬½ÓÊýÒ²ÊÇÓÐÏÞÖÆµÄ£¬ ʹÓà ¼°Ê±·ÃÎÊ±È½ÏÆµ·±£¬Ò²×îºÃʹÓÃmysql_connect£¬ÕâÑùÊ¹Ó ......

mysql 5.0 to mysql 5.1µÄBTREEË÷ÒýÎÊÌâ


ÎÒ±¾»ú²âÊÔÊǰ²×°µÄ mysql 5.1 , µ« centos ·þÎñÆ÷ÉÏÈ·ÊÇʹÓÃµÄ mysql 5.0 , ƽʱû·¢ÏÖ²î±ð, µ«×î½üsql Îļþµ¼Èëµ¼³öʱ·¢ÏÖÁË, Ò»µãСС²î±ð.
Ö÷ÒªÊÇÔÚ´¦Àíµ½Ë÷ÒýÓï¾äʱ³öÏÖÁ˲»¼æÈݵÄÇé¿ö, ±ÈÈçÏÂÃæÓï¾äÊÇÔÚ mysql 5.1 µ¼³öµÄ:
KEY `index_2` (`datatype`,`stime`,`line`,`mcode`) USING BTREE
Èç¹ûÏëµ¼Èëµ½ mysql 5 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ