Scroll page back to the top

Photo Gallery with PHP, MySQL, ImageMagick and jQuery

Photo Gallery with PHP, MySQL, ImageMagick and jQuery

This series of the videos explains how to create Photo Gallery using PHP, MySQL, ImageMagick 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.

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

Time: 260:54 min / Price: £64.49

Sebastian Sulinski on 18th Dec 2009

Add to the basket
 

Introduction

Watch now!

What we are going to be building (03:50 min)

 

Preparation

Watch now!

Folders and files (07:32 min)

 
Watch now!

Database structure and connection (03:43 min)

 
Watch now!

Pages (04:13 min)

 

Categories

Watch now!

New category form (07:48 min)

 
Watch now!

Duplicate record function (07:17 min)

 
Watch now!

Form validation (04:28 min)

 
Watch now!

Insert record (04:10 min)

 
Watch now!

Display records (06:45 min)

 
Watch now!

Total number of images (02:36 min)

 
Watch now!

Remove category (12:24 min)

 
Watch now!

Edit category (07:45 min)

 
Watch now!

Link to images (02:15 min)

 

Images

Watch now!

Image forms (06:25 min)

 
Watch now!

Display images (09:10 min)

 
Watch now!

Constants (07:07 min)

 
Watch now!

Image paths (04:05 min)

 
Watch now!

Upload form validation (09:09 min)

 
Watch now!

Display validation (04:17 min)

 
Watch now!

Renaming and uploading file (07:24 min)

 
Watch now!

Resizing and Cropping with ImageMagick (10:03 min)

 
Watch now!

Insert record to database (10:32 min)

 
Watch now!

Lightbox preview with jQuery (05:42 min)

 
Watch now!

Remove images (08:32 min)

 
Watch now!

Update display order (08:11 min)

 
Watch now!

Remove assigned images (04:45 min)

 

CMS Structure

Watch now!

Header and footer (10:32 min)

 
Watch now!

Navigation (04:39 min)

 
Watch now!

Redundant code (09:32 min)

 
Watch now!

Active button (02:30 min)

 
Watch now!

Login page and password encryption (06:39 min)

 
Watch now!

Restrict access function (02:34 min)

 
Watch now!

Tidying up (08:25 min)

 
Watch now!

Email and password (01:22 min)

 

Adding Gallery

Watch now!

Folders, files and database import (02:23 min)

 
Watch now!

Link to gallery (02:49 min)

 
Watch now!

Categories page (06:59 min)

 
Watch now!

Remove category (01:21 min)

 
Watch now!

Edit category (02:23 min)

 
Watch now!

Images page (04:58 min)

 
Watch now!

Front end - gallery page (08:15 min)

 
Watch now!

List of categories (05:17 min)

 
Watch now!

List of images (08:57 min)

 
Watch now!

Final testing and amendments (09:11 min)

 
 
 
 

Discussion (4 comments)

  • Michiel

    Michiel on Saturday, 19th November 2011

    I would like to buy this script but I have 1 problem. Is it possible to upload multiple images at one time?
    If this is possible I will buy the script immediately.

    Reply

  • Sebastian Sulinski

    Sebastian Sulinski : @designtutorials on Saturday, 19th November 2011

    Hi Michiel,
    This tutorial only shows how to upload one image at a time.

    Reply

  • Maxime Trudel

    Maxime Trudel : @pingouincrea on Saturday, 25th February 2012

    Great tutorial,

    I have a question, is there any other function we can use except the exec($convert) to execute ImageMagick commands?

    This function has been disabled by my hosting. They fear some security issues and they don't want to unlock it.

    Reply

  • Sebastian Sulinski

    Sebastian Sulinski : @designtutorials on Saturday, 25th February 2012

    Hi Maxime,
    You can also try system() or passthru() functions, but the best thing would be to ask your host, which functions that enable you to execute an external program are enabled on the server so that you don't waste time trying. Also - it is probably a good idea to tell them what you need it for - if they have ImageMagick installed then there must be at least one function that allows executing its commands.

    Reply

 
 
Add a comment
Add Comment