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

PHP tutorials

This tutorial explains how to create the advanced search form for your website with PHP and MySQL using text fields, dropdown menus, radio buttons and check boxes. You will learn how to create database, how to define relationships between different tables and how to create search form which populates relevant information from the database and displays then on the page depending on selection made. You'll learn how to create the complex SLECT Sql statement which includes function, JOINs etc.

 
  • Advanced search form for your website with PHP and MySQL
  • Price: £38.00
  • Buy now
  •  
  • Introduction
  • What we are going to be building (00:40)
  • Watch
  •  
  • Building database
  • Database and lookup tables (07:40)
  • Watch
  •  
  • Joint tables (03:12)
  • Watch
  •  
  • Understanding relationships between the tables (03:20)
  • Watch
  •  
  • Lookup table relationship (03:09)
  •  
  • Joint table relationships (04:01)
  •  
  • Importing records (01:06)
  •  
  • Layout
  • Structure of the page (03:28)
  •  
  • Form structure (06:09)
  •  
  • Labels and input tags (03:32)
  •  
  • Functions
  • Database connection (03:37)
  •  
  • Languages dropdown menu function (09:37)
  •  
  • Authors, Categories and Years functions (05:36)
  •  
  • Displaying radio buttons function (04:49)
  •  
  • Multi select check boxes function (05:35)
  •  
  • Sticky form fields function for multiple form elements (06:32)
  •  
  • Applying sticky form fields to all functions (07:29)
  •  
  • Default selection for radio button (03:08)
  •  
  • Displaying results
  • Results table (02:27)
  •  
  • Populate records using JOIN statement (09:10)
  •  
  • Displaying results using DO { } WHILE loop (04:23)
  •  
  • Preparing URL parameters for processing (09:04)
  •  
  • Putting queries into arrays (09:57)
  •  
  • WHERE statement (05:22)
  •  
  • Displaying messages (03:39)
  •  
 
  • 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 | Vector
© Web Design Tutorials – Sebastian Sulinski