Collections:
SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution
A collection of 14 FAQs on using PHP ODBC functions to connect to SQL Server databases. Clear explanations and tutorial exercises are provided on testing ODBC DSN settings; creating connection to a SQL Server through a DSN; executing SQL statements; looping through result set; Executing prepared statements. Topics included in this collections:
Requirements to Use ODBC Connections in PHP
Commonly Used ODBC Functions in PHP
Testing ODBC DSN Connection Settings
odbc_connect() - Connecting to a SQL Server through an ODBC DSN
odbc_data_source() - Listing All DSN Entries
odbc_exec() - Executing SQL Statements
odbc_errormsg() - Retrieving ODBC Error Messages
Turning Off PHP Warning Messages for ODBC Connection
Returning Result from Query with ODBC Connection
odbc_fetch_row() - Looping through Result Set Objects
odbc_result() - Retrieve Field Values
odbc_tables() - Listing All Tables in the Database
Please note that all answers and tutorials are based on SQL Server 2005 Express Edition and PHP 5 on Windows XP. To follow tutorial exercises in this collection, you need to use test tables created from previous tutorial collections.
⇒ Requirements to Use ODBC Connections in PHP
✍: Guest
2024-03-17, 1272🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...