Creating a SQL Development Environment

To run this SQL tutorial from examples, you must define a work environment.

Using Wamp Server or EasyPHP or equivalent software, the main thing is already being done:

  1. The Apache server is installed locally.
  2. MySQL is installed on your computer.
  3. If necessary, PHPMyAdmin is ready.
  4. PHP is set to enable the mysql extension that we will work with.

The scripts that we will execute will have to be stored in the www subdirectory of the server software directory. To run the script, open the program's pop-up menu on the taskbar and click localhost, and then click the project folder.

The examples we have given are designed to work on a server. Therefore, you need to check whether the hosting configuration is ready for scripts.

To do this, load a small script called infos.php (make sure that no file already has this name):

<?php phpinfo(); ?>

Then run the program:

http://www.example.com/infos.php

With site URL. If the program does not work, either PHP or the phpinfo function is not supported. Then check the hosting documentation or change the hosting.

Otherwise, make sure that the PHP version is at least PHP 4 and the mysql extension is enabled. Each extension has its own descriptive table with the extension name above. Then clean infos.php.

If the mysql extension is enabled, we will be able to upload examples to the network, otherwise we will simply test them locally.

Further information