Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN.
Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.
Learn how to print all data in a mySQL table into a neat HTML table to be displayed in your web browser. You do not even need to know the individual field names in the mySQL table, just provide the mySQL table to use and the process is complete. Easy to understand and can be adapted by you to suit your needs.
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.
This script is a real world application that shows how to use MySQL with PHP. You can learn from the step by step commented php source code how to build a php program that uses MySQL to keep a database of your books. Program functions implemented include, saving a new record, listing of records for user selection, selection of a record and displaying its details, updating a record, deleting a record and searching for records. Once you have learned the techniques used in this program, you can build any php-mysql based programs.
A detailed introduction to PHP and mySQL interaction. Includes detailed comments to help newbies get used to PHP and understand what is happening in each script.
A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.