php 创建mssql 表,在php表中显示MSSQL选择数据
我很遗憾,我错过了一些简单的事情.这是我第一次从MSSQL服务器提取数据并使用php在表中显示它.我以前用
mysql做过这个,但是不能让它与mssql一起工作.这是我目前的代码:
$myServer = "server";
$myUser = "user";
$myPass = "password";
$myDB = "mssqldb";
//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");
//declare the SQL statement that will query the database
$query = "SELECT col1, col2 ";
$query .= "FROM sqltable ";
//execute the SQL query and return records
$result = mssql_query($query)
or die('A error occured: ' . mysql_error());
//Show results in table
$o = '
Col 1Col 2
';while ( $record = mssql_fetch_array($result) )
{
$o .= '
'.$col1.''.$col2.'';}
$o .= '
';echo $o;
//Show result from sql table separated by comma (commented out)
/* while ( $record = mssql_fetch_array($result) )
{
echo $record["col1"] . " , " . $record["col2"] . "
";
} */
//free result set memory
mssql_free_result($result);
//close the connection
mssql_close($dbhandle);
?>