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


Folks, Im trying to run a basic php script in cmd prompt which connects to sql server 2012 on my local machine, its gives me the following error…”PHP Fatal error: Call to undefined function mssql_select_db() in c:…appscript.php on line 16″

Here is my script, im not very familiar with php but have been playing around with it and im unsure if my script is correct..

    $Server = "";
    $User = "";
    $Pass = "";
    $DB = "";

    //$SQLKEY = "";

    //connection to the database
    //$dbconn = sqlsrv_connect($Server, $User, $Pass)
    $connectionInfo = array("UID" => $User, "PWD" => $Pass, "Database" => $DB);
    $conn = sqlsrv_connect( $Server, $connectionInfo);
    //or die("Couldn't connect to SQL Server on $Server");

   //select a database to work with
    $selected = mssql_select_db($DB, $connectionInfo)
   or die("Couldn't open database $myDB");

   //declare the SQL statement that will query the database
   $query = "SELECT name from test ";

   //execute the SQL query and return records
  $result = mssql_query($query);

  $numRows = mssql_num_rows($result);
   echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

  //display the results
  while($row = mssql_fetch_array($result))
    echo "<br>" . $row["name"];
  //close the connection

Be great if someone could help or least give me a few pointers.


It seems you are using wrong functions. You should use only functions from http://www.php.net/manual/en/function.sqlsrv-begin-transaction.php

It seems there is no need to select db (there is no sqlserv_select_db function).

You should change your mssql_query to sqlsrv_query and the same for other functions and you should look at PHP manual because some functions may missing.

Answered By – Marcin NabiaƂek

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published