apacheÖÐphpÁ¬½ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µÄÎÊÌâ
ÎÊÌâÃèÊö£ºÒ»¸öÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄPHP½Å±¾testdb.php£¬ÔÚä¯ÀÀÆ÷ÖÐÔËÐУºhttp://localhost/testdb.php£¬³öÏÖ´íÎó£ºCan't connect to MySQL server on '10.60.56.220' (13)£¬µ«ÊÇÔÚ±¾µØÓÃphpÃüÁîÐÐÔËÐУºphp testdb.php£¬È´Õý³£µØÁ¬ÉÏÁËÊý¾Ý¿â²¢¶Á³öÁËÆäÖеÄÊý¾Ý¡£
Ó¦ÓóÌÐò»·¾³£º±¾µØIP£º10.60.56.90£¬±¾µØµçÄÔÉϰ²×°Apache 2.2.3ºÍphp 5.1.6£¬Ô¶³ÌÊý¾Ý¿â·þÎñÆ÷IP£º10.60.56.220£¬Êý¾Ý¿âÊÇmysql 5.0.45£¬±¾µØÏµÍ³ºÍÔ¶³Ìϵͳ¶¼ÊÇcentos 5.3¡£
½â¾ö·½·¨ÍêÈ«À´×ÔÓÚhttp://www.ehow.com/how_2090983_connect-remote-database-under-selinux.html£¬½â¾ö·½·¨Òì³£¼òµ¥£¬Ö»ÐèÒªÔÚ±¾µØµçÄÔÉÏÔËÐÐÒ»ÌõÃüÁ
setsebool -P httpd_can_network_connect=1
µ±È»£¬ÒªÓÐhttp·þÎñÆ÷ÉϵÄrootȨÏÞ£¬ÒòΪֻÓÐrootÓû§²ÅÄܹÜÀíselinux¡£
¹ØÓÚselinuxµÄÏêϸ֪ʶ£¬²Î¼û
°Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/487687.htm
WIKI£ºhttp://en.wikipedia.org/wiki/Security-Enhanced_Linux
selinux project£ºhttp://selinuxproject.org/page/Main_Page
ÔÚhttp://docs.fedoraproject.org/selinux-managing-confined-services-guide/¿ÉÒÔÏÂÔØµ½selinuxµÄÉèÖÃÎĵµ£¬ÆäÖÐÓÐÒ»ÕÂÊÇרÃŽ²½âapacheµÄÉèÖòÎÊýµÄ£¬³ýÁËapacheÒÔÍ⣬»¹ÓÐftp, mysql, cvs, bind, scp, nfs, sambaµÈµÈһЩ·þÎñµÄ²ÎÊý¡£
Ïà¹ØÎĵµ£º
Ò»¡¢°²×°ÏµÍ³»·¾³
1¡¢ÏµÍ³£ºcentos5
2¡¢²âÊÔÔÚvm5.5
×¼±¸Èí¼þ
lighttpd-1.4.18
ÏÂÔØµØÖ·
mysql-5.0.41
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
php-5.2.3
ÏÂÔØµØÖ·
SupeSite/X-Space
part1ÏÂÔØµØÖ·
part2ÏÂÔØµØÖ·
part3ÏÂÔØµØÖ·
discuz
ÏÂÔØµØÖ·
¶þ¡¢´î½¨web·þÎñÆ÷°²×°¹ý³Ì
1¡¢mysql5°²×°
$ tar zx ......
°æÈ¨ÉùÃ÷£º¿ÉÒÔÈÎÒâ×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷
http://www.5ilinux.com/lamp01.html
¹Ø¼ü×Ö£ºapache+mysql+php apache mysql php ÅäÖà lamp ·þÎñÆ÷ web
Linux+Apache+Mysql+PHPµäÐÍÅäÖÃ
µ÷ÊÔ»·¾³£ºRedhat9.0 Apache1.3.29 Mysql3.23.58 PHP4.3.4
LinuxϵͳµÄ°²×°ÎҾͲ»½²Á ......
¼ÙÈçÓÐÁ½¸ö±í£º user ºÍ articles ±í
½á¹¹£º
user£º £¨id, name£©
articles: (id,user_id,title,content)
ÆäÖÐuser.id ºÍ user_id ¹ØÁª
ÔÚuserµÄ modelÖÐµÄ relations·½·¨ÀïÃæ¼Ó£º
return array('articles'=>array(self::HAS_MANY,'articles','user_id'));
ÔÚarticlesµÄ modelÖÐµÄ relations·½·¨ÀïÃæ¼Ó£º
......
ÒýÓÃÎļþµÄ·½·¨ÓÐ2ÖÖ£º
1¡¢require
require("conn.php"); Ò»°ã·ÅÔÚÒ³ÃæµÄµÚÒ»ÐУ¬×öΪ¸ÃÒ³Ö´ÐеÄÒ»²¿·Ö£¬Ê×ÏÈÖ´ÐÐrequireÄÚµÄconn.php È»ºóÔÙÖ´ÐÐÏÂÃæµÄ´úÂë
2¡¢include
include("header.php");µ±³ÌÐòµ½´ïÕâÀïµÄʱºò²Å»áÖ´ÐÐincludeµÄ header.php ......
ÔÚÒÔǰµÄ×öµÄÀý×ÓÖÐÓöµ½¹ýÖØ¸´µÄ¼ÓÔØµÄ´íÎó ¶î ÄǸöÊÇͨ¹ýinclude_once()À´½â¾ö »òÕß²»ÈÃËûÖØ¸´¼ÓÔØ°ÑÖØ¸´µÄinclude()È¥µôÒ»¸ö»ò¶à¸ö£¬×îÖÕֻʣÏÂÒ»¸öÕâÑùÎÊÌâ¾Í½â¾öÁË£¬µ«½ñÌìÓöµ½µÄÎÊÌâ¾Í¼¬ÊÖÁË ËµÊÇÕÒ²»µ½Îļþ¡£
ÊÂÇéÊÇÕâÑùµÄ £¬½ñÌìÔÚÎļþ¼ÐÀïÔÙн¨ÁËÒ»¸öÎļþ¼Ð£¬È»ºóÒÔǰinclud ......