Datatables Individual column searching using PHP Ajax Jquery

How to make jquery Datatables individual column search or filter by using PHP script with Ajax. Video tutorial on Datatables individual column filtering at server side using PHP.
For Source and online Demo - www.webslesson....

[@rahmatjo6837]

sir, How to using clausa WHERE ?, i try not work

[@vishwayethorathuru8937]

bro check yor mails plz

[@webslesson]

Hi IM we have check our email and we have reply you on that mail. Thank you for contacting us.

[@vishwayethorathuru8937]

ok brother..your amazing.....

[@deniben1403]

Hello,
Thanks for this good tutorial, but i have a question is it secure in this way to use POST parameters without any protection .
Does us should be afraid from any SQL injection attack using this way the code .
IF yes tell us how we have to secure the post parameters.
Thanks,

[@Nani-he3ls]

can u please added dropdown box to multiple columns i tried but not came getting error. it is only work for one column

[@ifastwp]

How do I put the two functions together?
1- Date Range Search in Datatables
www.webslesson.info/2017/06/date-range-search-in-datatables-using-php-ajax.html
and
2-Datatables Individual column searching using PHP Ajax Jquery
www.webslesson.info/2017/07/datatables-individual-column-searching-using-php-ajax-jquery.html

[@yuslanode1026]

Thanks Very much

[@AlexandrIDK]

Please make video, how possible to make search or filter in columns by input words, like existing search, with input fields under table header or in footer. sample:
column 1: post "firstname" - results 100 lines.
and if
Column 2: post "lastname" - results 38 lines.
and if
column 3: post "date" - results - 1 line.
Or maybe one multi word searching.
example like here datatables.yajrabox.com/eloquent/post-column-search
Thanks for you videos!

[@laurent09500]

Hello
I would like to put a product in several categories at the same time ex: 1.3.6
and just one explode after.
is it possible and comment?

[@thapelomodise1402]

Thanks for such a wonderful tutorial. Is it possible that you atleast make product price as well like category? That would be grateful. Thank you

[@webslesson]

Yes, definitely we can do this things also.

[@jassu78667]

Your codes are so long..Please try to minify your codes that can be easily to understand.. Irritated voice like hammer on mind.

[@RohitVerma-ub6ut]

Thanks for the code. But why my option show duplicate data and when i search it not show. Data Tables Showing Duplicate Pagination And Search Controls

sir please help

[@phpdevelopment]

Very Excellent Video On datatable. Sir Here is one Question. If I am searching and by searching input then data is coming but searched value is disappeared. Provide me solution

Hello
I have a problem.
German chars are having problems.
How to solve the problem.

[@mnunez6153]

please add save as excel, pdf and print option. thanks

[@development7867]

i always like your videos sir you are the king of this platform .. thank you so much sir

[@3Di.]

Hey, If I want to add some products to multiple categories, how to make it?

[@heidimitchum705]

I am using this with sql server and not mysql i am getting results in dropdown but my table data is not changing. any idea

[@StandaloneDeveloper]

Another question that if i want to make this filter as you have shown in this tutorial on different columns like brand type color price so i can get the filtered results?Thanks from ITALY :)

[@webslesson]

Nice question Sandro, yes you can put this type of drop down at any table, just you have to write some code at font end and back end for particular table which we have write for category column in this video tutorial.

[@farahatiqah5657]

Thanks for the code. But why my option show duplicate data and when i search it not show. pls help :{

[@tejasgokani]

Thanks a lot!. In just 20 minutes i learned many things... Awesome.

[@webslesson]

It's My pleasure, Tejaz Gokani.

[@sevinunu]

Sir! you are my hero! i was extremely stuck in a same task on the job!! great work! i already subscribed:-) question: 1)any chance to use your normal voice? it would be nore understandable
2) is there any tutorial to link results to a chart for display( example: sales region, sales amount then filter by date or date range)
3) it would be great if you could explain, what if multiple users work onnthe same data entry simultaneously.. is it a conflict? how to prevent it?
4) can we get a kinf of login to use that table and record the current data row editor's login name and time?
BEST regards from Germany! and please keep on posting you great work!Thank you!

[@takundamafuta7355]

Thank you. How can I do this on multiple columns?

[@devjoaolucas]

your tutorial saving my code hhahaha

[@4seth]

Source and online demo are no longer available. Is there an alternative?

[@amarmoufti1575]

Pleaaaase make some fullCalendarjs javascript plugin tutorials...
Its so important and great

[@eliasdegu2175]

DataTables warning: table id=product_data - Invalid JSON response. it me give me an error like this wat can i do ???

[@thapelomodise1402]

refer to datatables.net

[@yamaha4651]

Just genius,,, sir,,, very nice tutorial .... u rock.....but one request ....if it is ur own voice .,,it would be too great.... possible pls try in your next videos

[@webslesson]

Thank you for making our day with your kind words! Thank you for recognizing our efforts!

[@webdesigninspire1372]

thank you i like your videos

[@StandaloneDeveloper]

Thank you so much for another fantastic tutorial.I have seen almost all the videos about php on your youtube channel and thanks again for sharing these professional skills but i will be very grateful to you if you make a series also on making invoices with php and on dependent dropdown list search. Thanks

[@webslesson]

Thank you Sandro for making our day with your kind words! Thank you for recognizing our efforts!

[@wt11556]

can I know how to add another column I kept having invalid JSon response when i add another column of data

[@webslesson]

You should one more column in Jquery Datatable() method also and in PHP code also, then after this error will not come.

[@neelsfer]

"Show All Entries" in the top left corner has a "json error" if you select it.. Otherwise it works great

[@webslesson]

Thanks CJF, We will look into that

[@willonedision]

useful jquary function and thanks for your sharing~~~good job sir

[@webslesson]

Thank you Wu Josh for writing to us. We appreciate your valuable feedback..

[@theheavydata8126]

the best tutorials I have ever seen. great work.

[@yuslanld7956]

thanks sir.

[@amarmoufti1575]

Pleaaaase make some fullCalendarjs javascript plugin tutorials...
Its so important and great

[@webslesson]

Hi Amar Moufi, Thanks we will make video tutorial on this topic also very soon.

[@amarmoufti1575]

Webslesson thannnnks

[@abdulrehmanhassni4525]

Thank you So Much

[@danielmaricelmunteanu5059]

You're magnificent. I learned a lot and thank to you..

[@webslesson]

Thank you Daniel Maricel Munteanu for your loving words.

[@mariusmihailionte3359]

thank you very much for your great tutorials

[@webslesson]

Thank Marius Mihai Lionte you for your kind words.

[@angdaro7727]

nice

[@cesarvasquezestrada2348]

Great tutorial..

[@ikramhaider]

thanks man.. you are great :)

[@webslesson]

Thank you Ikram Haider for your kind words.

[@in-f1ux]

Your tutorials are invaluable!

[@webslesson]

Thank you Influx for your friendly words.

[@hoanghieuthao8866]

thank (y)

[@webslesson]

Oh, thank you Hoang Nam Nguyen! Always at your service.