PHP Fatal error: Call to undefined function mssql_query()

Question

So I keep getting this error when I want to query something to the ms sql server..

The connection is made with the database but the queries seem to fail.

The error log contains this:

    PHP Fatal error:  Call to undefined function mssql_query()

The code on the php:

session_start();
include_once("connect.php");
if (isset($_POST['username'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$sql = "SELECT * FROM test WHERE username='".$username."' AND password='".$password."'";
$res = mssql_query ($sql) or die(mssql_error());

if (mssql_num_rows($res) == 1) {
    $row = mssql_fetch_assoc($res);
    $_SESSION['uid'] = $row['id'];
    $_SESSION['username'] = $row['Username'];
    $_SESSION['afdeling'] = $row['Afdeling'];
    $_SESSION['mail'] = $row['Mail'];
              header("Location: test.php");
    exit();
} else {
    echo "Invalid login information. Please return to the previous page.";
    exit(); }  }  ?>

Does anybody knows what the problem is?

Thanks in advance!

connect.php code:

<?php
$serverName = "MTN-TEST"; //serverName\instanceName
$connectionInfo = array( "Database"=>"PROCES_TEST", "UID"=>"blaaa", "PWD"=>"blooo");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "<span style='color:green;'>Connection established.</span><br />";
}else{
     echo "<span style='color:red;'>Connection could not be established.</span><br />";
    die( print_r( sqlsrv_errors(), true));
}
?>

@Innominatum : You have tagged this both mysql and sql-server. Which DB are you actually using ? — Ravi Singh
– Ravi Singh, Commented Jun 14, 2013 at 8:03
Are you sure connection to MS-SQL server is made correctly ? can you share code of connect.php ? — Minesh
– Minesh, Commented Jun 14, 2013 at 8:04

Daniel W. · Accepted Answer · 2013-06-14 08:26:04Z

10

You don't have the MS SQL Drivers installed. You can check this with phpinfo();

On Linux you need mssql.so or sybase.so With debian its apt-get install php5-sybase

For windows take a look here: http://msdn.microsoft.com/en-US/library/cc793139%28v=SQL.90%29.aspx

Drivers need to be configured for PHP to find the function mssql_...

You could also look at PDO DB classes as they can connect to any DBS, you need the drivers installed tho.

edited Jun 14, 2013 at 8:26

answered Jun 14, 2013 at 8:11

Daniel W.

32.6k15 gold badges99 silver badges155 bronze badges

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

2 Comments

M.B. Over a year ago

Took a look into it, the mssql library is missing in PHPinfo(); Any idea where I can get it for windows? :)

M.B. Over a year ago

That windows link to msdn did hit the spot. it works now Thank you!

Community · Accepted Answer · 2017-05-23 11:47:15Z

If your connect.php code returns "Connection established.", it's mean you installed MS SQL Drivers correctly. You have to use sqlsrv_queryfunction instead of mssql_query. The correct form of this command is:

     <?php
                $serverName = "serverName"; 
                $options = array(  "UID" => "sa",  "PWD" => "Password",  "Database" => "DBname");
                $conn = sqlsrv_connect($serverName, $options);

                if( $conn ) {
                     echo "Connection established.<br />";

                     $query='select * from test';
                     $result = sqlsrv_query($conn,$query);

                }else{
                     echo "Connection could not be established.<br />";
                     die( print_r( sqlsrv_errors(), true));
                }

            ?>

you can learn more here:

"PHP Fatal error: Call to undefined function mssql_select_db() in c:\...appscript.php on line 16"

user3970657 · Accepted Answer · 2014-11-12 11:45:16Z

0

you can use mssql_get_last_message() for mssql errors

answered Nov 12, 2014 at 11:45

user3970657

Collectives™ on Stack Overflow

PHP Fatal error: Call to undefined function mssql_query()

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related