Search code examples
phpsql-serveriis-7.5php-5.3

"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..

  <?php
    $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
  mssql_close($dbconn);
  ?>

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

Solution

  • 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.