Your way of teaching is awesome for a beginner, you have mentioned that be careful for big database or huge data, kindly teach us or put new video for optimization for the above video for huge database.
Had to make some changes on the code downloaded, and replaced with the one from the working one on your website .. Question: All records are showing on the page , and when type it refines from that list... I would like to see onlye the data I am searching for and not all that data under the search area ... What code should be changed to prevent all that data from showing there . Thanks in advance
your tutorial too much good. but i have humble request please upload videos with clear voice. it's being break.i hope u will accept my small request.love from india
If I wanted to limit where the search is done like "SELECT * FROM example WHERE username='anything'", even with the where clause on the fetch page it searches the whole database
May I ask a question? How I can make in one search field so that it will search many fields in it? For example name surname address and etc. in one field?
Hi, is there a way I can only search, fetch and display data from the index page? I made a CRUD system and used your coding but it displays data straight from mysql. It can still be connected to mysql but I just need the search engine to get data within the index page.
How can this code be modified so that if the search box is empty, no results are shown? The problem for me is if the search box is empty, all data from the database is displayed.
Nice one. But while typing customer name first it will show the entire database content then it will show the particular customer name. Without showing entire database how can i fetch only the particular customer?? Please anyone help me.
How can i do this task : Basically i have 3 tables; Admin, Company and Leads. Against these tables some fiels are there. In company table i(admin) add 10 companies. Means i have added 10 different companies and each company have their own leads. If i logged in from any company then against that company their leads appear(shown). Than i want to apply AJAX LIVE Search on Leads Table on STATUS Field. STATUS are(New,Pending,Progress and Approved). What can i do That i get that specific company id Which is Logged in. And against that company their leads appear and in leads table i search status=New on (Search Bar) than aginst that data must be shown and same like Status=approved,pending,progress.. Can anyone Help me.
your video is awesome but i still have a worry ...my code works just that when i enter a name to nothing shows instead the result displays when i cancel the input name
this is very help full but Every tutorial you are using $Output variable and con cating with others are the other idea to use something like that. i have confused.
Sir thanks for this tutorial this is very helpful. Its work to me but i have a problem because for this Notice: Undefined index: search in C:\xampp\htdocs\searchajax\fetch.php on line 4. sir please help i need it for our thesis. Thanks
i love you so much.. coz only for your tutorial my 2 weeks pending work is done.. i make outstanding search.. love your tutorials..
Thanks Rida...
it still works in 2021. you guys are awesome! thank you so much.
Thank you! You really helps me!!! I for a long time can't undesrtand with it.
Your way of teaching is awesome for a beginner, you have mentioned that be careful for big database or huge data, kindly teach us or put new video for optimization for the above video for huge database.
Amazing I was madly searching for 3-4 days for this.. finally this solved my doubts
Nailed it the first shot!!! thanks for the code. I even got some nice functions working within it. Thank you for helping me upgrade my StoreCore app.
Party game: drink a shot whenever she says "Friends"!
Awesome...!!!!
Works perfectly, although written in 2016, it still works in 2020!!!!
I love your videos. It would be even better if one can hear your voice but the content of your videos is excellent! Keep it up!
Hi Tom, Thank you for your loving words.
Thank you for this tutorial. It is VERY USEFUL and appreciate you sharing your knowledge. Keep up the good work.
Thankyou👍I want to search combination of 2 column values.. Please reply
Very Helpful tutorial !!!!
You're definitely Indian haha. I can tell because you say "Now friends, we...." when explaining. Much thanks though, it helped a lot
Had to make some changes on the code downloaded, and replaced with the one from the working one on your website ..
Question:
All records are showing on the page , and when type it refines from that list... I would like to see onlye the data I am searching for and not all that data under the search area ...
What code should be changed to prevent all that data from showing there .
Thanks in advance
Thanks, You're Awesome! I've been looking for a simpler way to sort my sql table and its perfect.
Very helpful, Thank you...Could I ask if there is any way to make the first row of the table sticky below any navigation bar?
Thank you!!!😀
Fantastic Thanks
awesome, great man
your tutorial too much good. but i have humble request please upload videos with clear voice. it's being break.i hope u will accept my small request.love from india
abbe indian hi hai yeh banda
Thank you for the tutorial
So helpful! Thanks a million!
Great 👍 awesome 😀👍
Just what I was looking for. Thank you.
Thanks Gloire...
If I wanted to limit where the search is done like "SELECT * FROM example WHERE username='anything'", even with the where clause on the fetch page it searches the whole database
you can limit by adding "SELECT * FROM example WHERE username='anything' LIMIT 10" and this will display 10 rows only
thanks it help me
Thank you madam
Thanks for helping me..This video is very useful.
Thansk Abu..
nice tutorial, tks a lot
its nice to understand and good one. thanks bt instead of copy paste, if u r all the code then that would be far better....
thank you sooo much!!!
If I type in text bar it's not fetching the data mam I combined this with my crud application in python flask with mysql
Hey thanks for the presentation. Can I have more than one of these search bars on a page, but have them execute different queries?
sure. just create 2 different isset statements on your php file
@@clusterdriven you are out of context,isset is not an option when using ajax as in the video
Thanks!!! Helped a lot for my project
Really nice and bug free tutorial
merci bcp ce tuto m'a bcp aidé
👍 Nice
May I ask a question? How I can make in one search field so that it will search many fields in it? For example name surname address and etc. in one field?
thank u for share u r knowledge to us...
Very helpful tutorial, thank you!
hi guys, do you have any idea how can we show the default db before the user typed in the search textbox?
thanks a lot :)
Hi, is there a way I can only search, fetch and display data from the index page? I made a CRUD system and used your coding but it displays data straight from mysql. It can still be connected to mysql but I just need the search engine to get data within the index page.
Wow...i love this video😍
how can we add highlight to the search result keyword in search?
Hi, is there anyway to have the table appear before you enter anything into the search box
How can this code be modified so that if the search box is empty, no results are shown? The problem for me is if the search box is empty, all data from the database is displayed.
nice tutorial
Thank You So much.
how to pass multiple numaric variables in data of ajax like employee id and skill id etc....?
nice, thx so much
Thank you so much you are really a life saver >.
Nice one. But while typing customer name first it will show the entire database content then it will show the particular customer name. Without showing entire database how can i fetch only the particular customer?? Please anyone help me.
This search is not working in cakephp 3 framework . How to use it there in cakephp 3 framework?
working perfect...
How can i do this task :
Basically i have 3 tables;
Admin, Company and Leads.
Against these tables some fiels are there.
In company table i(admin) add 10 companies. Means i have added 10 different companies and each company have their own leads.
If i logged in from any company then against that company their leads appear(shown).
Than i want to apply AJAX LIVE Search on Leads Table on STATUS Field.
STATUS are(New,Pending,Progress and Approved).
What can i do That i get that specific company id Which is Logged in.
And against that company their leads appear and in leads table i search status=New on (Search Bar) than aginst that data must be shown and same like Status=approved,pending,progress..
Can anyone Help me.
how can i set when i search data then show data not showing before all data ????
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in
What is the problem ? Please help....
Upon including the join function,it is showing error.how do you go about this?
thank you :)
Thankyou...Working Perfect. :)
dude would you please show me the way in ASP.NET? (Using SQL)
your video is awesome but i still have a worry ...my code works just that when i enter a name to nothing shows instead the result displays when i cancel the input name
also when i enter a non-existant name it still displays
NB:for both cases it displays all the content of my DB table
this is very help full but Every tutorial you are using $Output variable and con cating with others are the other idea to use something like that. i have confused.
I have an issue cause it is loading the table without any input and not detectitng input
thank you so much. it's working :)
thank you so much realy helped me
while searching the name, the page is moved and views are not so clear. Isn't there any solution for it.
What should I do if I don't want it to display before search. I want it to display only after serch
$("form").submit() insted of keyup
thanks!!!!!!!
awsome!!
How to hide data
its a best tutorial,please sent the link of jquery, bootstrap and css library path please
Thanks Ali Kamran. You can use following link
osm
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in
What is the problem ? Please help....
very think you
how do I create this but with ajax modal?
Super!!!
use of search.txt?
hello...sir this is awesome tutorial..but i need master search page ..can u help me
thanks you
thanks
Thanks Nam Le...
Thank you, dude!!!!
its worked fine (y)
If I don't want to show all my data on index, or just show only 10 rows. What do I need to do? Thankss
"select * from yourTable where columnName like '%"$_POST["search"]"%' limit 0,10";
Thank you
it's not working, it shows nothing and when I clear input box it displays all database contents :/
same did you find the solution?
Sir thanks for this tutorial this is very helpful. Its work to me but i have a problem because for this Notice: Undefined index: search in C:\xampp\htdocs\searchajax\fetch.php on line 4. sir please help i need it for our thesis. Thanks
after clearing input box.
the table still remains display all data of database..
easy fix
in 2016.. using mysql without using PDO... seems dirty...
Yea.. it is fucking me all around,, did you found a solution?
What is hard about it? Nothing..
exactly bro
Where to close table tag?
My search bar is not working it show error that Ajax is not a function
Thanx.
Hi Brian Byaruhanga, You're most welcome.
Nice
i want to ask you something...in your code you have src for script!Is necesarry we have these files(bootstrap.js,bootstrap.css,jquery.js)???
if you want jquery.js only, the bootstrap just the for web style.
how can i get jquery.js file
just download from google
that sound sucks , although tutorial is very useful
thx you!!!
is it indian google translator?
Nice one
Oh, thanks Satya Vinay! Always at your service.
Thanks for sharing, how about in asp.net
How can I add name and info using web?
What happens when this is public and someone keeps typing to send 1000's of requests.