Innominatum Innominatum - 2 years ago 251
PHP Question

PHP Fatal error: Call to undefined function mssql_query()

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:

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");
} 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:

$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 />";
echo "<span style='color:red;'>Connection could not be established.</span><br />";
die( print_r( sqlsrv_errors(), true));

Answer Source

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

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

For windows take a look here:

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download