php7連接pdo

① ubuntu 16.04 php7.0婧愰噷闈㈠畨瑁呯殑鎬庝箞寰閲岄潰娣誨姞妯″潡

ubuntu 16.04 php7.0婧愰噷闈㈠畨瑁呯殑鎬庝箞寰閲岄潰娣誨姞妯″潡
pdo鎵╁睍妯℃槸鏈夎洰澶氫簡錛屽俻do_mysql涔熸槸pdo妯″潡涓鐨勪竴涓浜嗭紝涓嬫枃鎴戜滑灝變互瀹夎卲do_mysql涓虹ず渚嬪府鍔╁ぇ瀹朵粙緇嶄竴涓嬪畨瑁呮ラゅ惂錛屽叾瀹冪殑pdo鎵╁睍妯″潡瀹夎呮ラや篃鍙浠ヤ竴鏍楓
鍋囪緋hp鐩褰曚負/usr/local/php
mysql鐩褰曚負/usr/local/mysql
1. 榪涘叆PHP婧愮爜鍖卐xt/pdo鐩褰
cd ext/pdo
2. 鎵ц/usr/local/php/bin/phpize[鍋囪綪HP鐨勫畨瑁呯洰褰曚負/usr/local/php]
/usr/local/php/bin/phpize
3. 閰嶇疆鎵╁睍pdo
./configure --with-php-config=/usr/local/php/bin/php-config --enable-pdo=shared
4. 緙栬瘧 && 瀹夎卲do
make && make install
鎴愬姛鍒欏嚭鐜
Installing shared extensions: /usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/
Installing header files: /usr/local/php//include/php/
Installing PDO headers: /usr/local/php//include/php/ext/pdo/
璇存槑鍦/usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/鐩褰曚笅鐢熸垚浜唒do.so鏂囦歡
5. 鍦≒HP婧愮爜鍖呬腑榪涘叆pdo_mysql
cd ext/pdo_mysql
6. /usr/local/php/bin/phpize
/usr/local/php/bin/phpize
7. 閰嶇疆pdo_mysql[鍋囪綧ysql鐨勫畨瑁呯洰褰曚負/usr/local/mysql]
1./configure --with-php-config=/usr/local/php/bin/php-config --with-pdo-mysql=/usr/local/mysql
8. 緙栬瘧 瀹夎卲do_mysql
make && make install
鎴愬姛鍒欏嚭鐜
Installing shared extensions: /usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/
璇存槑鐨/usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/鐩褰曚笅鐢熸垚浜唒do_mysql.so鏂囦歡
9. 鍦╬hp閰嶇疆鏂囦歡涓鍔犱笂
extension="/usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so";
extension="/usr/local/php//lib/php/extensions/no-debug-non-zts-20060613/pdo.so";
10. 閲嶅惎鐩稿叧鏈嶅姟
/etc/init.d/php-fpm restart

② 濡備綍鍦≒HP7涓瀹夎卪ysql鐨勬墿灞

鐩稿逛笌PHP5錛孭HP7鐨勬渶澶у彉鍖栦箣涓鏄縐婚櫎浜唌ysql鎵╁睍錛屾帹鑽愪嬌鐢╩ysqli鎴栬卲do_mysql錛屽疄闄呬笂鍦≒HP5.5寮濮,PHP灝辯潃鎵嬪紑濮嬪噯澶囧純鐢╩ysql鎵╁睍錛屽傛灉浣犱嬌鐢╩ysql鎵╁睍錛屽彲鑳界湅鍒拌繃榪欐牱鐨勬彁紺衡滵eprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in鈥.鎵浠ュ湪浠ュ悗鐨勭▼搴忎腑錛屼負浜嗕繚鎸佸吋瀹規э紝瑕佸敖閲忓噺灝戜嬌鐢╩ysql鎵╁睍鐢ㄤ簬鏁版嵁搴撹繛鎺.

浣滀負榪愮淮浜哄憳鏉ヨ達紝鏃㈡兂浣跨敤PHP7鏉ユ彁鍗囨湇鍔″櫒鐨勬晥鐜囷紝鍙堣佷繚璇佽佺殑紼嬪簭鑳藉熻繍琛岋紝濡備綍鍋氬憿?

1.鍘籶hp緗戠珯涓婁笅杞絤ysql鎵╁睍錛宧ttp://git.php.net/?p=pecl/database/mysql.git;a=summary

2.瑙ｅ帇騫朵嬌鐢╬hpize宸ュ叿鍒濆嬪寲錛岀紪璇:---鏂囦歡鍖呮槸





#瑙ｅ帇
tarxzvfmysql-45881bd.tar.gz
#榪涘叆mysql鎵╁睍鐩褰昮romwww.mfbuluo.com
cdmysql-45881bd/
#浣跨敤phpize鍒濆嬪寲錛屾垜鐨刾hpize鍦/opt/鐩褰
/opt/php/bin/phpize
#緙栬瘧mysql鎵╁睍錛屼嬌鐢╩ysqlnativedriver浣滀負mysql閾炬帴搴
./configure--with-php-config=/opt/php/bin/php-config--with-mysql=mysqlnd
make&&makeinstall
3.鎺ヤ笅鏉,鎴戜滑鐩存帴緙栬緫php.ini鏂囦歡錛屾妸mysql.so鎷瘋礉鍒皃hp.ini鐨別xtension_dir涓錛岀劧鍚庡湪php.ini涓鍔犲叆extension=mysql.so

4.閲嶅惎php

