Create a local PHP MySQL development environment

Create a Local PHP MySQL Development Environment

Note: IDM Computer Solutions, Inc does not provide technical support for Apache, PHP, or MySQL or the installation of these technologies on your system. This Power Tip is intended as an introduction to configuring Apache, PHP, and MySQL on your system in use with the PHP,MySQL, and development functionality in UEStudio.
Step 1. Download the installation files
You will need to download and install the windows version of the installers for each of the below componments:

Apache
Apache is the HTTP (Web) server software. http://httpd.apache.org/download.cgi

PHP
PHP is the general-purpose scripting language, especially suited for Web development, that we will be using.http://www.php.net/downloads.php

MySQL Server
MySQL is the database server/software we will be using.

http://dev.mysql.com/downloads/mysql/5.0.html#win32
Step 2: Install Apache
Run the Apache install file. You will need to follow the prompts and respond accordingly. When you reach the window that asks for server information, you may enter the following:

Network Domain: localhost
Server Name: localhost
Administrator Email: (any email address)

Also ensure the “for all Users, on Port 80, as a Service — Recommended” is checked.

For this Power Tip, we chose the default options and the default server isntallation path:

c:Program FilesApache Group

Continue clicking “Next” until the installation is complete.

If Apache has been installed correctly, and the server is running, you can type “localhost” in the address bar of your browser. You should see “It Works!” displayed in the browser.

You may also see the apache icon in your system tray:

When you hover your mouse over the icon, you should see that the services are running. If they are not, you can click on the icon and start the service.
Step 3: Install PHP
Run the PHP installation file which you downloaded in Step 1.

For the purposes of this Power Tip, we have selected the default installation path for PHP, which is:

C:Program FilesPHP

Click “Next” until you reach the “Web Server Setup” screen. Here you will need to select the appropriate server. Since we installed the Apache 2.2.xx version of Apache, we have selected “Apache 2.2.x Module“:

The next screen is the “Apache Configuration Directory”, here you will need to browse to the location of the Apache configuration directory. Because we installed Apache to the default location, the path we browsed to was:

C:Program FilesApache GroupApache2conf

You will be prompted to choose the items you would like to install. PHP does not, by default, install the MySQL database components. You must therefore expand the “Extensions” tree and navigate to MySQL and enable it for installation:

You will then click next and install. The PHP installer will then complete the installation.

You will be prompted as to whether or not you would like the installer to configure Apache, click on “Yes“. You should then see the the Apache configuration file has been successfully updated:

Click Ok, then click on Finish.

Verify that PHP is running 
To ensure that PHP is running on the server, you can create a php file with the following contents:

Save the file as “phpinfo.php” in the “htdocs” directory in the Apache installation directory, if you used the default installation path it would be:

C:Program FilesApache Software FoundationApache2.2htdocs

Now, in your browser, type:

http://localhost/phpinfo.php

You should see the a PHP information page displayed. You may need to restart the Apache service for PHP to be active. You can restart the service from the Apache icon in the system tray or from the Apache group in the start menu.

If PHP is not running, you may check the Apache error log for further information about the errors. The error logs are located in the “logs” directory in the apache installation directory.

Note: in order to run PHP/MySQL with apache, we had to copy the “php_mysql.dll” to c:WINDOWS, and the “libmysql.dll” to thec:WINDOWSsystem32. You will find these dlls in the ext directory in the PHP installation directory.
Step 4: Install MySQL
Run the MySQL installation file which you downloaded in Step 1.

Select the option for the “Typical” isntallation

You will then click on “Install“.

When the installation is complete, make sure the option for “Configure the MySQL Server Now” is checked (enabled) then click “Finish“.

The MySQL Server Instance Configuration Wizard will be launched. Click “Next” until you are prompted for the configuration type. For the purposes of this Power Tip, we have selected the standard configuration:

Next you will be asked to select the windows options. We have chosen the default options, however we have also enabled the option to “Include Bin Directory in Windows PATH” to allow for command line options.

Next you will be prompted to create an administrator (root) password:

Create a password then click “Next“. You will then click “Execute” to complete the configuration.

Note: if you are running the Windows Firewall, you may need to temporarily disable it prior to clicking on Execute. If you do not do this the wizard may not be able to finish the configuration. You can disable the firewall in the Windows Control Panel.

Create a Database
To create a database using the command line you will need to open the Command Line Client from the MySQL program group in the windows start menu.

When you open the client, you will be prompted to enter the password for the root account. This is the password that was previously configured. Type the password and hit Enter.

Read Also:  PHP – Make Youtube embed code from an Url

You should see that you have entered the MySQL environment:

 

 

 

 

To create a database, type the following command:

CREATE DATABASE uestudio_sample;

where “uestudio_sample” is the name of the database. Note: be sure to include the semi-colon at the end of the command.

If the command is successful you will see something similar to:

Query OK, 1 row affected (0.00 sec)

