Use Joomla to connect to another server's MSSQL. PHP Environment for Windows Apps Tutorial Erv (apache2.2.4,php tutorial 5.2.3)
The ";" before the following line in the php.ini Number removed.
; Extension=php_mssql.dll
Search NTWDBLIB.DLL files, typically under the C:windowssystem32 and PHP installation folder. Right-click Properties, view version, if it is 2000.80.194.0 before, need to update.
After restarting the service, we found that local MSSQL is fine and remote cannot connect. Find more than n site, the answer is basically NTWDBLIB.DLL problem. However, the connection cannot be successful at all times.
Today simply in the local test, the environment for Windows under the XAMPP1.7.0, found Apachebin also exist NTWDBLIB.DLL files, and the server Appserv in the Apache did not. Replace it with a successful connection.
Conclusion: Appserv does not support MSSQL remote connection, its Apache is simpler than xampp, and can be seen from the number of files.
PHP functions on MSSQL:
Mssql_affected_rows:??? Gets the number of columns affected by the last query.
Mssql_close:??? Closes the connection to the database tutorial.
Mssql_connect:??? Connect to the database.
Mssql_data_seek:??? Move the column pointer.
Mssql_fetch_array:??? Returns the array data.
Mssql_fetch_field:??? Gets the field information.
Mssql_fetch_object:??? Returns the class data.
Mssql_fetch_row:??? Returns the individual fields of a single column.
Mssql_field_seek:??? Configure the pointer to a field that returns a value.
Mssql_free_result:??? Release returns memory consumption.
Mssql_num_fields:??? Gets the number of returned fields.
Mssql_num_rows:??? Gets the number of returned columns.
Mssql_pconnect:??? Open the MS SQL server continuous connection.
Mssql_query:??? Send out a query string.
Mssql_result:??? Gets the results of the query.
mssql_select_db:??? Select a database.
GB2312 UTF-8 function (vice versa):
Iconv ("gb2312", "Utf-8", $text)