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:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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