You may verify that the databases have been created by using the “Show Databases” command. If you type, “Show Databases;” and hit enter, you should see something similar to:

Create a Table
For the purposes of this Power Tip, we will create a table called “names” that includes the following fields: key, first, last. You may create this table using the following steps:

Type:

USE uestudio_sample;

This will tell MySQL which database to use, then type:

CREATE TABLE names (id INT NOT NULL AUTO_INCREMENT, first VARCHAR(48), last VARCHAR(48), PRIMARY KEY(id));

We will not cover the syntax of the command (above) in the scope of this Power Tip.

If you wish to see the structure of the table, and confirm it was created correctly, type:

Describe Names;

You should see something similar to:

Now, we need to insert sample data into our table. For example, if we want to create an entry to insert the name “John” (first) “Smith” (last) into the table “names”, we would do so using the following command:

INSERT INTO names (first, last) VALUES (‘John’, ‘Smith’);

You may insert additional data by modifying the VALUES. Because the id is an “auto increment”, we do not need to specify a value for this field.

To display all the data in the table, simply type:

SELECT * FROM names;

Because we inserted a few other names into our table, the query produced the following results:

Create a User
Now that you have a database, and data, you will want to create a user (account) that will be used by the server (php) to connect to the database. You may access the database with the “root” account, however this is not typically recommended.

To create a user account you will need to use the following command line:

GRANT ALL PRIVILEGES on uestudio_sample.* to idm@’localhost’ identified by ‘helloworld’;

“idm” is the Username and “helloworld” is the password for the user.
Step 5. UEStudio and PHP/MySQL
PHP Support
UEStudio has built in PHP support, which allows you to run scripts, check syntax, and more. If you are interested, you can click here to learn more about the PHP support.

Click on the PHP Commands icon on the script toolbar to configure the PHP support:

Select the option for “Select PHP Executable“, you will then browse to the location of the “php-win.exe” in the PHP installation directory. If you installed to the default path, the php-win.exe would be in

c:Program FilesPHP.

After you have selected the executable, you can use the PHP options from the PHP Commands. Simply open a PHP file then click on the options from the PHP Commands icon.

UEStudio offers additional options that make developing PHP Scripts easier, but before we demonstrate those options we will create a sample PHP script that we can work with.

Programming in PHP is not within the scope of this Power Tip so we will not go into great detail about the script below. This script is simply provided as an example.

The script below will connect to the “uestudio_sample” database running on localhost. This is the database we created earlier. The script will retrieve all the data from the “names” table and output the results in an HTML table.

If you used different values for the variables, you would need to change them for the script to work according to your environment.
//database server
define(‘db_server’, ‘localhost’);//user, password, and database variables
$db_user = ‘idm’;
$db_password = ‘helloworld’;
$db_dbname = ‘uestudio_sample’;/**
* Run MySQL query and output
* results in a HTML Table
*/
function outputQueryResults() {

//run a select query
$select_query = ‘SELECT * FROM names’;
$result = mysql_query($select_query);

//output data in a table
echo “n”;  while ($row = mysql_fetch_row($result)){      echo “n”;  foreach ($row as $val) {  echo “n”;  }  echo “n”;  }  echo ‘

$val

‘;
}

//connect to the database server
$db = mysql_connect(db_server, $db_user, $db_password);
if (!$db) {
die(‘Could Not Connect: ‘ . mysql_error());
} else {
echo “Connected Successfully…n”;
}
//select database name
mysql_select_db($db_dbname);

//run query and output results
outputQueryResults();

//close database connection
mysql_close($db)
?>

Create and save the “sample_script.php” in the htdocs directory, which is the same location as the phpinfo.php script from above. If you click on the “Run Script” from the PHP Commands, you should then see the output of the script in the Output window.

If you would like, you may use the other available commands from the PHP Commands.

To see the contents of the script in the web browser, type http://localhost/sample_script.php in your browser. You should see something similar to:

Connected Successfully…

1	John	Smith
2	Mike	Jones
3	Mike	Johnson

 

Create a Project
It is not neccessary to create a project file to develop using PHP/MySQL in UEStudio, however there are added benefits to creating a project. If the files you are editing are part of a project the built-in parser will parse the PHP script giving you a visual representation of the components of the script.

To create a project go to Project->Create New Project. Name the project then click Save. When the Project Settings dialog is presented, click on the Add File button and add the “sample_script.php” to the project.

To view the parsed representation of the file, click on the Files tab in the Workspace manager. If the Workspace manager is not open, you can open it in View->Views/Lists->Workspace Manager. Using the sample_script.php, you should see something similar to the below parsed representation:

By adding the file to the project, you may also use some of the functions from the IntelliTip Toolbar such as the Find Symbol Definition, Display Functions,

For a single file, such as this example, there is not much advantage for this. However, if you are using an object oriented style of PHP programming, and your project includes many fies, you may see something that looks more like:

As you can see, with a large project, this feature can be very helpful.