PHP + Apache + MySQL °²×°ÅäÖÃ
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°¡£ 1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP ÖÐÎÄ°æ, Apache, PHP, MySQL µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔصÄ:
* Apache 2.2.6£ºhttp://apache.mirror.phpchina.com/httpd/binaries/win32/
* PHP 5.2.4 (Windows Binaries PHP 5.2.4 zip package£©: http://www.php.net/downloads.php
* MySQL 5.0.45 Windonws: http://dev.mysql.com/downloads/ 2. °²×°µÄĿ¼½á¹¹¹æ»®
ΪÁË·½±ãά»¤£¬¿ÉÒÔ½«·þÎñÆ÷Èí¼þ°²×°ÔÚϵͳÅÌ£¨CÅÌ£©¶ø°Ñ×Ô¼ºµÄÎļþ¶¨Î»µ½ÆäËûÅÌ£¬ÕâÑù¶ÔÓÚÒÔºóµÄά»¤ºÜÖØÒª¡£ 3. ÔÚ Windows XP Ï°²×° Apache 2.2.6
Windows XP ϵݲװ
1. ÔËÐÐ apache 2.2.6 µÄ°²×°³ÌÐò£¬¸ù¾ÝÌáʾһ· Next ¼´¿É¡£ÔÚ Server Information µÄ Network Domain¡¢Server Name ×Ö¶ÎËæ±ãÌîÉÏÒ»¸öÓòÃû¼´¿É£¬Èçphp.com£¬È»ºó¸ù¾ÝÌáʾһ· Next Íê³É¼´¿É¡£ 2. ÔÚ°²×°½áÊøʱ£¬»áµ¯³öÒ»¸ö DOS ´°¿Ú£¬È»ºó¾ÍÏûʧÁË£¬ÕâÊÇϵͳapache×Ô¶¯Æô¶¯ÁË¡£ 4. ÔÚ Windows XP Ï°²×° php 5.2.4
1. ½«ÏÂÔØµÄ php 5 ZIP °üÖ±½Ó½âѹ£¬ÎÒÖ±½Ó½« PHP 5.2.4 zip Îļþ½âѹµ½ d:\php Ŀ¼ÏÂÃæ¡£°²×° php ²»½¨ÒéʹÓà win32 °²×°³ÌÐò(Ö÷ÒªÊÇÒÔºó°²×°À©Õ¹Âé·³£©¡£ 2. ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖнøÈë php µÄ°²×°Ä¿Â¼£¬½« php.ini-dist »ò php.ini-recommended ¸´ÖÆÒ»·Ý£¬ÃüÃûΪ php.ini¡£È»ºó´ò¿ª php.ini¡£ 3. ÕÒµ½: ;extension=php_mysql.dll ½«Ç°ÃæµÄ ; ºÅÈ¥µô£¬ ¸Ä³É£º extension=php_mysql.dll 4. ÕÒµ½: extension_dir = ¡°./¡± ½«Æä¸ÄΪÄãµÄ php °²×°Ä¿Â¼Ï ext ×ÓĿ¼µÄ¾ø¶Ô·¾¶¡£ÀýÈçÎҵģº extension_dir = ¡°D:/php/ext/¡± Õâ²½ºÜÖØÒª ¡£·ñÔò½ÓÏÂÀ´ php »áÕÒ²»µ½ php_mysql.dll Ä£¿é£¬ÎÞ·¨×°ÔØ¡£ 5. ÔÚ¡°¿ØÖÆÃæ°å¡±->¡°ÏµÍ³¡±->¡°¸ß¼¶¡±->¡°»·¾³±äÁ¿¡±£¬ÔÚ¡°ÏµÍ³±äÁ¿¡±ÀïÃæÕÒµ½path£¬±à¼pathµÄ±äÁ¿Öµ£¬Ìí¼ÓÄãµÄphpĿ¼D:\php£¬Ç°ÃæÒ»¶¨ÒªÓ÷ֺÅ(;)°ÑËüºÍÇ°ÃæµÄÖµ·Ö¿ª¡£
5. ÅäÖà Apache ºÍ PHP ´ò¿ª Apache °²×°Ä¿Â¼Ï嵀 conf ×ÓĿ¼ÖÐµÄ httpd.conf Îļþ¡£
1. ÕÒµ½£º DocumentRoot ¡°xxxxxxx¡± ¸Ä³ÉÄã±¾»úµÄÍøÕ¾ÄÚÈݵÄĿ¼¡£ÀýÈçÎҵģº DocumentRoot ¡°E:/web¡± 2. ÕÒµ½ LoadModule£¬¸ù¾ÝÄãµÄ php °²×°Ä¿Â¼£¬ÔÚÏÂÃæ¿Õ°×´¦¼ÓÉÏÕâÁ½ÐУº LoadModule php5_module ¡°D:/PHP/php5apache2_2.dll¡±
PHPIniDir ¡°D:/PHP¡± 3. ÕÒµ½: Di
Ïà¹ØÎĵµ£º
php -h¿ÉÒÔ»ñÈ¡°ïÖúÐÅÏ¢¡£PHP°æ±¾ºÅÐÅÏ¢£º/your_current_path/php -v£¬PHPÔËÐнű¾£º/your_current_path/php your_file_path£¬PHPÔËÐÐÓï¾ä/your_current_path/php -r your_code_snippet¡£
´úÂëÖ´ÐнáÊøºó£¬PHP»á¸ù¾Ý¾ßÌåÖ´ÐÐÇé¿ö×Ô¶¯µÄÊÍ·Å£¬Èç¹ûÖ´Ðйý³ÌÖÐÄÚ´æÏûºÄ½Ï´ó£¬¿ÉÒÔÀûÓÃNULL»òunsetÀ´ÊÍ·ÅÄÚ´æ¡£Çø±ðÔÚÓÚ£¬Ç°Õß ......
Ò»¡¢MySQL5.1°²×°
´ò¿ªÏÂÔصݲװÎļþ£¬³öÏÖÈçϽçÃ棺
mysql°²×°Ïòµ¼Æô¶¯£¬µã»÷“next”¼ÌÐø
Ñ¡Ôñ°²×°ÀàÐÍ£¬ÓГTypical£¨Ä¬ÈÏ£©”¡¢“Complete£¨ÍêÈ«£©”¡¢“Custom£¨Óû§×Ô¶ ......
mysql event (ÓÃÀ´ÊµÏÖ¶¨Ê±ÈÎÎñ)¡£mysql
´Ó
5.1.16
¿ªÊ¼ÓµÓеÄй¦ÄÜ¡£
ÏÂÃæÎÒдһ¸ö¼òµ¥µÄʾÀý¡£
ÏÈ´´½¨Êý¾Ý¿âºÍÁ½¸ö±í£º
drop database dep;
create database dep;
use dep;
create table aa
(id int AUTO_INCREMENT primary key,
remark varchar(20)
);
create table bb
(id int AUTO_INCREMENT primary k ......
ÒòΪMySQLÔÙdebianÏÂĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ËùÒÔÐèҪעÊ͵ôÕâ¸öÏÞÖÆ¡£ÎÒµÄMySQLÊÇÓÃapt-get°²×°µÄ£¬ËùÒÔ·¾¶ÊÇĬÈϵģ¨Èç¹ûÊÇ×Ô¼º
ÊÖ¶¯°²×°£¬¿ÉÒÔ×Ô¼ºÑ°ÕÒÏÂÕýÈ·µÄ·¾¶£©£¬ÓÃÃüÁî vi /etc/mysql/my.cnf ´ò¿ªÎļþ£¬×¢Ê͵ô bind-address = 127.0.0.1 ±£´æ:wq »Ø³µ¡£
È»ºóÔٵǼµ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ ......
´úÂë
//µÚÒ»ÖÖ·½Ê½
exec($cmd,$str,$result);
echo "result = $result <br/>";
if ($result != 0) {
echo "failed";
}
print_r($str);
#ûÓÐÊä³ö½á¹û
//µÚ¶þÖÖ·½Ê½
$output = shell_exec("/usr/bin/sudo /usr/bin/whoami 2>&1);
echo "output = ......