MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Advanced search form with PHP and MySQL

Course Summary

Learn how to create an advanced search form with PHP and MySQL

  • +

    Course Syllabus

    • Introduction
      • What we are going to be building
    • Building database
      • Database and lookup tables
      • Joint tables
      • Understanding relationships between the tables
      • Lookup table relationship
      • Joint table relationships
      • Importing records
    • Layout
      • Structure of the page
      • Form structure
      • Labels and input tags
    • Functions
      • Database connection
      • Languages dropdown menu function
      • Authors, Categories and Years functions
      • Displaying radio buttons function
      • Multi select check boxes function
      • Sticky form fields function for multiple form elements
      • Applying sticky form fields to all functions
      • Default selection for radio button
    • Displaying results
      • Results table
      • Populate records using JOIN statement
      • Displaying results using DO { } WHILE loop
      • Preparing URL parameters for processing
      • Putting queries into arrays
      • WHERE statement
      • Displaying messages
    • Conclusion
      • Project summary

Course Fee:
USD 120

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top