Nginx + PHP + Mysql (php frm 방식)
Nginx + PHP + Mysql (php-frm 방식)
글쓴이 :
최고관리자
조회 : 2,884
테스트환경
CentOS 4.7, 5.3
(CentOS 5.3의 경우 pear에러가 났습니다. 해결방법도 첨부합니다.)
준비파일
* http://kr.php.net/get/php-5.2.10.tar.gz/from/this/mirror
* http://php-fpm.org/downloads/php-5.2.10-fpm-0.5.13.diff.gz
* http://www.nginx.eu/download/sources/nginx-0.7.61.tar.gz
* http://meteor.kr/linux/ZendOptimizer-3.3.3-linux-glibc23-i386.tar.gz
1. MySQL 설치
# yum install -y mysql mysql-server mysql-connector-odbc mysql-devel
서버의 상태에 따라 아래의 설정파일을 이용합니다
[MySQL 환경 설정]
my-huge.cnf
1G 이상 (시스템 메모리)
my-large.cnf
512M ~ 1G
my-medium.cnf
128M ~ 256M
my-small.cnf
64M 이하
# cp /usr/share/mysql/my-huge.cnf /etc/my.cnf
# mysql_install_db
# chown -R mysql:mysql /var/lib/mysql/
# /etc/rc.d/init.d/mysqld start
# mysqladmin -u root password "비밀번호"
2. 필요한 라이브러리 설치
# yum install -y libtool-ltdl-devel curl curl-devel libxml2
libxml2-devel libjpeg-devel libpng-devel libmcrypt libmcrypt-devel pcre
pcre-devel openssl openssl-devel
3. PHP & FPM 설치
# tar xvzf php-5.2.10.tar.gz
# gzip -cd php-5.2.10-fpm-0.5.13.diff.gz | patch -d php-5.2.10 -p1
# cd php-5.2.10
# CFLAGS=
Ïà¹ØÎĵµ£º
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°ÈÕÆÚ
s ......
Ò» . °²×°ÓëÅäÖÃMYSQL
¡¡¡¡¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
¡¡¡¡1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
¡¡¡¡Æô¶¯MYSQL·þÎñ net start mysql
¡¡¡¡Í£Ö¹MYSQL·þÎñ net stop mysql
¡¡¡¡2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
¡¡¡¡3 . ÔÚÃüÁîÐÐÖеǽ ......
ÔÎÄÁ´½Ó£ºhttp://www.phpdo.net/index.php/2010/02/11/1-14/
PHPÖлñµÃÈÕÆÚʱ¼äÐÅÏ¢µÄº¯Êý——Getdate
ʱ¼ä´Á:°üº¬ÁË´ÓunixмÍÔª£¨1970Äê1ÔÂ1 ÈÕÁãʱ£©µ½¸ø¶¨Ê±¼äµÄÃëÊý£¬ÊÇÒ»¸ö³¤ÕûÊý¡£
Getdateº¯Êý¾ÍÊÇÓÃÀ´»ñµÃµ±Ç°Ê±¼ä£¬»òÕßÓÃÀ´·ÖÎöʱ¼ä´ÁµÄ¾ßÌåÒâÒå¡£Óï·¨£º
Array getdate([int timestamp])
º¬Ò壺ti ......
¡¶Head First
Éè¼ÆÄ£Ê½¡·ÊDZ¾²»´íµÄ½²½âÉè¼ÆÄ£Ê½µÄÊ飬²»ÏñF4дµÄÄÇô¿ÝÔӦ¸ÃËãÊDZȽÏÈÝÒ×Àí½âµÄºÃÊé¡£ÊéÖеÄÀý×Ó¶¼±È½ÏdzÏÔÒ×¶®£¬²»¹ýÓÉÓÚÊÇÍâ¹úÀÐдµÄ£¬ËùÒÔÀý×Ó
µÄϰ¹ß²»ÊǺܸ½ºÏÖйúÌØÉ«£¬¿ÉÄÜż¶û¿´ÆðÀ´ÓÐЩ±ðŤ£¬»¹ÓÐÓïÑÔϰ¹ßÒ²²»ÊÇÖйú·ç¡£µ±È»¿´¹ýÕâ±¾ÊéÖ®ºó£¬Äã²ÅÄÜÉî¿ÌÀí½âÉè¼ÆÄ£Ê½µ½µ×ÄÜΪÄã½â¾öÄÄЩ
퉣 ......
< type="text/javascript">
document.body.oncopy = function() {
if (window.clipboardData) {
setTimeout(function() {
var text = clipboardData.getData("text");
......