Two Methods for connecting to sqlserver2000 in php5.3 (com and ODBC)

1. Com link, ADODB. Connection

Copy codeThe Code is as follows:
$ Conn = new Com ("ADODB. Connection"); // instantiate a Connection object
$ Connstr = "provider = sqloledb; datasource =.; uid = sa; pwd = 123456; database = jnold ;";
$ Conn-> Open ($ connstr );
$ Rs = new Com ("ADODB. Recordset"); // instantiate a Recordcount object

$ Rs-> Open ('select * from News where bigclassid = 59 And LeadPostil is null', $ conn, 1, 1 );
$ Count = $ rs-> RecordCount;
Echo "A total of {$ count} records <br/> ";
For ($ I = 0; $ I <$ count; $ I ++ ){

$ Arr_result [$ I] ['title'] = addslashes ($ rs-> Fields ('title')-> Value); // Title
$ Arr_result [$ I] ['color'] = addslashes ($ rs-> Fields ('titlecolor')-> Value? $ Rs-> Fields ('titlecolor')-> Value: "); // Title color
$ Arr_result [$ I] ['wenhao'] = addslashes ($ rs-> Fields ('othertext')-> Value); // Document No.

}


2. ODBC connection mssql

Copy codeThe Code is as follows:
$ Dbhost = ";
$ Dbuser = "; // your mssql User Name
$ Dbpass = "; // your mssql Password
$ Dbname = "; // your mssql database name

$ Connect = odbc_connect ("Driver = {SQL Server}; Server = $ dbhost; Database = $ dbname", "$ dbuser", "$ dbpass ");
$ SQL = "select * from content ";
$ Exec = odbc_exec ($ connect, $ SQL );
While ($ row = (odbc_fetch_array ($ exec )))
{
$ Row ['id'] //? Field Value
...
}