MSSQL connection using PHP

Question

Iam so fresh with PHP so this problem so big to me. I dont know why and where my mistake is. Based on my research to connect to MSSQL database by using this code:

<?php
$run = mssql_connect('dev-svr05','sa','P@55w0rd', 'orlig_sm_dev');
if ($run)
{
    echo "Connection OK";
}
else
{
    echo "Connection Failed";
}
?>

But when i run this code i got this error message:

PHP Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwroot\phpscript\save_mssql.php on line 5

I using the same code to connect to MYSQL and its success but not with MSSQL. Can anybody please tell me why this is happen? Thank You

Thanks for your response. Could you please guide how to install PECL odbtp >= 1.1.1 — Ifwat
– Ifwat, Commented Apr 15, 2015 at 2:13

Tschallacka · Accepted Answer · 2015-04-14 09:41:45Z

1

I would advice you download the sql server binaries from windows and use PDO.

try { 
        //In some occasions you only need to define IP/Hostname and you can forgo the \SQLEXPRESS part
        $db = new PDO( "sqlsrv:Server=HOSTNAME\SQLEXPRESS;Database=DATABASENAME","USERNAME","PASSWORD");
       $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
       // set this to your primary database
      $db->query("USE DATABASENAME");
    }

    catch( PDOException $e ) { 

       die( "Error connecting to SQL Server".$e ); 
    }

edited Apr 14, 2015 at 9:41

answered Apr 14, 2015 at 9:31

Tschallacka

28.9k15 gold badges99 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanjay Kumar N S · Accepted Answer · 2015-04-14 09:12:15Z

0

Fourth parameter is expecting a true/false. Refer the below link and try: http://php.net/manual/en/function.mssql-connect.php

answered Apr 14, 2015 at 9:12

Sanjay Kumar N S

4,7595 gold badges25 silver badges41 bronze badges

Comments

Mohit maru · Accepted Answer · 2015-04-14 10:32:37Z

0

Try "sqlsrv_connect" instead of "mssql_connect"

answered Apr 14, 2015 at 10:32

Mohit maru

8238 silver badges15 bronze badges

1 Comment

Ifwat Over a year ago

Tried it. same error. PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\Inetpub\wwwroot\phpscript\save_mssql.php on line 14

Collectives™ on Stack Overflow

MSSQL connection using PHP

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related