Collections:
SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
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
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
✍: Guest
2024-03-07, 1257🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...