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
Ïà¹ØÎĵµ£º
Tag:¡¡¡¡
-
1.
$query = $this->db->query('SELECT name, title, email from my_table');
foreach ($query->result() as $row)
{
echo $row->title;
echo $row->name;
echo $row->email;
}
2.
foreach ($query->result_array() as $row)
{
echo $row['title'];
echo $row['name'];
ech ......
//ת»»ÎªUNIXʱ¼ä´Á
function strtotimestamp(datestr)
{
var new_str = datestr.replace(/:/g,"-");
new_str = new_str.replace(/ /g,"-");
var arr = new_str.split("-");
var datum = new Date(Date. ......
¿ÉÒԲ鿴mysqlÎļþĿ¼my.iniÎļþ£¬¿ÉÒÔÕÒµ½ÀàËÆÓÚ
datadir="D:/beeagle/Program Files/MySQL/MySQL Server 5.0/Data/"µÄ×Ö¶Î
¸Ã·¾¶Îªmysql dataĿ¼
ĬÈÏÔÚ£º"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data\"
×¢Ò⣺Application DataÎļþ¼ÐÊÇÒþ²ØµÄ£¡£¡£¡
¿ÉÒÔÐÞ¸ÄÉÏÊöÅäÖ㬠......
ÒòΪMySQLÔÙdebianÏÂĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ËùÒÔÐèҪעÊ͵ôÕâ¸öÏÞÖÆ¡£ÎÒµÄMySQLÊÇÓÃapt-get°²×°µÄ£¬ËùÒÔ·¾¶ÊÇĬÈϵģ¨Èç¹ûÊÇ×Ô¼º
ÊÖ¶¯°²×°£¬¿ÉÒÔ×Ô¼ºÑ°ÕÒÏÂÕýÈ·µÄ·¾¶£©£¬ÓÃÃüÁî vi /etc/mysql/my.cnf ´ò¿ªÎļþ£¬×¢Ê͵ô bind-address = 127.0.0.1 ±£´æ:wq »Ø³µ¡£
È»ºóÔٵǼµ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ ......
PHP£¬ÊÇÓ¢Îij¬¼¶Îı¾Ô¤´¦ÀíÓïÑÔHypertext PreprocessorµÄËõд¡£PHP ÊÇÒ»ÖÖ HTML ÄÚǶʽµÄÓïÑÔ£¬ÊÇÒ»ÖÖÔÚ·þÎñÆ÷¶ËÖ´ÐеÄǶÈëHTMLÎĵµµÄ½Å±¾ÓïÑÔ£¬ÓïÑԵķç¸ñÓÐÀàËÆÓÚCÓïÑÔ£¬±»¹ã·ºµÄÔËÓá£
PHP ¶ÀÌØµÄÓï·¨»ìºÏÁË C¡¢Java¡¢Perl ÒÔ¼° PHP ×Ô´´ÐµÄÓï·¨¡£Ëü¿ÉÒÔ±È CGI »òÕß Perl ¸ü¿ìË ......