未在centos 7中安装带有MSSQL的PHP [英] PHP with MSSQL not installing in centos 7

问题描述

我想在CentOS Linux系统中通过PHP连接MSSQl服务器.但是变得低于错误，

I want to connect MSSQl server through PHP in CentOS Linux system. But getting below error,

Fatal error: Call to undefined function mssql_connect() in /var/www/h.....

为此，我参考了一些网站并找到了解决方案.但这也行不通.在这里，我正在尝试安装php5-sybase，但出现了一些错误，

For that, i refered some site and found solutions. But that also not working. Here i am trying to installing php5-sybase, but getting some error,

yum install php5-sybase
Loaded plugins: fastestmirror, langpacks
apt.sw.be_redhat_el2.1_en_mirrors-rpmforge| 1.9 kB  00:00:00
remi-safe                                 | 2.9 kB  00:00:00


 One of the configured repositories failed (Unknown),
 and yum doesn't have enough cached data to continue. At this point the only
 safe thing yum can do is fail. There are a few ways to work "fix" this:

     1. Contact the upstream for the repository and get them to fix the problem.

     2. Reconfigure the baseurl/etc. for the repository, to point to a working
        upstream. This is most often useful if you are using a newer
        distribution release than is supported by the repository (and the
        packages for the previous distribution release still work).

     3. Disable the repository, so yum won't use it by default. Yum will then
        just ignore the repository until you permanently enable it again or use
        --enablerepo for temporary usage:

            yum-config-manager --disable <repoid>

     4. Configure the failing repository to be skipped, if it is unavailable.
        Note that yum will try to contact the repo. when it runs most commands,
        so will have to try and fail each time (and thus. yum will be be much
        slower). If it is a very temporary problem though, this is often a nice
        compromise:

            yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true

Cannot find a valid baseurl for repo: rpmforge

如何解决此问题.

推荐答案

要在CentOS上安装SQL Server的PHP驱动程序，以下是我的建议:

To install the PHP Driver for SQL Server on CentOS, here is what I would recommend:

sudo su
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
exit
sudo ACCEPT_EULA=Y yum install msodbcsql
sudo yum install unixODBC-devel
yum groupinstall "Development Tools"
sudo pecl install sqlsrv pdo_sqlsrv
sudo echo "extension= pdo_sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
sudo echo "extension= sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`

现在，您应该能够使用像这样的简单PHP脚本连接到SQL Server:

Now you should be able to connect to SQL Server using a simple PHP script like this one:

<?php
$serverName = "localhost";
$connectionOptions = array(
    "Database" => "SampleDB",
    "Uid" => "sa",
    "PWD" => "your_password"
);
//Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn)
    echo "Connected!"
?>

这篇关于未在centos 7中安装带有MSSQL的PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！