ubuntu9.04Öа²×°ÅäÖÃphp5 + MySql + Apache
- -! Õæ²»ÈÝÒ×°¡£¬ÅªÁËÒ»Ì죬ÖÕÓڸ㶨ÁË£¡
ÔÚubuntu9.04ϰ²×°£¬Ê×ÏÈҪ׼±¸µÄ¶«Î÷ºÜ¶à£¬´ó²¿·ÖÊÇÓÃÀ´Ö§³ÖphpµÄ¿â£¬·Ï»°²»¶à˵£¬Ð´Õâ¸öÒ²ÊÇΪÁ˱ãÓÚÎÒÒÔºó²é¿´Ó㬼ÇÒä²»ÐУ¬¿È¡£¡£ÓÐÐèÒªµÄÅóÓÑÒ²¿ÉÒÔÀ´È¥Óá£
ÔÚubuntuÉϰ²×°£¬ÓÐÒ»¸öºÃ´¦¾ÍÊÇÓÐÐÂÁ¢µÃÕâ¸öÈí¼þ£¬Ê×ÏÈÏȰ²×°mysql£¬´ò¿ªÐÂÁ¢µÃ£¬ÎÒÔÚÕâÀïÑ¡ÕâµÄÊÇmysql-server 5.1Õâ¸ö°æ±¾£ºCanonical ²»Îª mysql-server-5.1 Ìṩ¸üеģ¬ÔÚÕâÀï±ê¼Ç°²×°ÊDz»»á°üÀ¨×Ô¶¯°²×°Mysql client Header fileµÄ£¬Õâ¸öÔÚphp°²×°Ê±ºò»áÓõ½£¬°²×°ÍêMysqlºóÄã¿ÉÒÔÔÚÐÂÁ¢µÃÖÐËÑË÷libmysqlclient16-dev£¬±ê¼Ç°²×°£¬ÕâÑùÔÚ°²×°phpʱ£¬configure¾Í²»»á³öÏÖÒÔϵĴíÎó: Cannot find MySQL header files under yes.
ÐÂÁ¢µÃ°²×°ºÜÈÝÒ×£¬±ê¼Ç°²×°¾Í¿ÉÒÔÁË£¬°²×°ºó£¬Mysql¾ÍÆô¶¯ÁË¡£
ÎÒÃÇ¿ÉÒÔÓÃÒÔÏÂÃüÁîÈ¥²é¿´µ±Ç°MysqlµÄ״̬
sudo service mysql status
ÕâÑù£¬Mysql¾ÍËã°²×°Íê³ÉÁË
½Ó×Ű²×°apache£¬Õâ¸ö°²×°Ò²Ëã±È½Ï¼òµ¥£¬ÉÏhttp://httpd.apache.org/download.cgiÏÂÔØ
httpd-2.2.14.tar.gz £¬ÎÒÊǰÑÎļþ·ÅÔÚÁË/home/username/tmpÏ£¬±È½Ï·½±ã,°²×°ÈçÏ£º
cd tmp/httpd-2.2.14
./configure --prefix=/usr/local/apache2 --enable-mods-shared=most --enable-so # ÕâÀïprefixÊÇÖ¸¶¨°²×°µÄ·¾¶ ,ÖÁÓÚºóÃæµÄ¿ÉÒÔÈ¥²é¿´ÎÒblogµÄÁîÒ»ÎÄ
make
sudo make install
make clean
´Ómakeµ½make clean£¬Õ⼸²½¶¼ÊDZàÒë°²×°£¬ÒÔÏ»ù±¾¶¼Ïàͬ£¬¾Í²»Ð´£¬Ö÷ÒªÔÚ./configureÕâÀï
µ½ÕâÀapache¾ÍËã°²×°ÍêÁË,²âÊԵϰ£¬http://127.0.0.1 Èç¹û³öÏÖÁËIt's works£¬¾Í±íÃ÷Äã³É¹¦°²×°ÁË¡£
×°µ½ÕâÀÈç¹ûÄãÏëÓÃÍøÉϵÄsudo service httpd start|stop|restart À´Æô¶¯£¬Í£Ö¹£¬ÖØÆôapacheµÄ»°ÊDz»¿ÉÄܵģ¬ÒòΪϵͳ²¢²»ÄÜʶ±ð³öhttpdÊÇʲô·þÎñ£¬ËùÒÔÔÚÕâÀïÈç¹ûÄãÏëÓÃsudo service httpd start|stop|restartÀ´¿ØÖÆapacheµÄ»°£¬ÄÇÇë¿´http://blog.csdn.net/eugenepada/archive/2009/12/27/5083852.aspx£¬Èç¹û²»ÏëµÄ»°£¬ÆäʵºÜ¼òµ¥
sudo /usr/local/apache2/bin/apachectl -k start|stop|restart|..»¹ÓÐÃüÁÄã¿ÉÒÔ /usr/local/ap
Ïà¹ØÎĵµ£º
AddSlashes: ×Ö·û´®¼ÓÈëбÏß¡£
bin2hex: ¶þ½øÎ»×ª³ÉÊ®Áù½øÎ»¡£
Chop: È¥³ýÁ¬Ðø¿Õ°×¡£
Chr: ·µ»ØÐòÊýÖµµÄ×Ö·û¡£
chunk_split: ½«×Ö·û´®·Ö³ÉС¶Î¡£
convert_cyr_string: ת»»¹Å˹À·ò×Ö·û´®³ÉÆäËü×Ö·û´®¡£
crypt: ½«×Ö·û´®Óà DES ±àÂë¼ÓÃÜ¡£
echo: Êä³ö×Ö·û´®¡£
explode: Çпª×Ö·û´®¡£
flush: Çå³öÊä³ö»º³åÇø¡£
get ......
Ö÷ÒªµÄ³ÌÐò£º
package greeds.jdbc.sample;
import greeds.jdbc.util.JDBCUtil;
import java.io.*;
import java.sql.*;
public class MySQLBlobSample {
public static void main(String[] args) throws Exception {
// дÈëÊý¾Ý¿â
/*
*
* Connection ......
ÔÚVC6ÖÐʹÓÃc API·½Ê½Á¬½ÓMySQLÊý¾Ý¿â
Ò»¡¢»·¾³ÅäÖÃ
1¡¢ÔÚMySqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØmysql-connector-c-noinstall£¬²¢½«½âѹºóµÄbinºÍincludeÎļþ¼Ð¿½±´µ½MysqlµÄ°²×°Ä¿Â¼
2¡¢ÉèÖÃVC6»·¾³£¬ÔÚvc¹¤¾ß-Ñ¡Ïî-Ŀ¼£¬¼ÓÈë¸Õ²ÅµÄIncludeÎļþ¼ÐµÄ·¾¶£¬ÀýÈ磺C:\Program Files\MySQL\MySQL Server 5.1\include
¶þ¡¢¹¤³ÌÉèÖÃ
3¡¢½«li ......
³£Á¿¿ÉÒÔÀí½âΪֵ²»±äµÄ±äÁ¿¡£³£Á¿Öµ±»¶¨Òåºó£¬Ôڽű¾µÄÆäËûÈκεط½¶¼²»Äܱ»¸Ä±ä¡£Ò»¸ö³£Á¿ÓÉÓ¢ÎÄ×Öĸ¡¢Ï»®Ïß¡¢ºÍÊý×Ö×é³É£¬µ« Êý×Ö²»ÄÜ×÷ΪÊ××Öĸ³öÏÖ¡£
ÔÚphpÖÐʹÓÃdefaine()º¯ÊýÀ´¶¨Òå³£Á¿£¬¸Ãº¯ÊýµÄÓï·¨¸ñʽΪ£º
define(string constant_name, mixed value, case_sensitive = true)
¸Ãº¯ÊýÓÐ3¸ö²ÎÊý£º
cons ......
µ±Ç°ÍøÖ·ÊÇä¯ÀÀÆ÷ÀíÏÔʾµÄÍøÖ·£¬ÊÇÓû§¿´µ½µÄ¡£
¸ù·¾¶ÊÇphpÎļþÔÚ·þÎñÆ÷ÉϵÄ·¾¶£¬ÊÇÕæÊµµÄÎļþ·¾¶¡£
(ÓëjavaÊDz»Ò»ÑùµÄ)
Èç¹ûÓжà²ãincludeÓï¾ä£¬±ØÐëÓøù·¾¶£¬·ñÔò³ö´í¡£
Ìá½»±íµ¥Ê±ÒªÌá½»µ½µ±Ç°ÍøÖ·µÄÏà¶Ô»òÕß¾ø¶ÔµÄÍøÖ·ÀïÃæ¡£
---------------------------------------------------------------------
Ò»¸öÊÇÍ ......