Our Database tutorials are up to date and well explained step-by-step using examples so you can learn Database manipulation fast.
With the use of the DataTables jQuery plugin, you can list your records in pagination format.
You can add HTML elements like – buttons, link, image, etc with a record.
For this need to pass element in HTML string format from the PHP script.
In this tutorial, I show how you can add edit and delete buttons in the Datatables AJAX pagination with PHP.
NOTE – I am using the Bootstrap modal to update a record.
CSV file is been used for data import, export, and generating a report.
If you have huge data available in the MySQL database and you only require a specific date range data but the file contains all records and you need it on your own.
By adding a date filter to the form you just need to pick the range and export it.
In this tutorial, I show how you can export MySQL database data in CSV format by date range with PHP. I am using jQuery UI for datepicker.
DataTable comes with a single search box that you can use to search on all or specific fields and display filtered records.
You can add custom elements according to your requirements and use them with DataTable.
In this tutorial, I show how you can implement a date range search in DataTable with jQuery AJAX and PHP. I am using jQuery UI for adding date picker.
AJAX is a web development technique that facilitates the exchange of data between the website visible on a user’s browser and its server-side database. This enables seamless communication for optimal performance and user experience.
JavaScript libraries or frameworks are commonly utilized by people to conveniently transmit AJAX requests. Although it’s essential to recognize the significance of transmitting AJAX requests with plain JavaScript as well.
To communicate with the server, use an object called XMLHttpRequest. It helps in sending and receiving data between the client-side and server-side.
In this tutorial, I show how you can send GET and POST AJAX requests with JavaScript and handle the request with PHP.
© 2016-2023 Makitweb, All rights reserved
