es BRUTALMENTE bueno, muchas gracias muy rapido, lo probe con mas 1'500,000 registros, en una pc core 2 duo - 8 ram - ssd 240gb ...lo leyo en 4 segundos mas que ESPECTACULAR !! Gracias 💪👊💪, lo usare como base para los proyectos
Why does my fetch data have an error? It wont add the user i input, the fetch data says Undefined index length line 37 Undefined index start line 39 Undefined index length line 40 Mysqli_num_rows() expects parameter 1 to be mysqli_result, bool line 45 Mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool line 47 Undefined index draw line 60
excuse me, when I upload it to the server, it doesn't let me create. It gives me the legend "failed". But locally it works fine for me. do you have any solution?
hi I really like this tutorial , but get some errors starting around if($_post['length'] != -1), it says undefined array key "length", i really need this
why i cant use where in this fetch part $output= array(); $sql = "SELECT * FROM users WHERE status='Closed' "; $totalQuery = mysqli_query($con,$sql); $total_all_rows = mysqli_num_rows($totalQuery);
Hello Sir, why paging is not working? I have 21 entries but when I chose "show by 10" the paging didn't show only page 1. I follow your steps Sir. Can you help me to this. Thank you
Good Morning. It’s a nice and very detailed CRUD solution of one of this kind of projects. It’s very much appreciated to present this type of project solution to help others. I have one project same as yours that has all functionality of Ajax/JavaScript and it doesn’t have TAG which used in some sorts of Ajax/Java Script routine with Bootstrap 5.0. It works fine but not suitable at all for Mobile/Cell Phone. Did you ever try how to make this project responsive for Mobile/Cell Phone? Thanks again for the anticipation of my message. Regards, Shamsul Arifin
@@CodexTime how to add data . i dont know . iwant to make like chegg site but i cannot . i want to user add long text and photos and they can search but for 2 weeks i research but i can not find some e-lessons teach php 5.6
Took me awhile to figure out but if anyone is having this issue, it has to do with the filtered records in the fetch_data.php needing to include data not just on the current page, i.e after searching but before limiting the data
Hi sir I just want to ask why the jquery cdn is not working? I tried your code and it only loads and is not showing any data on the datatable. And when I tried to search the cdn it is not working.
Hello Sir, I try to change the column name of the id in the database into ticketid, what should I do in trid? the update and delete button is not working. Can you help me to solve this problem. Thank you.
One more thing sir, I already fix the the problem. But if i tried to edit again why the edit button is not functioning? It doesn't want to edit again unless i refresh it. Thank you
Hello sir thank you for providing us such good content I have a doubt ...I downloaded your source code and it was running well with out errors but when I try to Add data the newer data is showing on the top of the table I tried different ways but it didn't change but in your video when you added a new row it showed in the bottom ....can anyone help me with this.
Hi sir I really appreciate your work i just want to ask these hidden line in your script? whenever I edit the edit the user I need to refresh/reload the page to delete the user profile. Is there any way to solve this?
Hello Sir, why if i click the edit button again after changing the same id. The edit button is not functioning? Please help me to solve it, I'm not expert with this kind of situation. Thank you.
Hi and Thanks for your contribute. And I've a question, is it my fault? when I type keyword to search, the paging will not update, could you please help? thanks
i am very bad with the functions of php and i am a beginner in javascript what would you advice me when it comes to learning the functions and when to start javascript and is it better to start a library of javascript or just javascript first
Js ans css loaded by cdn so internet is required.. please connect with internet then try again.. Or I have updated the code using local css and js libraries. Just again download and check it again
Thx for your crud operation tutorial with datatable. keep it up.🙏
I just wanna to say : thank you very much brother.
Perfect Data Table .... I am impress with your coding ... Thank you for Give me Data Table ....and it's source code
You are most welcome
es BRUTALMENTE bueno, muchas gracias muy rapido, lo probe con mas 1'500,000 registros, en una pc core 2 duo - 8 ram - ssd 240gb ...lo leyo en 4 segundos mas que ESPECTACULAR !! Gracias 💪👊💪, lo usare como base para los proyectos
Thank you so much
Goodjob awesome tutorial. I love you. It help me a lot.
Very beautiful sir or mam! Thank you in advance!
Thank you so much!
You make very good video, I lean a lot from you, thanks
thank you soo much! best tutorial datatable i ever see.
Glad you liked it!
Thanks for the tutorial. Now I just have to figure out the filter function.
Nice Code ! It's Hard Working. Thanks for your tutorial.
Thank you for the amazing tutorial! I will have to spend sometime study your code! :)
thanks very much, your great video.
Hi and Thak you bro
Good tutorial! But you must use parameterized queries in mysqli to prevent SQL injection vulnerability.
Why does my fetch data have an error? It wont add the user i input, the fetch data says Undefined index length line 37
Undefined index start line 39
Undefined index length line 40
Mysqli_num_rows() expects parameter 1 to be mysqli_result, bool line 45
Mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool line 47
Undefined index draw line 60
Hi and thank you for your nice presentation. Can you tell us what is the version of your PHP?
7.2
@@CodexTime hi please help why my output doesn't have a separation between the categories i will attached mg index. Php code
Hey, how can i post all data in boxes with checkmark to delete them ? Help please
Post data in array .. and post id with checkbox like this-
How implementation join tables in serverside Sir..?
Thanks a lot
Sir, how to add variable data to array in MySQL query
How could a row be duplicated in the created web application, just to be updated as new entry?
Can sort data row it save to database
thanks for code
When I run it in its original form the project works but when I add more columns the data is not listed. what is the problem? Can you help me?
How could a pivot view be modelled with SQL-Workbench, based on data stored in different mySQL tables?
could you please explain why we have trid as hidden and whats its role
We are using trid for updating content of row and delelting row without refreshing the page and datatable.
@@CodexTime oooh cool
excuse me, when I upload it to the server, it doesn't let me create. It gives me the legend "failed". But locally it works fine for me.
do you have any solution?
Thanks bro
Can you put this on git instead of download as zip?
Search bar and show entries do not appear
hi I really like this tutorial , but get some errors starting around if($_post['length'] != -1), it says undefined array key "length", i really need this
how about the paging sir how do you make it work
why i cant use where in this fetch part $output= array();
$sql = "SELECT * FROM users WHERE status='Closed' ";
$totalQuery = mysqli_query($con,$sql);
$total_all_rows = mysqli_num_rows($totalQuery);
i cannot understand please put a voice during running video
Hi is this posible with join multiple table?
Yes its possible
@@CodexTime Thank you :) and already done it with multiple table
I tried changing the fields in the database and its showing no data
I tried to modified your fields and unfortunately it doesn't display the data. I have fast internet connection and already checked the source code.
the sorting in the id is not working and shows an error. Will someone help me? Thank you in advance!
same problem here...
Sorting for id is fixed. Download fixed version from video description
Sorting for id is fixed. Download fixed version from video description
is responsive?
JSON.parse() is getting an error plz can u help me
Hello Sir, why paging is not working? I have 21 entries but when I chose "show by 10" the paging didn't show only page 1. I follow your steps Sir. Can you help me to this. Thank you
this option shows items per page, not only in one page
sir, why SORT is not working in your files??
its fixed 👍
Good Morning. It’s a nice and very detailed CRUD solution of one of this kind of projects. It’s very much appreciated to present this type of project solution to help others.
I have one project same as yours that has all functionality of Ajax/JavaScript and it doesn’t have TAG which used in some sorts of Ajax/Java Script routine with Bootstrap 5.0. It works fine but not suitable at all for Mobile/Cell Phone.
Did you ever try how to make this project responsive for Mobile/Cell Phone?
Thanks again for the anticipation of my message.
Regards,
Shamsul Arifin
Thanks for appreciation..
Try to wrap your bootstrap table in div with table-responsive class .. it will show the scrollbar in mobile view...
mejor imposible amigo gracias por tu aporte
Sorting not work in downloaded zip source
Sorting for id is fixed. Download fixed version from video description
whats the point of implementing a datatable if its not going to work?
pagination is not working on the script
Fixed in source code.
@@CodexTime how to add data . i dont know . iwant to make like chegg site but i cannot . i want to user add long text and photos and they can search but for 2 weeks i research but i can not find some e-lessons teach php 5.6
Took me awhile to figure out but if anyone is having this issue, it has to do with the filtered records in the fetch_data.php needing to include data not just on the current page, i.e after searching but before limiting the data
Hi sir I just want to ask why the jquery cdn is not working? I tried your code and it only loads and is not showing any data on the datatable. And when I tried to search the cdn it is not working.
internet required for cdn
Hello Sir, I try to change the column name of the id in the database into ticketid, what should I do in trid? the update and delete button is not working. Can you help me to solve this problem. Thank you.
In fetch_data, delete_user, get_single_data, update_user files change id to ticketid
One more thing sir, I already fix the the problem. But if i tried to edit again why the edit button is not functioning? It doesn't want to edit again unless i refresh it. Thank you
thank you
Hello sir thank you for providing us such good content
I have a doubt ...I downloaded your source code and it was running well with out errors but when I try to Add data the newer data is showing on the top of the table I tried different ways but it didn't change but in your video when you added a new row it showed in the bottom ....can anyone help me with this.
It important for me so please let me know if anyone knows about it
Hello! Yes its working, but the save changes button on the update can't be clicked.. Can you help us sir/maam?
Hi sir I really appreciate your work i just want to ask these hidden line in your script? whenever I edit the edit the user I need to refresh/reload the page to delete the user profile. Is there any way to solve this?
Problem in the index.php on javascript edit function. On line no 140 replace this code with delete anchor tag --> Delete
Can you help me solve this problem
Send screenshots on Instagram
send me a telegram id
Hello Sir, why if i click the edit button again after changing the same id. The edit button is not functioning? Please help me to solve it, I'm not expert with this kind of situation. Thank you.
thank you sir my question is how we can export this datatable as pdf or excel format
You can use pdf export js library for datatable
can you please send me the link of this library @@CodexTime
how to create admin panel for this table because i don't want to show edit button to users
Use usertype field in your db users table and store the usertype in login session. on user type based data show/hide your button.
@@CodexTime also i want to add URL button in data table so how can i add it? please make tutorial for this with admin panel
@@CodexTime can you do that for me? bcoz I'm beginner 😔
Hi and Thanks for your contribute. And I've a question, is it my fault? when I type keyword to search, the paging will not update, could you please help? thanks
Datatable should be rendered again after search results .. paging is depends on search results count..check these
kindly put print report for PDF and excel for this one base on search
it errors when i add 14 info or data. Is there a limit in how much you add data in a table?
No..there is no limitation in table. Check you table id length
@@CodexTime mine is 11
@@CodexTime the length of my id is 11. Will it affect the number of records that you want to insert in database?
Length is ok.. check error through inspect element in network tab
@@CodexTime the error is, it execute the else statement when I adding records to the database
i am very bad with the functions of php and i am a beginner in javascript what would you advice me when it comes to learning the functions and when to start javascript and is it better to start a library of javascript or just javascript first
If you want to goes to web development ...
First learn Html,javascript and PHP and then go to library and frameworks.
Hi sir, why the data is not loading on datatables?
Check database connection
@@CodexTime the source code is not working sir. I tried it, and even in the source code, the data is not loading.
@@CodexTime I tried to remove the library and it's loading fast, when I put it again it's just loading so slow and not showing any data.
Js ans css loaded by cdn so internet is required.. please connect with internet then try again..
Or I have updated the code using local css and js libraries. Just again download and check it again
Thanks!
the search bar it working?
Yes
I wish you explain everything in the video.
I tried it on notepad++ but sad to say it can't add and edit.
Sir can you help me data base se data AA hi nhi rhe hai index page me show nhi ho rahe hai
I think databse connection problem ho.
php version?
7.2
Bootstrap not working how to fix that
Iam using vs code E
Code is updated.. download it again and check it
What is the name of compiler po?
Hello Sir, please help me. I need your help so badly.
Can I ask if it is possible to use a joins in your code. If yes, can you help me please.
Yes you can use joins in my code.
why pagination is not working?
Fixed in source code.
Maybe you should change the links in the source code
please tutorial datatables server side in codeigniter 4 #thank you
bro made such twists in his source code so that he will not have his work stolen 😂 What's the point of sharing if you're afraid of stealing?
You are wrong bro.. I had changed some lines of code in source because some viewers telling that source code is not fully working.
@@CodexTime Hello. Great work, but pagination is still not working 😢
thank you
You're welcome