Z037
NAVIGATION
 ZOEL'S ARCHIVE
Several options are available to browse the archive. Pull down the menu to access the options. You can also stack and unstack thoughts, increase or decrease Text Size. It could improve your browsing experience, or not.
Browsing by Date (Oldest First)
4759 days ago
4763 days ago
4818 days ago
4825 days ago
4855 days ago
4870 days ago
4883 days ago
4888 days ago
4909 days ago
4909 days ago
Elegant Web Application PART1 [3]
stack thought
4939 days ago

This is the 1st of a multi-part series describing, in details, how
to create an elegant web application using php and mysql. I say ‘elegant’ because there are many ways to create a web app in php, many of which are ‘hackish’.

In this first part, I will explain how to set up all the tools you’ll need to create a proper development enviroment on your computer. This tutorial assumes that you have medium-high level of familiarity with concepts related to databases and programming languages.

To illustrate this tutorial, I will use a real-world example; an old web application I created when I first started programming in php. (more on this later on.) I will use knowledge and
experience acquired since then to recode from scratch the web app and come up with a solution which is more flexible, robust and elegant. These are the 3 criteria I will use at the end of this tutorial to assess whether of not this project has been successful.

/////////////////
Assumptions
////////////////
I will also assume you are running Windows XP pro or better. If you are running something else, such as OS X or Linux, then, I will assume that you are capable of installing php and mysql without any further instruction.

These are the things you’ll need to set up:

1. IIS
2. PHP
3. MySQL
4. PHP Editor

//////
IIS
/////
IIS may already be running on your computer. To check, go to Control Panel -> Administrative Tools -> Internet Information Services). If you can’t find IIS, you’ll need to install it by going here: Control Panel -> Add/Remove Programs -> Add/Remove Windows Components -> Internet Information Services.

//////////
MySQL
//////////
Download MySQL (Windows Essentials)
Download MySQL Administrator

Install MySQL, using all the default settings in the installer.
Install MySQL administrator using the default settings as well.

After both have been installed, try to use MySQL administrator to connect to MySQL, create a database user, create a database, and assign all permissions for the database to that user.

///////
PHP
//////
Download PHP (PHP 5 installer)
Download phpMyAdmin

1.Install PHP using the default settings in the installer.
2.Create a folder in C:inetputwwwroot called “phpmyadmin” and extract all the phpMyAdmin files there.
3.In IIS, create a new virtual directory called phpmyadmin and point it to that folder.
4.Edit your php.ini file (in C:Windows) by making the following changes:

a) configure the path to your extension folder
b) enable the mysql extension.

5. Edit the phpMyAdmin config file so that it can connect to your database. (Fill in your mysql host, username and password)

////////////////////////////////
Post-Installation checkllist
///////////////////////////////
Here are some things you should check before you read “Elegant Web Application PART2

1. Check that your local web server and php are running. To do so, place a php file with phpinfo() in the home directory for IIS and try to access it. You should see information related to your PHP installation.

2. Make sure you can connect/insert/remove data to the database through phpMyAdmin

End of part 1.