This series of the videos explains how to create Photo Gallery using PHP, MySQL, ImageMagic and jQuery. Using PHP you will be able to add, modify and populate data stored on the MySQL Database and display records of all images on the page. ImageMagic will help us to resize and crop images to the relevant dimentions, while jQuery will provide the support in the presentation of the gallery. The last two chapters are dedicated to adding the earlier created gallery to our Content Management System. Over 4 hours of videos!!!

Other tutorials

 
  • Install Apache, PHP and MySQL on Windows XP
  • Installing MySQL Database Server on Windows XP

Go to your desktop and inside the folder you have initially created find file mysql-5.0.41.win32.zip. Extract the content of this file to the same folder on the desktop. Now go inside mysql-5.0.41-win32 folder and double click Setup.exe. Follow the steps:

Installing MySQL Step 1
Fig. 18 - Click next.

Installing MySQL Step 2
Fig. 19 - Select Custom and click next.

Installing MySQL Step 3
Fig. 20 - Click Change button to change the path of the installation.

Installing MySQL Step 4
Fig. 21 - Navigate to C:\webserver\mysql and click OK, then click next.

Installing MySQL Step 5
Fig. 22 - Click Install to start installation.

Installing MySQL Step 6
Fig. 23 - During installation a new window will pop up introducing MySQL Enterprise. Simply click next twice to continue with your installation.

Installing MySQL Step 7
Fig. 24 - Your installation is finished. You are now ready to configure your MySQL Server. Click Finish to start configuration.

MySQL Configuration

MySQL Configuration Step 1
Fig. 25 - On the first screen click next.

MySQL Configuration Step 2
Fig. 26 - Select Detailed Configuration and click next.

MySQL Configuration Step 3
Fig. 27 - Select Developer Machine and click next.

MySQL Configuration Step 4
Fig. 28 - Select Multifunctional Database and click next.

MySQL Configuration Step 5
Fig. 29 - Leave everything as default and click next.

MySQL Configuration Step 6
Fig. 30 - Select Decision Support (DSS)/OLAP and click next.

MySQL Configuration Step 7
Fig. 31 - Leave two options checked and port number as 3306 and click next.

MySQL Configuration Step 8
Fig. 32 - Select Standard character Set and click next.

MySQL Configuration Step 9
Fig. 33 - Select Include Bin Directory in Windows PATH and leave other options as default. Click next.

MySQL Configuration Step 10
Fig. 34 - Tick Modify Security Settings and type in a password you want to use to access MySQL server, then click next.

MySQL Configuration Step 11
Fig. 35 - Click Execute to apply configuration settings.

MySQL Configuration Step 12
Fig. 36

Click Finish to exit configuration wizard.

The last thing you need to do is to open php.ini file located in C:\webserver\php and uncomment the line extension=php_mysql.dll by removing semicolon ; at the beginning. Save the file and close it. Restart the computer.

This way you have completed your installation and you are now ready to start developing your web applications using Apache, PHP and MySQL.
Good Luck!

<< Installing PHP

 
  • Thank you for subscribing to our newsletter.
  • To complete registration please click on the link in the email which has been sent to you.
  • Invalid first name
  • Invalid last name
  • Invalid email address

Website Design Company | Website Design Company Sussex | Website Design Company Chichester | Website Design Packages | Tutorials Resources | Articles | Contact
© Web Design Tutorials – Sebastian Sulinski