I am trying to make a connection with the database name 'dbname' using php-mssql. It shows connection is successfully done and connection is open now but when I am trying to execute create table query in that database then I am getting an error as MSSQL error: Changed database context to 'dbname'.
Here is my code:
<?php
$myServer = "123.456.88.99";
$myUser = "user1";
$myPass = "password";
$myDB = "dbname";
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
echo "connection done ".$selected;
$query = "CREATE TABLE prasad(customer_name varchar(10), contact_name varchar(10), Address varchar(50), city varchar(50), country varchar(50))";
if(mssql_query( $conn, $query))
{
echo "table creation successfull";
}
else{
echo "table not created";
die( 'MSSQL error: ' . mssql_get_last_message());
}
Note: database server and the hosting server are different servers that is why I have entered ip address in place of '$myServer'.