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.

A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.

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.

For those working on php and mysql a server is mandatory. But what if you cannot have a place to upload and modify or maybe you just want to develop your project privately and then install online? This is the moment a local server is needed. Your computer can "act" like a normal server if you have some programs installed. PHPDEV is a free program that, once installed, can offer you the tools you needed to work offline on your projects and still be able to benefit from all the features a server has. This tutorial will guide you through all the steps needed till you have a working local server on your PC.

In some content management scripts case one needs to create a database and also populate it (insert the tables from the example .sql file). It's the case of PhpNuke for example. You will learn here to create a new database in phpmyadmin and also insert the needed information. There are some images too, to help you grasp the info easier.

This is an Easy Tutorials for Beginners of PHP. With this tutorial you will learn how to Connect to Mysql Databse,Insert Data into Mysql Database and Show data from Mysql Databse.

This article is intended for PHP programmers interested in learning about the SQLite extension. The article will introduce the reader to the functionality offered by the PHP SQLite extension,and overview the benefits of SQLite in relation to other database systems. A basic understanding of how PHP and SQL work is assumed.

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

If you are the root user then it will display all the databases on the server, but if your not the root user then it will show all the databases that your user has permissions for. It's a really fun to play around with and can be expanded in a variety of ways. It's explained in the comments.

The correct usage of PHP strings is essential when dealing with database queries submitted from User Forms, such as User Registration. Find out how to format strings before saving them in a database in this helpful tutorial.