forget it!...i see all comments and this tutorial is not for copy-paste, you've to do it!, for understand it., it works fennomenal, congrats all weblesson team!!!
You have done a great tutorial. It's easy to understand, functional and you have post the example code. I will try to apply the order, filter and pagination in every fetchdata sended. Thank you for your great work. You are a very good teacher.
Hi, how to insert and Add html Row after I search from mysql? What I mean is like a Point of Sale interface, where I scan the barcode then output will add and insert as row and I am still able to edit the quantities before I save it to the database. Please advise thank you. :)
Hello this works grat, and I've used it in my project. But now I want to implement row color based on table data using rowcallback but i can't make it work. Could you please help me. Thank you in advance.
i followed, copied and did applicable changes but this update.php just doesn't know the id value! it says the error is undefined index id on update.php when isset is negated, otherwise no succes update message. I copied the url links just to ensure the correctness...I check the update.php and index.php but still the code just won't update. I'm stuck. I've reviewed already many times. I tried other browsers, checked the syntax letter by letter but still to no avail. Could it be that my Php version is the culprit? my Php is 7.4.1. Pls. help!
There is example code on the PHP website: www.php.net/manual/en/pdo.construct.php Or is there anything you don't understand about it? But it's a good point. The code in this tutorial is all very outdated. You will be open to SQL injection attacks if you use this php code. It's much much much better to use a PDO with prepared statements, so that your code is database agnostic and safe from injection attacks. Your code should not know whether it's talking to MySQL, Oracle, MSSQL or PostgreSQL. That way you can easily go from one database type to another, without rewriting all of your code. Learning the javascript/ajax calls is very helpful, but please don't write the backend like this. Use a PDO instead.
Sir i want this search to work ... Like how it works on HTML where if you input "tom" it will search on all columns... And if you write "tom cruise" it will search on all columns and also "tom" and "cruise" are searched as two strings how to achieve this??
Hi! Could you advise me how I can add inline autocomplete data retrieved from database (using PHP & MySQL)? Do I need to buy the license for Datatables Editor in order to do this? thanks!!
Thank you sharing for this valuable tutorial. Can you suggest how can add excel/pdf export button for export this table. Also need drop down list from another table one or more row.
Very nice and helpful, but i have a problem in my "setup"... i have some UTF-8 characters, and it gets stuck and displays error when they are used. (Characters like : ä ü õ etc). Any ideas how to fix it? tryed to edit fetch_data with Json encoding etc, but did not me help very far :(
Dear sir: Could you share a method with edit and save buttons to update the row contents not the whole tables? That means when i click the edit button then i can edit this row, and then i can save it. Thank you so much!
?????????? Hello Sir , Am having a littel problem here , My problem is that i want to add more columns to this dataTable, How can i edit the code inside to add more columns and also i want to know how to edit the columns size, Thank you very much, I think i will be the biggest follower for you
Sir, this is nice tutorial. But there are some nice libraries for editable table and one of them is the JQXgrid.. can you create a tutorial for that using codeigniter framework. thanks
Hi Mohamed Nassar, In our latest video tutorial on Datatables in which we have use two tables as per your requirement. Please check 'Datatables Individual column searching using PHP Ajax Jquery ' this video tutorial, you can find which you wanted..
this problem occurs when your field names in MySQL table don't match declared variables in your php codes. Also the sequence they follow which are in database like: id, name, email you may say in your php codes: id, email, name.
In my apache error log. There is an error which is :PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\\xampp\\htdocs\\fetch.php on line 52, referer: localhost/index.php Can you please help me to solve this?
hallo sir, i still learning about insert data in bootstrap.. i have tried with your source code, but i found an error "DataTables warning: table id=example - Ajax error. For more information about this error, please see datatables.net/tn/7" how to fix it ? thanks
hello sir. why i can get error in this code : if($_POST["length"] != -1) { $query1 = 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length']; } error message: DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
i have this error also error message: DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
why i have this error? DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
I had created the table myself with the same exact ids. This time i deleted it and just used his sql code to create the table on phpmyadmin and it worked
how to solve the DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1? error please give me hand
forget it!...i see all comments and this tutorial is not for copy-paste, you've to do it!, for understand it., it works fennomenal, congrats all weblesson team!!!
You have done a great tutorial. It's easy to understand, functional and you have post the example code. I will try to apply the order, filter and pagination in every fetchdata sended. Thank you for your great work. You are a very good teacher.
One of the best robot voice tutorials
You are the great man, helped me lot, thanks
can i add validations on columns in data tables? like for email and phone no.
Ohhhh!!!! weblesson i don't know how to thank ......the source code best solution for spelling error
Can we do it with pure javascript ?
Nicest Tutorial, many thanks Sir
nice tutorial, i like it, thanks bro.
so thanks for this sir ....its a perfect and simple code with great use
Thank you, great tutorial. I like how you broke the whole codes into manageable function which call a file to do a particular task. thanks again
hi.is it possible to add listbox which is populating from db, in a row, instead of textbox ?
your tutorial just save my day thank
Great! I likes your video.
How to Fetch data with where Clause in this code
great tutorial thank you !
thanks jarvis
Thanks for the video. If I change id to id_hospital, which part I need to change ? Really sorry for this stupid question.
When you click #add, is it possible to complete the fields with select and customize editable cells? Thank you
Thx for nice tutorial. How about an inline edit table, that can navigate like a spreadsheet down or up, using the arrows on a keyboard.
Good programmer
You rock sir
Can you make tutorial on multitab form processing with next previous buttons?
It says undefinded length,start what mean by please help me
Hi, Why is it not working if I have where clause in this part
$query .= " SELECT * FROM booking"
please reply. Thanks
remove the dot before equal
Hi, how to insert and Add html Row after I search from mysql? What I mean is like a Point of Sale interface, where I scan the barcode then output will add and insert as row and I am still able to edit the quantities before I save it to the database. Please advise thank you. :)
how to use datepicker is same data table please share me i need your help
thank you Sir, your movie perfect work . thank you.. Your video helps me a lot.
how can I add input for the date in that table?
This is awesome!! Keep up the great works!!
How to use datepicker in datatable
Wonderful work!!!
is it possible show how insert simple combobox into each row and create a export excel button?
Hello this works grat, and I've used it in my project. But now I want to implement row color based on table data using rowcallback but i can't make it work. Could you please help me. Thank you in advance.
anyone know how to fix this so that if you edit page 2, youre not sent back to page 1 each time you insert?
Great tutorial, You have a new subscribe .
Is there a way to get the horizontal scroll out?
Thanks for your urgent reply. Wow this work is splendid.
i followed, copied and did applicable changes but this update.php just doesn't know the id value! it says the error is undefined index id on update.php when isset is negated, otherwise no succes update message. I copied the url links just to ensure the correctness...I check the update.php and index.php but still the code just won't update. I'm stuck. I've reviewed already many times. I tried other browsers, checked the syntax letter by letter but still to no avail. Could it be that my Php version is the culprit? my Php is 7.4.1.
Pls. help!
Hello, it is possible to give this code source with connection « new PDO » ???
There is example code on the PHP website: www.php.net/manual/en/pdo.construct.php
Or is there anything you don't understand about it? But it's a good point. The code in this tutorial is all very outdated. You will be open to SQL injection attacks if you use this php code. It's much much much better to use a PDO with prepared statements, so that your code is database agnostic and safe from injection attacks. Your code should not know whether it's talking to MySQL, Oracle, MSSQL or PostgreSQL. That way you can easily go from one database type to another, without rewriting all of your code. Learning the javascript/ajax calls is very helpful, but please don't write the backend like this. Use a PDO instead.
But there is a problem, when there is 2 pages loaded in datatables, when you click the next page and try the button delete it is not working
Kidney touching voice
you are just awesome...sir thank you.....
Sir i want this search to work ... Like how it works on HTML where if you input "tom" it will search on all columns... And if you write "tom cruise" it will search on all columns and also "tom" and "cruise" are searched as two strings how to achieve this??
Hi! Could you advise me how I can add inline autocomplete data retrieved from database (using PHP & MySQL)? Do I need to buy the license for Datatables Editor in order to do this? thanks!!
Alquien sabe como hacer que sea responsiva o que se adapte a la responsividad que proporciona datatable?
I receive "No matching records found" when I first load the page. However, if I filter I receive the data. Is there a reason behind this?
This is good thank you very much. Keep up the great work
please anyone can help me how can i add datepicker in table
Thank you sharing for this valuable tutorial. Can you suggest how can add excel/pdf export button for export this table. Also need drop down list from another table one or more row.
Thank you❤
Very nice and helpful, but i have a problem in my "setup"... i have some UTF-8 characters, and it gets stuck and displays error when they are used. (Characters like : ä ü õ etc). Any ideas how to fix it? tryed to edit fetch_data with Json encoding etc, but did not me help very far :(
I found a problem with datatables javascript script
how to datepicker is same data tableplease share me i need your help
kumar
Hello sir ..Can you please make tutorial , how we can make Folders and upload files in it, Just like Google Drive ...Thanks
Thanks Rizvi, we will make this type of video tutorial. Thanks for your appreciation..
Thank you sir ....
Hi...How to do this in codeigniter???
as usual you are awesome, thanx
very helpful work
Thank you Aqeel kazmi for your friendly words.
Dear sir: Could you share a method with edit and save buttons to update the row contents not the whole tables? That means when i click the edit button then i can edit this row, and then i can save it. Thank you so much!
??????????
Hello Sir ,
Am having a littel problem here , My problem is that i want to add more columns to this dataTable, How can i edit the code inside to add more columns and also i want to know how to edit the columns size, Thank you very much, I think i will be the biggest follower for you
Great tutorial, I love it. can we edit date field in this table using a date picker, how?
Hi George Mathew we will try on our hand and we will share with you, nice question.
I'd like also to have that one...Also with show entries...Can we change change that on our own?...because default 10 is only few...
Really learn-able
Sir, this is nice tutorial. But there are some nice libraries for editable table and one of them is the JQXgrid.. can you create a tutorial for that using codeigniter framework. thanks
Thank you for your kind words. Appreciate your taking the time to let us know. We will look into.
why i have this kind of error?
Datatables warning: table id=user_data - invalid JSON response.
Have you solved this problem?
thanks sir..
thank you so much .. but the link for source code not working .. please can you give me another link
Thanks a lot :)
sir can u post video about paypal integration in php
how to get a image file
Thanks for this video tutorial. Can you make another one but with 2 tables for example? Thanks again.
Hi Mohamed Nassar, In our latest video tutorial on Datatables in which we have use two tables as per your requirement. Please check 'Datatables Individual column searching using PHP Ajax Jquery ' this video tutorial, you can find which you wanted..
Thank u for the great tutorial...can you share the source code please?
thank you Sir~~
DataTables warning: table id=user_data - Invalid JSON response. ....what's the issue...pls explain
I had the same problem with you if you find the solution tell me
same here...can anyone help?
this problem occurs when your field names in MySQL table don't match declared variables in your php codes. Also the sequence they follow which are in database like: id, name, email you may say in your php codes: id, email, name.
try this: utf8_encode($row['column']);
cool
can you make a functionality like readytogo.co.in
thanks
Great.
In my apache error log. There is an error which is :PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\\xampp\\htdocs\\fetch.php on line 52, referer: localhost/index.php Can you please help me to solve this?
Where my line 51 is $query = "SELECT * FROM skill_and_accountability";
and 52 is $result = mysqli_query($connect, $query);
Nice tutorial. but the edit icon is missing?? Thank you!
Its inline editing!!!! U can edit on same page in live time
Muito bom
can u send the source code
Hi Akhil Ayoor, we have already put source code under video description, so please check it.
add print please!
hallo sir, i still learning about insert data in bootstrap.. i have tried with your source code, but i found an error
"DataTables warning: table id=example - Ajax error. For more information about this error, please see datatables.net/tn/7"
how to fix it ? thanks
you need primary key on your table
okay i figure out how to fix my errors ...
Please do you get the solution i have the same error with u. can u help me please? Datatables warning: table id=user_data - invalid JSON response
Why do I get this error? DataTables warning: table id=user_data - Ajax error. For more information about this error, please see datatables.net/tn/7
Got error in jquery-1.12.4.js. Failed to load resource, server responded with error 404: xhr.send( ( options.hasContent && options.data ) || null );
Great tutorial but man is this annoying...
not this terminator again..ur tutorial is kinda anoyying
hello sir. why i can get error in this code :
if($_POST["length"] != -1)
{
$query1 = 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
}
error message: DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
i have this error also
error message: DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
why i have this error? DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1
Hi Ion, there is an error of number of column you have define html different than you have fetch from php code, so please check both things.
Sir, where can I found the number of column defined?
I got the same error,I copied his source code...not sure where to fiix this error @Webslesson
Rigo De La Torre double check the file names
I had created the table myself with the same exact ids. This time i deleted it and just used his sql code to create the table on phpmyadmin and it worked
Video is not clear. so sad
please check your internet connection.
code link :www.webslesson.info/2017/07/live-add-edit-delete-datatables-records-using-php-ajax.html
how to solve the DataTables warning: table id=user_data - Invalid JSON response. For more information about this error, please see datatables.net/tn/1? error please give me hand
Thank you, great tutorial