PHP Read excel file and insert into mysql

Last updated on February 1st, 2016 at 01:28 amClick to rate this tutorial! [Total: 5 Average: 2.4]PHP Read excel file and insert into MySQL Many webmasters face issues while reading Microsoft excel spreadsheet data and insert them into the mysql database. Here is simple script that can read the excel file data and display it […]

How to create pagination using PHP and MySQL

Last updated on March 9th, 2022 at 02:40 pmClick to rate this tutorial! [Total: 1 Average: 4]It is always a good practice to paginate and split the MySQL query results in to different pages instead of displaying the entire result on a single page. This will help the user to view the results without much […]

How to search using MySQL prepared statement and PHP

Last updated on March 7th, 2022 at 03:56 pmClick to rate this tutorial! [Total: 2 Average: 4.5]Enabling content search is always very important for a large website especially when you have lot of pages. I am going to explain this in both regular mysqli procedural approach and also using prepared statements. This script also count […]

Categories
Tools

MYSQL database backup and restore using command line

Last updated on May 5th, 2016 at 01:13 amClick to rate this tutorial! [Total: 0 Average: 0]MYSQL database backup and restore, Taking mysql database backups are always crucial now a days as daily and weekly backups are always recommended. We are using mysqldump command here to take the backups and also to restore them. Please […]