CentOS 5.4 ·þÎñÆ÷ÅäÖà yum°²×°Apache+php+Mysql
Centos ÀïµÄ yum ÔÚÏß°²×°ºÜÂý.ÒÔÏÂÊÇÌæ»»ÎªÖйúCentOS¾µÏñ·þÎñÆ÷!
Öйú¹Ù·½¾µÏñÍøÕ¾: http://centos.ustc.edu.cn/
/* ʹÓÃ˵Ã÷ */
cd /etc/yum.repos.d[½øÈëyum.repos.dĿ¼]
mv CentOS-Base.repo CentOS-Base.repo.save[ÐÞ¸ÄÔ´ÎļþÃû³Æ±¸·Ý]
wget http://centos.ustc.edu.cn/CentOS-Base.repo.5[ÏÂÔØ]
mv CentOS-Base.repo.5 CentOS-Base.repo[ÏÂÔØºóµÄÎļþ¸üÃû]
1. ¸üÐÂϵͳÄں˵½×îÐÂ.
yum -y update
ϵͳ¸üкó,Èç¹ûyum°²×°Ê±Ìáʾ´íÎóÐÅÏ¢,ÇëÖ´ÐÐÒÔÏÂÃüÁîÐÞ¸´.
rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY*
2. °²×°Apahce, PHP, Mysql, ÒÔ¼°phpÁ¬½Ómysql¿â×é¼þ
yum -y install httpd php mysql mysql-server php-mysql
//°²×°mysqlÀ©Õ¹
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql
//°²×°phpµÄÀ©Õ¹
yum -y install php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc
//°²×°apacheÀ©Õ¹
yum -y install httpd-manual mod_ssl mod_perl mod_auth_mysql
Ò»´ÎÐÔÕ³Ìù°²×°:
yum -y install httpd php mysql mysql-server php-mysql httpd-manual
mod_ssl mod_perl mod_auth_mysql php-mcrypt php-gd php-xml php-mbstring
php-ldap php-pear php-xmlrpc mysql-connector-odbc mysql-devel
libdbi-dbd-mysql
3. Æô¶¯·þÎñÅäÖÃ
/sbin/chkconfig httpd on [ÉèÖÃapacheΪ×ÔÆô¶¯]
/sbin/chkconfig –-add mysqld [mysql·þÎñ]
/sbin/chkconfig mysqld on [mysqld·þÎñ]
/sbin/service httpd start [×ÔÆô¶¯ httpd ·þÎñ]
/sbin/service mysqld start [×ÔÆô¶¯mysqld·þÎñ]
4.ÉèÖÃmysqlÊý¾Ý¿ârootÕʺÅÃÜÂë¡£
mysqladmin -u root password ‘ÐÂÃÜÂë’ [ÒýºÅÄÚÌîÃÜÂë]
ÈÃmysqlÊý¾Ý¿â¸ü°²È«
mysql -u root -p [´Ëʱ»áÒªÇóÄãÊäÈë¸Õ¸ÕÉèÖõÄÃÜÂ룬ÊäÈëºó»Ø³µ¼´¿É
mysql> DROP DATABASE test; [ɾ³ýtestÊý¾Ý¿â]
mysql> DELETE from mysql.user WHERE user = ”; [ɾ³ýÄäÃûÕÊ»§]
mysql> FLUSH PRIVILEGES; [ÖØÔØÈ¨ÏÞ]
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root’@'192.168.1.13′ IDENTIFIED BY ‘ÃÜÂë’ WITH GRANT OPTION; [Ôö¼ÓÔ¶³ÌÁ´½ÓÓû§]
°´ÕÕÒÔÉϵݲװ·½Ê½, ÅäÖóöÀ´µÄĬÈÏÕ¾µãĿ¼Ϊ/var/www/html/
²âÊÔ»·¾³
rpm -qa |grep mysql
rpm -qa |grep httpd
rpm -qa |grep php
Ïà¹ØÎĵµ£º
$str=preg_replace("/\s+/", " ", $str); //¹ýÂ˶àÓà»Ø³µ
$str=preg_replace("/<[ ]+/si","<",$str); //¹ýÂË<__("<"ºÅºóÃæ´ø¿Õ¸ñ)
$str=preg_replace("/<\!--.*?-->/si","",$str); //×¢ÊÍ
$str=preg_replace("/<(\!.*?)>/si","",$s ......
¸ù¾ÝÄãµÄʹÓÃÄ¿µÄÎÒ¾õµÃÕâ¸öº¯ÊýÓÐÁ½·½ÃæµÄÓÃ;£º
·ÀÖ¹SQL Injection¹¥»÷£¬Ò²¾ÍÊÇÄã±ØÐëÑéÖ¤Óû§µÄÊäÈë
²Ù×÷Êý¾ÝµÄʱºò±ÜÃâ²»±ØÒªµÄ×Ö·ûµ¼Ö´íÎó
mysql_real_escape_string() º¯ÊýתÒå SQL Óï¾äÖÐʹÓõÄ×Ö·û´®ÖеÄÌØÊâ×Ö·û¡£
ÏÂÁÐ×Ö·ûÊÜÓ°Ï죺
\x00
\n
\r
\
'
"
\x1a
Èç¹û³É¹¦£¬Ôò¸Ãº¯Êý·µ»Ø±»×ªÒåµÄ×Ö·û´ ......
±äÁ¿ÓÃÓÚ´æ´¢Öµ£¬±ÈÈçÊý×Ö¡¢×Ö·û´®»òº¯ÊýµÄ½á¹û£¬ÕâÑùÎÒÃǾͿÉÒÔÔڽű¾Öжà´ÎʹÓÃËüÃÇÁË¡£
PHP ÖеıäÁ¿
±äÁ¿ÓÃÓÚ´æ´¢Öµ£¬±ÈÈçÊý×Ö¡¢Îı¾×Ö·û´®»òÊý×é¡£
Ò»µ©ÉèÖÃÁËij¸ö±äÁ¿£¬ÎÒÃǾͿÉÒÔÔڽű¾ÖÐÖØ¸´µØÊ¹ÓÃËü¡£
PHP ÖеÄËùÓбäÁ¿¶¼ÊÇÒÔ $ ·ûºÅ¿ªÊ¼µÄ¡£
ÔÚ PHP ÖÐÉèÖñäÁ¿µÄÕýÈ··½·¨ÊÇ£º
$var_name = value;
PHP ......
×Ö·û´®±äÁ¿ÓÃÓÚ´æ´¢²¢´¦ÀíÎı¾Æ¬¶Î¡£
PHP ÖеÄ×Ö·û´®
×Ö·û´®±äÁ¿ÓÃÓÚ°üº¬×Ö·û´®µÄÖµ¡£
ÔÚ±¾½Ì³ÌÖУ¬ÎÒÃÇ´òËã½éÉܼ¸¸öÔÚ PHP ÖÐÓÃÓÚ²Ù×÷×Ö·û´®µÄ×î³£Óõĺ¯ÊýºÍÔËËã·û¡£
ÔÚ´´½¨×Ö·û´®Ö®ºó£¬ÎÒÃǾͿÉÒÔ¶ÔËü½øÐвÙ×÷ÁË¡£Äú¿ÉÒÔÖ±½ÓÔÚº¯ÊýÖÐʹÓÃ×Ö·û´®£¬»òÕß°ÑËü´æ´¢ÔÚ±äÁ¿ÖС£
ÔÚÏÂÃæ£¬PHP ½Å±¾°Ñ×Ö·û´® "Hello World" ¸³ ......