ODBC is one of Microsoft's earliest technologies for connecting to databases. This article describes how to setup and use ODBC from a PHP perspective. Also discusses ODBC extension bugs, database wrapper libraries, Microsoft's ADO (which is Microsoft's recommended API for 4GL programmers) and DSN-less connections.
Everyone who likes MS HTML Help (.chm extension) can now obtain complete conversion of MySQL manual into this format. This conversion tries to bring additional functionality and make using of MySQL manual more comfortable.
This tutorial will hopefully teach you some basics of how to access data with your PHP scripting to gather information with in a MySQL database.
The first step you need to do is get a basic understanding of what MySQL is. If your site can handle or has access to a MySQL database you should try using the PHP Myadmin application to help you use and access your MySQL datases fast and easy.
In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that the parameters you use for the different connect functions are different also.. That's why a database wrapper library such as ADODB comes in handy when you need to ensure portability.
<p>
This tutorial has been translated into multiple languages, including German, Spanish, Polish, Thai and Chinese.