Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution

By: FYIcenter.com

A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result fields. Topics included in this collections:

1. How To Download and Install PHP on Windows?
2. How To Check Your PHP Installation?
3. What Do You Need to Connect PHP to SQL Server?
4. How to Turn on the MSSQL API Module?
5. What Is Wrong with SQL Server Client Libarary DLL, ntwdblib.dll?
6. What Happens If ntwdblib.dll Is Missing on Your Machine?
7. Where to Find ntwdblib.dll Version 2000.80.194.0?
8. How To Connect with Different Port Numbers?
9. What Are Commonly Used MSSQL Functions in PHP?
10. How To Disconnect from a SQL Server using mssql_close()?
11. How To Select an Exiting Database using mssql_select_db()?
12. How To Execute a SQL Statement using mssql_query()?
13. How To Retrieve Error Messages using mssql_get_last_message()?
14. How To Turn Off Warning Messages during PHP Execution?
15. How To Receive Returning Result from a Query?
16. How To Loop through Result Set Objects using mssql_fetch_array()?
17. How To Retrieve Field Values using mssql_result()?
18. How To List All Field Names in the Result Set using mssql_field_name()?

Please note that all answers and tutorials are based on SQL Server 2005 Express Edition and PHP 5 on Windows XP. Sometimes you may need to run previous tutorials in order to continue a later tutorial.

Continue with the next FAQ collection on how to manage tables and selecting data rows with PHP scripts.

(Continued on next topic...)