Bootstrap Datatables - Tutorial on the latest Bootstrap 5
HTML-код
- Опубликовано: 13 июн 2024
- Datatable is a component that mixes tables with advanced options like searching, sorting, and pagination. Here's a video where you're going to learn how to use MD Bootstrap Datatables.
📰 If you prefer written tutorials, you will find 25+ lessons on Bootstrap here -
mdbootstrap.com/learn/mdb-fou...
❗ Important - this tutorial requires the MDB Pro package ➝ bit.ly/3jYamhh
💎 Learn more about the advantage of using MDB 5 Pro ➝ bit.ly/3jYamhh
Watch the first part of the landing page tutorial ➝ bit.ly/2R9MfzK
Download starter pack ➝ bit.ly/2ZleYX3
Create, deploy & host your project with a single command ➝ bit.ly/3heDSxk
Write to us on support if you have technical issues ➝ bit.ly/3hkoLTq
Check out our documentation for Datatables ➝ mdbootstrap.com/docs/standard...
===============================
🎁 Join our mailing list & receive exclusive resources for developers
mdbootstrap.com/newsletter/
⭐ Support creation of open-source packages with a STAR on GitHub
github.com/mdbootstrap/mdb-ui...
👨👩👧👦 If you have any questions - don't hesitate to ask on our Facebook group:
/ 682245759188413
🎓 Learn responsive web design with the latest Bootstrap 5
• Bootstrap 5 tutorial -...
📥 Download Material Design for Bootstrap - FREE open-source UI KIT
mdbootstrap.com/docs/standard/
------------------
Show us some love ↓
Star ⭐ us GitHub github.com/mdbootstrap/mdb-ui...
Like 👍 us on Facebook / mdbootstrap
Follow 🐦 us on Twitter / mdbootstrap
#datatables#bootstrap5#tutorial#dev#programming
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!
Love to learn more use about this MDBootstrap 5.
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?
it is not working for me, i can not make copy code Access restricted, it is not for free
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?
Thank you ..
Happy to help :)
Keep Coding!
I can't see the link for newbies on MDB as quoted in the intro part of this video
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.
nice. can we apply the same with reactjs?
i have a console error mdb is not defined although i installed mdb pro and referenced mdb.css and mdb.js
please how can I use the sticky/fixed column attribute??
Do you have a tutorial on dynamic fetch, dynamic pagination, dynamic search for partial loading of data from an API?
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.
is it possible to have search, sorting and pagination server side without writing it all myself?
Very nice, but how do you add/delete data from the table one row at a time? Thanks
That mostly depends on your implementation. You can i.e. edit your source (i.e. JSON) and re-render table
if I do have a database on Google Sheet, how I am going to call the data on the datatables? :)
do you have any tutorials that show us how to link the datatables with mysql
it all depends on what you're using but loop through the table using the database object
How could a pivot view be modelled based on data stored in different mySQL tables?
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!
bro you legend
can u please do video on simple django db crud operations
Czy jest coś dla wersji podstawowej?
How do you integrate Datatables Editor in MD Bootstrap - Angular?
Have you checked that mdbootstrap.com/docs/b5/angular/plugins/table-editor/ yet?
how can I make 5 rows per page?
You can adjust it in options > "entries"
For server side it doesn’t work
What exactly doesn't work?
MDB - just code it show entries and search
is it free ? "This component requires MDB Pro Essential package."
As I wrote in the description, this component requires the purchase of a pro package 😉
The Template are not Free $$$, so Guys Hold your Kredit Cards ready