Bootstrap Datatables - Tutorial on the latest Bootstrap 5

[@Mdbootstrap]

I hope you liked the video. If you are already here in the comment section, I invite you to let me know what other videos would you like to see in the future. Also, share any other feedback that you have on this video! I don't run ads on tutorials - the only value I get is your engagement in the MDB community. So if you would like to show your support: - Encourage more people to Keep Coding ---> Send this video to one person - Stay tuned for new content ---> Subscribe & ring the bell In the description, you will find links to some useful, free resources: 📥 Download Material Design for Bootstrap - FREE open-source UI KIT 🎓 Learn responsive web design with the latest Bootstrap 5 (full 1.5H course) 🎁 Join our mailing list & receive exclusive perks (free stuff that is normally behind a paywall) ⭐Support the creation of open-source packages with a STAR on GitHub 👪 If you have any questions - don't hesitate to ask on our Facebook group Thank you for your support!

[@alihamdane9786]

it is not working for me, i can not make copy code Access restricted, it is not for free

[@FabioGemesio]

is it possible to have search, sorting and pagination server side without writing it all myself?

[@santoshpanda926]

Love to learn more use about this MDBootstrap 5.

[@jaggyjut]

nice. can we apply the same with reactjs?

[@ShohoJisso]

very informative video. Is it possible to implement server-side sorting by dynamically changing the sortField and sortOrder attributes or do I have to re-initialize the component via javascfript with new values of sortField and sortOrder?

[@kisho2679]

How could a pivot view be modelled based on data stored in different mySQL tables?

[@Mdbootstrap]

Creating a pivot view with Bootstrap Datatables based on data stored in different MySQL tables involves several steps. Note that you might need to adapt these steps based on your specific database structure and requirements. Ensure that your MySQL tables are structured in a way that facilitates pivot operations. You may need to have a common column that can be used as a key to join the tables. Write a MySQL query to fetch the data you need for the pivot view. This query should join the necessary tables and transform the data into a format suitable for pivoting. Use aggregate functions if needed. SELECT common_column, MAX(CASE WHEN table_name = 'table1' THEN column_name END) AS table1_column, MAX(CASE WHEN table_name = 'table2' THEN column_name END) AS table2_column FROM (SELECT common_column, column_name, 'table1' as table_name FROM table1 UNION SELECT common_column, column_name, 'table2' as table_name FROM table2) AS combined GROUP BY common_column; Remember to replace common_column, table1, table2, and column_name with your actual column and table names. Use a server-side scripting language (e.g., PHP, Node.js, Python) to execute the MySQL query and fetch the result. Convert the result into JSON format. After that use DataTables to display the pivot view on the front-end. Include the DataTables library in your HTML file. Check out the DataTables documentation: mdbootstrap.com/docs/standard/data/datatables/ Customize the styling of your DataTable as needed. Test your solution to ensure that the pivot view is displaying the data correctly. Keep in mind that this is a general guide, and you may need to adjust the steps based on your specific requirements and database schema. Additionally, make sure to handle security aspects such as parameterized queries to prevent SQL injection. Hope that helps, Keep Coding!

[@davecamarce7411]

if I do have a database on Google Sheet, how I am going to call the data on the datatables? :)

[@anirbanrubel]

how can I select some columns and save those column data in a MySQL database on submit click? can you please make a video on it? I searched on youtube but haven't got any videos related to that.

[@MHMCABabaranjith]

can u please do video on simple django db crud operations

[@HOUSIENable]

Thank you ..

[@Mdbootstrap]

Happy to help :) Keep Coding!

[@chibuzornweke419]

I can't see the link for newbies on MDB as quoted in the intro part of this video

[@youtubeboy5700]

bro you legend

[@ahmedmatter3696]

i have a console error mdb is not defined although i installed mdb pro and referenced mdb.css and mdb.js

[@cidicleycintra]

tentei incluir no arquivo do wordpress de um pluin que criei, ele dar um conflito com as opções da biblioteca de mídia. não exibe nem adiciona novas mídias. tem como usar a datatables em plugin wp sem dar conflito com as mídias?

[@abubakarsg718]

please how can I use the sticky/fixed column attribute??

[@testsite128]

do you have any tutorials that show us how to link the datatables with mysql

[@AnimeZone247]

it all depends on what you're using but loop through the table using the database object

[@unixkid3000]

Very nice, but how do you add/delete data from the table one row at a time? Thanks

[@Mdbootstrap]

That mostly depends on your implementation. You can i.e. edit your source (i.e. JSON) and re-render table

[@TopherT]

How do you integrate Datatables Editor in MD Bootstrap - Angular?

[@Mdbootstrap]

Have you checked that mdbootstrap.com/docs/b5/angular/plugins/table-editor/ yet?

[@RockyCastaneda]

Do you have a tutorial on dynamic fetch, dynamic pagination, dynamic search for partial loading of data from an API?

[@Mdbootstrap]

We don't have specifically on API however you can check this one to learn how to load from JSON. Once you have that, you can easily use REST to call API and load your data.

[@kabii111]

Czy jest coś dla wersji podstawowej?

[@rajhees]

how can I make 5 rows per page?

[@Mdbootstrap]

You can adjust it in options > "entries"

[@saboorhamedi5413]

For server side it doesn’t work

[@Mdbootstrap]

What exactly doesn't work?

[@saboorhamedi5413]

MDB - just code it show entries and search

[@Dev-ks3ep]

is it free ? "This component requires MDB Pro Essential package."

[@Mdbootstrap]

As I wrote in the description, this component requires the purchase of a pro package 😉

[@manuelkaufmann3659]

The Template are not Free $$$, so Guys Hold your Kredit Cards ready