To access MySql tables from PHP, I use the PHP code and the function below.

If I make these changes, would this code work for SQL Server 2008?

mysql_fetch_array to mssql_fetch_array
mysql_connect to mssql_connect
mysql_select_db to mssql_select_db
mysql_query to mssql_query

PHP code
--------------------------------------------------------------------------------
$sql = "SELECT mast_id FROM district_mast WHERE mast_district = '".$dist_num."'";
$result = func_table_access($sql);
$rows = mysql_fetch_array($result);

Function
--------------------------------------------------------------------------------
FUNCTION func_table_access($sql) {
$db = "aplustutoru";
$host = "localhost";
$user = "root";
$pass = "";

IF (!($conn=mysql_connect($host, $user, $pass))) {
PRINTF("error connecting to DB by user = $user and pwd=$pass");
EXIT;
}

$db3 = MYSQL_SELECT_DB($db,$conn) or die("Unable to connect to local database");
IF ($sql <> "justopendb") {
$result = MYSQL_QUERY($sql) OR DIE ("Can not run query because ". MYSQL_ERROR());
RETURN $result;
}
}

Recommended Answers

All 2 Replies

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.