Over a million developers have joined DZone.
Platinum Partner

MySQL PHP search: four-part video tutorial series

· Web Dev Zone

The Web Dev Zone is brought to you in partnership with Mendix.  Discover how IT departments looking for ways to keep up with demand for business apps has caused a new breed of developers to surface - the Rapid Application Developer.

Fresh from Adam Khoury's massive library of instructional videos comes a four-part, full-fledged tutorial on searching a MySQL database using PHP.

The tutorials use the 'worked example' format (like Khan Academy), which makes learning relatively painless for newbies and not completely useless for more experienced developers.

Adam lists the specifics in his YouTube video description:

MySQL PHP Search Programming Exercises for database driven web sites. Search pages that allow advanced targeting and filtering of information. Learn to build HTML Search Forms and Advanced Search Filters, Various MySQL Search Query Methods, Joined Table Queries Targeting Multiple Tables, Natural Language Full-Text Search Queries, Boolean Full-Text Search Queries and discuss fine tuning your search programming and adjusting search parameters.

You can watch the four-part series directly below, or check out his website for tutorials on other subjects (including more PHP).

Part 1: Create and Populate Example Tables Script

Part 2: Build the HTML Search Form with Filter List

Part 3: SQL LIKE Syntax UNION and AS Alias with Filters Tutorial

Part 4: SQL MATCH AGAINST Fulltext Search Syntax UNION Tutorial

The Web Dev Zone is brought to you in partnership with Mendix.  Learn more about The Essentials of Digital Innovation and how it needs to be at the heart of every organization.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}