0

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;
}
}

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by tonyeveland
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.