Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
By: FYIcenter.com
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 - How To Create a New Table?
- PHP MSSQL - How To Drop an Existing Table?
- PHP MSSQL - How To Insert Data into an Existing Table?
- PHP MSSQL - How To Make a Column Nullable?
- PHP MSSQL - How To Insert Data with NULL Values?
- PHP MSSQL - How To Insert Multiple Rows with a subquery?
- PHP MSSQL - How To Get the Number of Affected Rows?
- PHP MSSQL - What Is a Result Set Object Returned by mssql_query()?
- PHP MSSQL - How To Loop through Returning Rows?
- PHP MSSQL - How To Update Existing Rows in a Table?
- PHP MSSQL - How To Delete Existing Rows in a Table?
- PHP MSSQL - How To Include Text Values in SQL Statements?
- PHP MSSQL - How To Include Date and Time Values in SQL Statements?
- PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes?
- PHP MSSQL - How To Perform Key Word Search in Tables?
- PHP MSSQL - How To Query Multiple Tables Jointly?
- PHP MSSQL - How To Create 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.
(Continued on next topic...)
|