Category: PHP (Page 4 of 15)

Learn PHP programming through practical examples and tutorials. This category covers core PHP concepts, form handling, file opera

How to read excel file and insert into MySQL using PHP

Last updated on December 15th, 2022 at 03:56 pmMany 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 on the page. User also has the ability to validate the details and then using a […]

How to create pagination using PHP and MySQL

Last updated on November 6th, 2024 at 12:19 pmIt is advisable to implement pagination when displaying MySQL query results, rather than presenting all results on a single page. This approach enhances user experience by allowing for easier navigation and comprehension of the data. Additionally, pagination reduces the load on the MySQL server. The script I […]

How to search using MySQL prepared statement and PHP

Last updated on March 7th, 2022 at 03:56 pmEnabling 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 number of rows returned from the search. The […]

How to generate one time download link using PHP

Last updated on February 25th, 2022 at 06:13 pmGet IP Address And Generate Time Limited Download Link Using PHP File sharing websites use different logic to expire the download link[They use methods like temporary file location, Databases, Javascript etc.,], You might be wondering how they do that? In this tutorial I am going to show […]

« Older posts Newer posts »