centos7 php-7 mssql 연결
pdo 이용
PECL :: The PHP Extension Community Library
What is PECL? PECL is a repository for PHP Extensions, providing a directory of all known extensions and hosting facilities for downloading and development of PHP extensions. The packaging and distribution system used by PECL is shared with its sister, PEA
pecl.php.net
sqlsrv, pdo_sqlsrv 다운로드
서버에서 pecl install sqlsrv, pdo_sqlsrv (파일명까지) - gcc 4.7 이상 필요
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
yum install unixODBC-devel mssql-tools
c11 무슨 에러 발생하면
wget https://ftp.gnu.org/gnu/gcc/gcc-4.8.2/gcc-4.8.2.tar.gz
tar zxvf gcc-4.8.2.tar.gz
cd gcc-4.8.2
./contrib/download_prerequisites (의존성 파일 다운로드)
./configure --prefix=/usr/local/gcc-4.8.2 --enable-checking=release --enable-languages=c,c++ --disable-multilib
(겁나 오래걸림)
make && make install
vim ~/.bashrc
export GCC=/usr/local/gcc-4.8.2 19
export LD_LIBRARY_PATH=$GCC/lib64:$PPL/lib:$LD_LIBRARY_PATH 20
export PATH=$GCC/bin:$PATH
php extension 에 sqlsrv, pdo_sqlsrv 추가하고
아파치 재시작
$conn = new PDO ("sqlsrv:Server=디비주소,$port;Database=디비이름", 아이디, 비번);
$query = $conn->prepare("SELECT * FROM app");
if ($query->execute()) {
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
print_r($row);
}
}