How to read excel file and insert into MySQL using PHP
adminMany 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…
How to search using MySQL prepared statement and PHP
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…
MYSQL database backup and restore using command line
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…
How to upload and store image in MYSQL using PHP
Upload image to mysql blob storage and display it using PHP. We are going to discuss more about how to do this in the following tutorial. This also has a…