The ubiquity of the Internet has led to the fact that many people today are passionate about creating sites. When using modern CMS, this process is not too difficult. However, if a webmaster wants to implement unique functionality on his resource, he will most likely have to learn MySQL and PHP.
Necessary
- - browser;
- - access to the Internet;
- - text editor.
Instructions
Step 1
Download the documentation and software distributions you will need as you study. First of all, you need an HTTP server that will run PHP scripts. Apache is well suited for this role. Binaries, source archives and documentation for this server are available at https://www.apache.org. Similarly, distributions of the MySQL database management system, client utilities and its administration programs can be downloaded from the site https://www.mysql.com. Everything about PHP is available at https://www.php.net. Please note that for UNIX-like operating systems, all necessary software may be contained in the form of binary packages in the repositories of the distributor or on installation CDs. There is a good solution for Windows OS - the Denver package, available at https://www.denwer.ru, which includes Apache, PHP and MySQL.
Step 2
Install Apache, MySQL and PHP. For UNIX-like systems, use the available package managers such as rpm or apt-get, or build the software from source by following the documentation. On Windows, simply run the distribution files and follow the instructions in the installer.
Step 3
Check out the Apache and MySQL Administration Documentation. Pay attention to the aspects of managing virtual hosts, adding and removing databases, adding tables and modifying data in them.
Step 4
Configure Apache, MySQL and PHP. Add the virtual host to your Apache config. Start the HTTP server. Start MySQL. Use the console administration utilities (such as mysql, mysqladmin, mysql_install_db) or the MySQL Administrator application to add the database. Create one or more tables in the database. Fill in the data in them.
Step 5
Using a text editor, create a PHP script in the root directory of the virtual host. Copy into it the simple examples related to working with MySQL databases from the PHP documentation (for example, here https://www.php.net/manual/ru/ref.mysql.php). View the output of the script by opening it in a browser over
Step 6
Learn other aspects of PHP programming and MySQL usage. Use the available documentation extensively. Join the developer communities on specialized forums (such as https://rsdn.ru, https://forum.codeguru.ru, https://www.sql.ru/forum/, https://forum.ru-board.com), ask your colleagues questions.
