Using PHP to connect to SQL Server

Question

Using php I am trying to connect to a SQL Server table which has a hyphen in the name, error returned is

Warning: mssql_select_db() [function.mssql-select-db]: message: Could not locate entry in sysdatabases for database 'SMD'. No entry found with that name. Make sure that the name is entered correctly. (severity 16) in C:\xampp\xampp\htdocs\second.php on line 12

Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: SMD-GROUP in C:\xampp\xampp\htdocs\second.php on line 12
Couldn't open database SMD-GROUP

Code is

    $myDB = "SMD-GROUP"; 
     $selected = mssql_select_db($myDB, $dbhandle)
     or die("Couldn't open database $myDB");

PHP's MSSQL-driver is outdated and in fact disconinued for PHP 5.3. You should consider switching to Microsoft's SQL Server Driver for PHP (SQLSRV): msdn.microsoft.com/en-us/sqlserver/ff657782.aspx — dbrumann
– dbrumann, Commented Feb 22, 2012 at 10:50
Try reading the documentation for the function you're using. This is covered there. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Feb 22, 2012 at 11:08

Lightness Races in Orbit · Accepted Answer · 2012-02-22 11:09:26Z

6

Have a look at http://php.net/manual/en/function.mssql-select-db.php:

To escape the name of a database that contains spaces, hyphens ("-"), or any other exceptional characters, the database name must be enclosed in brackets.

edited Feb 22, 2012 at 11:09

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

answered Feb 22, 2012 at 10:44

prayagupadhyay

31.4k14 gold badges165 silver badges199 bronze badges

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

Comments

alfred abalos · Accepted Answer · 2013-08-13 09:55:20Z

1

if you are using MSSQL server 2005 or higher.. you should use SQLSRV drivers by microsoft. Be careful, there are still incompetency on the performance due to unresolve bugs on PHP5.4 and up. You should know if your PHP is compiled on VC6 or VC9 also if it is thread safe or not.. better to see this reference http://php.net/manual/en/book.sqlsrv.php.

remember that php_mssql.dll is already deprecated on PHP5.4 and higher. Also, I already test this on our UAT and Producion servers. Cheers!

answered Aug 13, 2013 at 9:55

alfred abalos

513 bronze badges

Comments

Bill the Lizard · Accepted Answer · 2014-06-25 13:35:30Z

0

It is better if you use PDO class for database connections with PHP, since PDO supports multiple DB drivers and is better supported. PHP Data Objects

$DB=new PDO('dblib:host='.$host.';dbname='.$database,$username,$password);

edited Jun 25, 2014 at 13:35

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Feb 22, 2012 at 10:46

kingmaple

4,3705 gold badges35 silver badges44 bronze badges

Collectives™ on Stack Overflow

Using PHP to connect to SQL Server

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related