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

Understanding MySQL for PHP is the new series of videos where I'm explaining what MySQL is and how to use it to create your own database. Every week we will be publishing the new video to add to this series. This videos will give you a solid understanding of the databases and how to use them to store and retrieve the relevant information. You will learn about the database structure, different types of tables, different data types, how to store records in separate tables and refer to them using relationships, how to interact with the data using different SQL statements and much more...

 
  • Understanding MySQL for PHP
  • Introduction
  • MySQL and databases in general (03:28)
  • Watch
  •  
  • Things to remember (05:04)
  • Watch
  •  
  • Creating database
  • Relationship types overview (05:23)
  • Watch
  •  
  • New database and first table (07:13)
  • Watch
  •  
  • Lookup tables (04:55)
  • Watch
  •  
  • Joint table (04:48)
  • Watch
  •  
  • Lookup table relationship definition (03:41)
  • Watch
  •  
  • Joint table relationship definition (02:24)
  • Watch
  •  
  • Interacting with MySQL using phpMyAdmin
  • Adding records to the tables (08:04)
  • Watch
  •  
  • Updating records (05:11)
  • Watch
  •  
  • Using Search (08:16)
  • Watch
  •  
 
  • 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