ubuntu pdo mysql(php连接mysql实例)

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 安装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解决:

在下载 gmp源码包,接着./configure&& make&& make install编译安装

make&&make install

报错处理

Please reinstall the libcurl distributionaptitude search libcurl4

aptitude install libcurl4-gnutls-dev

Cannot find OpenSSL’

wget 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

ubuntu 16.04 php7.0源里面安装的怎么往里面添加模块

ubuntu 16.04 php7.0源里面安装的怎么往里面添加模块

pdo扩展模是有蛮多了,如pdo_mysql也是pdo模块中的一个了,下文我们就以安装pdo_mysql为示例帮助大家介绍一下安装步骤吧,其它的pdo扩展模块安装步骤也可以一样。

假设php目录为/usr/local/php

mysql目录为/usr/local/mysql

1.进入PHP源码包ext/pdo目录

cd ext/pdo

2.执行/usr/local/php/bin/phpize[假设PHP的安装目录为/usr/local/php]

/usr/local/php/bin/phpize

3.配置扩展pdo

./configure--with-php-config=/usr/local/php/bin/php-config--enable-pdo=shared

4.编译&&安装pdo

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/目录下生成了pdo.so文件

5.在PHP源码包中进入pdo_mysql

cd ext/pdo_mysql

6./usr/local/php/bin/phpize

/usr/local/php/bin/phpize

7.配置pdo_mysql[假设Mysql的安装目录为/usr/local/mysql]

1./configure--with-php-config=/usr/local/php/bin/php-config--with-pdo-mysql=/usr/local/mysql

8.编译安装pdo_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/目录下生成了pdo_mysql.so文件

9.在php配置文件中加上

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

linux php pdo mysql 需要安装mysql吗

你好,必须要安装的。

PDO MySQL简介

PHP Data Objects(PDO)扩展为 PHP访问数据库定义了一个轻量级的一致接口。实现 PDO接口的每个数据库驱动可以公开具体数据库的特性作为标准扩展功能。注意利用 PDO扩展自身并不能实现任何数据库功能;必须使用一个具体数据库的 PDO驱动来访问数据库服务。记录安装 PDO MySQL扩展过程。

PDO MySQL安装准备

PDO MySQL详细的安装配置如下

PDO MYSQL单独安装配置过程如下:

1、下载文件或者进入在PHP源码包中进入ext/pdo_mysql

2、解压文件

[root@localhost src]#tar zxvf PDO_MYSQL-1.0.2.tgz

3、配置和编译文件

[root@localhost src]cd PDO_MYSQL-1.0.2

[root@localhost MYSQL-1.0.2]/usr/local/php/bin/phpize

[root@localhost MYSQL-1.0.2]./configure--with-php-config=/usr/local/php/bin/php-config--with-pdo-mysql=/usr/local/mysql/--with-zlib-dir=/usr/local/lib

[root@localhost MYSQL-1.0.2]make

[root@localhost MYSQL-1.0.2]make install

注:我的PHP安装在:/usr/local/php/ mysql安装在:/usr/local/mysql编译的时候注意你自己的安装目录在哪里

切换目录,查看pdo_mysql.so是否存在

[root@localhost MYSQL-1.0.2]cd/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613/

编辑php.ini

[root@localhost MYSQL-1.0.2]vi/usr/local/php/etc/php.ini

添加pdo_mysql扩展

extension=/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so

或者 extension=pdo_mysql.so

重启apache

[root@localhost MYSQL-1.0.2]/usr/local/apache2/bin/apachectl restart

阅读剩余
THE END