John Esposito edits Refcardz at DZone, while writing a dissertation on ancient Greek philosophy and raising two cats. In a previous life he was a database developer and network administrator. John is a DZone Zone Leader and has posted 331 posts at DZone. You can read more from them at their website. View Full User Profile

MySQL PHP search: four-part video tutorial series

10.28.2011
| 6992 views |
  • submit to reddit

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


Comments

Yaron Levy replied on Mon, 2012/06/11 - 1:06pm

A large number of sites run PHP as either an Apache module through mod_php or using php-fpm under nginx. Neither of these setups are vulnerable to this. Straight shebang-style CGI also does not appear to be vulnerable.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.