Home >> FAQs/Tutorials >> SQL Server FAQ

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

By: FYIcenter.com

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:

  1. PHP ODBC - How To Create a New Table?
  2. PHP ODBC - How To Insert Data into an Existing Table?
  3. PHP ODBC - How To Insert Multiple Rows with a subquery?
  4. PHP ODBC - How To Get the Number of Affected Rows?
  5. PHP ODBC - What Is a Result Set Object Returned by odbc_exec()?
  6. PHP ODBC - How To Loop through Returning Rows?
  7. PHP ODBC - How To Update Existing Rows in a Table?
  8. PHP ODBC - How To Delete Existing Rows in a Table?
  9. PHP ODBC - How To Include Text Values in SQL Statements?
  10. PHP ODBC - How To Include Date and Time Values in SQL Statements?
  11. PHP ODBC - How To Display a Past Time in Days, Hours and Minutes?
  12. PHP ODBC - How To Perform Key Word Search in Tables?
  13. PHP ODBC - How To Query Multiple Tables Jointly?
  14. 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...)

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...