Basic PHP & MySQL Searching

Official site

Twitter

[codecourse]

Manolis Agkopian We have one coming up very soon :)

[anthonymalabanan]

thank you so much, it was very informational... good job!

[johngeromego]

thank you for this tutorial it helps me a lot :)

[alextreddenick]

Brilliant tutorial, is there a way linking the results to a page that displays just that article. So when the user clicks on the result it takes you to a page that has the full article?

[davidwang]

Thank you very much for the tutorial, helped me with my college assignment.

[ThaoTran-lznl]

Thank you so much, it's useful for our PHP final project

[zareenremendies]

Thank you very much for the tutorial,

[madhavparikh]

Thank you so much. Much appreciate. :)

[romosa]

Thanks man. Really helped me. Keep up! Subscribed!

[SahidulIslam-tztm]

What algorithm is used here(I mean like binary search, depth first search etc)? I want to know the algorithm. Thanks

[ichkerim]

Hi Alex, i'd like to know how PHP Search function works?
In CMSs like WordPress it searches specified text or an item, but when developing a website from the scratch
How does it really work? does it scan the specified text in an every single page or what?
Thanks

[moneymayhem]

Awesome video. Could do you do one on 'scaling'? i.e The theory and best practices?

[bensiu]

thx for the teaching, also i like to ask some questions, how to fix the problem if it tells me Notice: Undefined variable: db in line 3 and Fatal error: Uncaught Error: Call to a member function escape_string() on null
here is my code :
1 <?php
2 if(isset($_GET['keywords'])){
3 $keywords =
4 $query = $db->query("
5 SELECT game
6 FROM gamedb
7 WHERE gName LIKE'%{$keywords}%'
8 or gid LIKE'%{$keywords}%'
9 ");
10 ?>

[akeemliburd]

I have a database table with records from 2007. It already contains 4000+ records and I will be adding records up to the current data. what would be the best technique to do searches on such a large database?

[LukasLindner]

is the name of the program where you manage your MySQL Databases? ;)

[Djangokillen]

He uses Sequal Pro to handle his databases in case anyone wonders.

[alisheryerkimbekov]

Thanks man. i have a question. What is name of Mysql app for mac?

[romosa]

I've tried to make another column for tags. For example shape_tags.
So if I search circle rectangle it will show all items that has shape of circle and rectangle.
But it shows no result.

Found 0 results.

Any ideas how to make it work? Thanks!

[dancostinel]

What about a different type of search, like giving up that "search" submit-button, and having only that search-box? And once you type something in it, the results are returned instantly. Can be done with <input type="text" name="keywords" onchange="this.form.submit()" autocomplete="off">?

[antonigalon]

How can I build tidy MySQL 'SELECT' query when number of selection criteria changes?