I want to learn PHP PHP and Mysql. Where to begin?


Information for beginners to learn PHP and MySQL
For those who want to learn PHP, it may be advisable gorgeous " Teach the PHP " site
The course is in the process of writing, but it is already a reference to some lessons from it are in different sections of this FAQ. And believe me - it's worth it.
I can not recommend the wonderful stuff Bizon-AKA and Vadim Tkachenko, "Introduction to PHP and the MySQL" . He even published as a book, and now - a revised and expanded - is located on the site
" The PHP in the details ." The resource stands. Unlike the previous ones, recommend to read it in its entirety can only sadist - there's too much information. but that's its charm. It is an inexhaustible resource of PHP information. The only caveat - pay attention to the date of writing. Do not trust too much that is written before 2003.
Well, of course - this site, http://phpfaq.ru If you have not read it in its entirety - must do it. These are the problems that sooner or later, face to everyone who wrote in PHP.
A good course of studying the MySQL: http://www.intuit.ru/department/database/mysql/

Software.
To work with PHP on Windows, you must install the following programs:
- The Apache of web-server (5Mb)
- Himself the PHP (10Mb)
- Optional - the MySQL (23mb).
Setup is very simple. Apache is installed by the installation program. Where it asks for the name of your server and email the administrator, should be 2 times the write localhost and your e-mail.
PHP is unpacked from the zip to any folder desired (default - C: \ PHP) and is configured as an Apache module necessarily. For this purpose it is necessary to perform three steps:
- Rewrite php5ts.dll file in the WINDOWS directory
- In the httpd.conf file (C: \ Program Files \ Apache Group \ Apache \ conf \ httpd.conf), at the bottom, add the two lines
LoadModule php5_module c:/php/php5apache2_2.dll
AddType application/x-httpd-php .php .php3 .phtml

- To restart Apache (labeled Restart Apache HTTP in Group Server / Configure Apache Server)
After completing these steps, you can put a test php script (for example, he called test.php and consists of lines
<?php phpinfo (); ?>
) To the directory that is the root of the web server (default is C: \ Program Files \ Apache Group \ Apache \ htdocs \) and refer to it by writing in the browser address
<a href="http://127.0.0.1/test.php" target="_blank">http://127.0.0.1/test.php</a>
MySQL after downloading, unpack the zip from, and run setup.exe to install. To avoid problems, better to install in the default folder - c: \ mysql. If you have not already done so, you should carefully read the documentation.
After installation, at the command prompt (Start - Run - cmd.exe) run the following commands:
C:\mysql\bin\mysqld --install
net start mysql

All! MySQL is installed! To check the dial
C:\mysql\bin\mysql -uroot
If you run a console - everything works. Type exit to exit and proceed to configure the mysql support in PHP.
To do this if you have not already done so, take the file c:\php\php.ini-recommended and copy under the name php.ini in the windows directory. Then edit it by removing the semicolon at the beginning of the line
;extension=php_mysql.dll
and then overwrite the file c:\php\libmysql.dll and c:\php\ext\php_mysql.dll in the WINDOWS directory, and do not forget to restart Apache after that, as described above.
Now you can use mysql in their php-scripts.

Those for whom this statement is too complex, can try to establish a set of ready- Denver-2 .
It includes just everything you need, and a lot of unnecessary things. And most importantly - it works all by itself.
Another advantage of Denver is that the amount of the basic set 10 times less than the full versions - just 4 megabytes. And also the fact that its author writes interesting books on PHP.

Also, all inquisitive recommended VERY sensible article Install and configure Apache + PHP
with PHP5.RU. site And, of course - the official documentation sections dedicated to the installation of appropriate programs.

When asking a question on the forum, remember:
What it is likely to have encountered him tyscha people. And detailed answers can be found in the search. If, after all, have to ask the question - what can be described as more (only in their own words, not code!), What you did, that would receive and what was the result, as well as the exact copy of the error messages.

Sites for beginners.
Previously, there were placed links to various sites from beginner to novice.
Unfortunately, so it is not good quality material, they have long since abandoned by their authors, and finally lost relevance.
All that is best for PHP topic, listed at the top of the page.