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

Q

A collection of 17 FAQs on using PHP MSSQL 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 MSSQL - Creating a New Table

PHP MSSQL - Dropping an Existing Table

PHP MSSQL - Inserting Data into an Existing Table

PHP MSSQL - Making Columns to Take NULL

PHP MSSQL - Inserting Data with NULL Values

PHP MSSQL - Inserting Multiple Rows with a Subquery

PHP MSSQL - mssql_rows_affected() - Number of Affected Rows

PHP MSSQL - Returning Result Set Objects

PHP MSSQL - mssql_fetch_array() - Looping through Returning Rows

PHP MSSQL - Updating Existing Rows in a Table

PHP MSSQL - Deleting Existing Rows in a Table

PHP MSSQL - Including Text Values in SQL Statements

PHP MSSQL - Including Date and Time Values in SQL Statements

PHP MSSQL - Computing Date and Time Differences

PHP MSSQL - Searching Records by Keywords

PHP MSSQL - Query Multiple Tables Jointly

PHP MSSQL - 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 MSSQL - Creating a New Table

⇐ mssql_field_name() - Retrieve Field Names

⇑⇑ 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-03-07, 2047🔥, 0💬