What's wrong with this tutorial? (Auto complete)

JavaScript
1

Hello,

I tried this tutorial,
http://www.danielrosca.ro/blog/en/codeigniter-autocomplete/

The problem is when you type a name in the input box.
All names in the columns in the DB are called/displayed.
I isolated and tested the LIKE logic in the SQL and it works fine.
But when I follow this tutorial, All names in the columns in the DB are called/displayed.

Also another problem is it won’t update the suggested list instantly, when you change the word you type
in the input box.

Any suggestion please for these two problems.

Thanks in advance.

2

I guess the jQuery codes are not complete.
I’ll try to re-code it from scratch.