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