鎴愬姛涔嬪悗錛岀敤phpinfo鍗沖彲鐪嬪埌mysql鎵╁睍鐨勪俊鎮:



灝忕粨

鐩稿逛簬PHP5錛岄兘璇碢HP7鏈夐潪甯稿ぇ鐨勬ц兘鎻愬崌.濡傛灉鎮ㄨ繕鍦ㄤ嬌鐢ㄥ叾瀹冪増鏈,鍙浠ュ崌綰т竴涓嬭瘯璇.
濡備綍鍦≒HP7涓瀹夎卪ysql鐨勬墿灞
鏍囩撅細contentcenter緗戠珯瀹夎卪ysqlloadimaidtext鎺ㄨ崘

③ php5和php7連接資料庫的區別

PHP5中使用mysql_connect()函數進行連接，但實際上，PHP5.5開始，mysql系列函數就不推薦使用了，屬於廢棄函數
PHP7中貌似已經徹底不支持了，根據官網說明，取而代之的是如下兩個：
本擴展自PHP5.5.0起已廢棄，並在將來會被移除。應使用MySQLi或PDO_MySQL擴展來替換之。

$host='127.0.0.1';//主機名或IP地址
$user='root';//資料庫用戶
$database='cake';//資料庫名
$password='root';//資料庫密碼

$mysqli=newmysqli($host,$user,$password,$database);

$query='SETNAMESUTF8';

$mysqli->query($query);

if($mysqli->errno){
print_f("連接資料庫錯誤<br/>%s",$mysqli->error);
exit;
}

④ win10 php7 怎麼弄mysql擴展

非常遺憾的告訴你，php7不支持MySQL擴展了，只有使用mysqli和pdo擴展，PHP.INI中取消下面兩行前面的分號：
extension=php_mysqli.dll
extension=php_pdo_mysql.dll

⑤ debian8怎麼安裝php7

debian8 編譯安裝 php7
目錄(?)[-]
Please reinstall the libcurl distributionCannot find OpenSSL
configure error Unable to locate gmph
Can not find recodeh anywhere under usr usrlocal usr optCannot find pspell
Please reinstall the mysql distribution
mcrypth not found Please reinstall libmcryptxml2-config not found
安裝編譯器
apt-get install build-essential autoconf automake libtool bison re2c獲取PHP安裝包
wget https://downloads.php.net/~ab/php-7.0.13RC1.tar.gz安裝dev包
apt-get install libxml2-dev libssl-dev libbz2-dev libjpeg-dev libpng-dev libxpm-dev libfreetype6-dev libgmp-dev libgmp3-dev libmcrypt-dev libmysqlclient15-dev libpspell-dev librecode-dev進行編譯安裝
./buildconf //用來生成configure腳本
./configure \
--prefix=/usr \
--with-config-file-path=/etc \
--enable-mbstring \
--enable-zip \
--enable-bcmath \
--enable-pcntl \
--enable-ftp \
--enable-exif \
--enable-calendar \
--enable-sysvmsg \
--enable-sysvsem \
--enable-sysvshm \
--enable-wddx \
--with-curl \
--with-mcrypt \
--with-iconv \
--with-gmp \
--with-pspell \
--with-gd \
--with-jpeg-dir=/usr \
--with-png-dir=/usr \
--with-zlib-dir=/usr \
--with-xpm-dir=/usr \
--with-freetype-dir=/usr \
--with-t1lib=/usr \
--enable-gd-native-ttf \
--enable-gd-jis-conv \
--with-openssl \
--with-pdo-mysql=/usr \
--with-gettext=/usr \
--with-zlib=/usr \
--with-bz2=/usr \
--with-recode=/usr \
--with-mysqli=/usr/bin/mysql_config
備註：錯誤1：Cannot find OpenSSL's libraries 解決：
確認已安裝過 openssl、libssl-dev 包，還是會提示該錯誤；解決辦法：
root@test2:~/php-5.3.27# find / -name libssl.so輸出結果為： /usr/lib/x86_64-linux-gnu/libssl.so初步判斷它可能只會在 /usr/lib/ 下尋找 libssl.so 文件，於是：
ln -s /usr/lib/x86_64-linux-gnu/libssl.so /usr/lib錯誤2：debian Please reinstall the libcurl distribution 解決：
# RetHat CentOS or Fedora 使用下面安裝命令yum install curl curl-devel
# Debian or Ubuntu使用下面的安裝命令
apt-get install curl
apt-get install libcurl4-gnutls-dev
錯誤3：Unable to locate gmp.h 解決：
在https://launchpad.net/debian/+source/gmp 下載 gmp源碼包，接著 ./configure && make && make install編譯 安裝
make &&make install
報錯處理
Please reinstall the libcurl distributionaptitude search libcurl4
aptitude install libcurl4-gnutls-dev
Cannot find OpenSSL』
wget https://www.openssl.org/source/openssl-1.0.2j.tar.gztar -zxvf openssl-1.0.2j.tar.gz
cd openssl-1.0.2j
./config
make && make install
configure: error: Unable to locate gmp.h
sudo apt-get install libgmp-dev libgmp3-devln -s /usr/include/x86_64-linux-gnu/gmp.h /usr/include/gmp.hCan not find recode.h anywhere under /usr /usr/local /usr /opt.
apt-get install librecode-dev
Cannot find pspell
apt-get install libpspell-dev
Please reinstall the mysql distribution
apt-get install libmysqlclient15-dev
mcrypt.h not found. Please reinstall libmcrypt.
apt-get install libmcrypt-dev
xml2-config not found
apt-get install libxml2-dev