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!!!

Watch sample video

Go back

This short video tutorial explains how to replace part of the string in MySQL database. Try to imaging situation where you have a large number of records and say - the path to images folder on the server has been changed. All of the paths to the images in the content of the pages would be incorrect and would display a "broken image". The easy fix for all this is to use MySQL REPLACE() function. This tutorial explains how to use it to replace any part of string using this function.

• 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

First name: Last name: Email address: