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
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
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
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)
Server Name: localhost
Administrator Email: (any email address)
Also ensure the "for all Users, on Port 80, as a Service -- Recommended" is checked.

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.
Step 3: Install PHP
Run the PHP installation file which you downloaded in Step 1.
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 Files\Apache Group\Apache2\conf\
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:
To ensure that PHP is running on the server, you can create a php file with the following contents:
<?php phpinfo(); ?>
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 Files\Apache Software Foundation\Apache2.2\htdocs
Now, in your browser, type:
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 the c:\WINDOWS\system32. 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.
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.
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:
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.
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.
This information is awesome and thanks a ton for talking about it :-) I’m expecting seriously for the next post of yours...
ReplyDeleteWebsite Design Companies Bangalore
Thanks, for providing good Information to community…
ReplyDeletePhp Web Development Company Bangalore | Website Developer In India | Internet Marketing Company in Bangalore | Hire Magento Developer In India
Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
ReplyDeleteDedicated Yii Framework Developers in India