2. MySQL PHP Search Programming : Build the HTML Search Form with Filter List

Part 2 of 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.

[Benyamable]

Adam, i'm from Ethiopia, Africa, you have helped me a lot, i've been looking for this tutorial all over, now i'm getting it from the best, Thank You, God bless You

[GamingJediPwns]

This dude is both brilliant and funny.

[MrShawnlloyd]

advanced querying is a great topic for a tut, nice work

[patty]

Oh, and the variable that needs to be defined is on line 21, in /Applications/XAMPP/xamppfiles­/htdocs/CollectYourOwn/index.p­hp, as it told you.

[jaisvi]

nice information has shared this video. thanks

[Zevanescence]

I like this dude, he is hilarious, I just like to listen to his talk..DUDE YOU ARE AWESOME .lol

[messan]

Adam, thanks very much for coming out with this tutorial. But by the way, What is the best way to become a PHP programmer?

[timekacobb]

This maybe a silly question but do you need to code in extra pages so that the results can show up when someone uses it? Thank you :)

[ConorJMagic]

I had typed out up to video 3 letter for letter, and kept getting an error so I copy and pasted your code but I keep getting the notice
Notice: Undefined variable: sqlCommand in on line 21
Query was empty

[guymerritt]

I've got the gurus at DevShed forums helping me with this - and the can't find the problem. I've tested it on Scientific Linux (Redhat, basically) and IIS 7 on server 2008. The search results are messed up. On Linux it was PHP 5.3.5, and, on IIS 7 it was PHP 5.2.9. Something is not right with this thing.... It returns ZERO results for some data which is in the database. Why...? I have no idea.

[guymerritt]

For some reason I did all of the initial steps but my searches behave oddly - for instance, searching for "Disney" (and a lot of other words that are absolutely in the database - I'm looking at them in a shell, form the command line) return nothing. If I search for other things (eg. "blah", "Bird", "Flash", etc.) they return the appropriate results. I'm using PHP 5.3.5 and MySQL 5.5.8. Anyone have a clue as to why this would act up like this...?

[guymerritt]

And what's really odd - referring to my post, below - it that if I do this from a command line:

SELECT id, blog_title AS title FROM blog WHERE blog_title LIKE '%disney%' OR blog_body LIKE '%disney%';

..it shows the correct result.

[tomislavperkovic]

isset and then checking is empty string coul be replaced with !empty

[Elite_Top_Picks]

Sir this is little bit similar to my college project
...sir I want next remaining programming pls send me the next video link

[beck]

do you know if hes using dreamweaver cs6?

[stepshashaydy]

There is also "Sublime", "Brackets" :)

[stepshashaydy]

He is using Adobe Dreamweaver, I quite like notepad++ but if you are looking more for something appealing for the eye, have a look at "sublime", "brackets", "aptana".
Adobe Dreamweaver is not free.

[elpadrone]

whats the program he is using at this tutorial?

[beck]

I use notepadd++ but yours looks easier

[LeoTM]

No need for form action, will default to self.