SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows

Q

A collection of 14 FAQs on using PHP ODBC functions to connect to manage tables and data rows. Clear explanations and tutorial exercises are provided on creating tables; inserting multiple data rows; updating and deleting data rows; searching data from multiple tables; looping through result sets; working with dates. Topics included in this collections:

PHP ODBC - Creating a New Table

PHP ODBC - Inserting Data into an Existing Table

PHP ODBC - Inserting Multiple Rows with a Subquery

PHP ODBC - odbc_num_rows() - Number of Affected Rows

PHP ODBC - Returning Result Set Objects

PHP ODBC - odbc_fetch_array() - Looping through Returning Rows

PHP ODBC - Updating Existing Rows in a Table

PHP ODBC - Deleting Existing Rows in a Table

PHP ODBC - Including Text Values in SQL Statements

PHP ODBC - Including Date and Time Values in SQL Statements

PHP ODBC - Computing Date and Time Differences

PHP ODBC - Searching Records by Keywords

PHP ODBC - Query Multiple Tables Jointly

PHP ODBC - Creating an Identity Column

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.

⇒ PHP ODBC - Creating a New Table

⇐ odbc_prepare() - Creating Prepared Statements

⇑⇑ SQL Server Connection Tutorials

✍: Guest

A

(This question has not been answered yet. If you know the answer, please share it in a comment below.)

2024-06-03, 1390🔥, 0💬