The community is working on translating this tutorial into Sinhala, but it seems that no one has started the translation process for this article yet. If you can help us, then please click "More info".
If you are fluent in Sinhala, then please help us - just point to any untranslated element (highlighted with a yellow left border - remember that images should have their titles translated as well!) inside the article and click the translation button to get started. Or have a look at the current translation status for the Sinhala language.
If you see a translation that you think looks wrong, then please consult the original article to make sure and then use the vote button to let us know about it.
Please help us by translating the following metadata for the article/chapter, if they are not already translated.
If you are not satisfied with the translation of a specific metadata item, you may vote it down - when it reaches a certain negative threshold, it will be removed. Please only submit an altered translation of a metadata item if you have good reasons to do so!
Introduction to MySQL with PHP
A database is your best choice for storing data in your web application, and the MySQL database server has always been the most popular choice among PHP developers. It's supported by almost any hosting company offering PHP, which makes it easy to get started with, and you can even download and install it on your own computer, for testing purposes.
MySQL uses the SQL (Structured Query Language) programming language to work with the data, and PHP interacts with MySQL by simply passing SQL code through a set of MySQL functions to the MySQL server, which then returns a result that PHP can interpret. It can seem a bit scary to have to learn a second language to interact with databases, but fortunately SQL is a fairly simple language, which looks a lot like the English language and we will provide you with some good SQL examples, allowing you to do the most common tasks.
In the following chapters we will work with the MySQL database and make it do various things for us. To do it properly, we need some common test data, which you will need to add to a database for which you have access to. The easiest way to do this is to use one of the many MySQL tools, with the most popular one being phpMyAdmin, which is installed on most servers offering PHP and MySQL. If you don't have access to phpMyAdmin, you can install it, use one of the many downloadable applications or use the MySQL prompt. Whatever you choose, you should execute the following SQL code against your database. In phpMyAdmin, this is done by clicking the button labelled "SQL":
CREATE TABLE `test_users` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `country` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ); INSERT INTO `test_users` VALUES (1,'David','USA'); INSERT INTO `test_users` VALUES (2,'Sammy','Canada'); INSERT INTO `test_users` VALUES (3,'Heidi','Germany'); INSERT INTO `test_users` VALUES (4,'Pierre','France'); INSERT INTO `test_users` VALUES (5,'Carlos','Spain');
When your done, a new table called "test_users" should have been created and filled with a small amount of testing data. In the next chapters we will work with it. If you're working with your own installation of PHP, please make sure that MySQL support has been enabled. This can be done in the php.ini file.