Our Database tutorials are up to date and well explained step-by-step using examples so you can learn Database manipulation fast.
AJAX pagination makes it easier to display the large list of records in multiple pages without refreshing the whole page when navigating.
While navigating pages if you refreshed the webpage then it will load record from 1st instead of page position before the refresh.
E.g. If you are on the 5th page then it will again start from 1st when webpage reload.
To retain the position, I am using COOKIE to store the page number and use it after page successfully load to fetch records in CodeIgniter.
By storing media files in the MySQL database make it easier to retrieve files uploaded by the user or in a specific category.
For this require storing the file on the server and saving the reference to the database.
In the tutorial, I show how you can upload and store video to the MySQL database table with PHP. Also, show how you can display stored videos in the database.
If you are using MySQL database in your web project then there is always possibility that you need to insert, update, and delete records instead of just fetching and displaying records.
In this tutorial, I show how you can insert, update, and delete a record from MySQL database table in Laravel.
A model is a PHP class where perform data logic and database manipulation like – retrieve data, insert, update, and delete.
In Laravel models classes are stored in app/ directory.
This mainly loads from the controller.
In this tutorial, I show how you create and load Model in the controller and fetch records from MySQL database in Laravel.
© 2016-2023 Makitweb, All rights reserved
