MySQL - CodexWorld

Auto Backup MySQL Database using PHP Cron (Linux & Windows)

CodexWorld — Sat, 27 Dec 2025 10:30:30 +0000

Automatically backing up your MySQL database is critical for production websites and applications. Manual backups are error-prone and often forgotten, while automated backups ensure your data is safe even if something goes wrong. In this

The post Auto Backup MySQL Database using PHP Cron (Linux & Windows) appeared first on CodexWorld.

Forgot Password with Email OTP Verification using PHP & MySQL

CodexWorld — Thu, 30 Oct 2025 11:14:39 +0000

A secure forgot password feature boosts user trust and reduces support tickets. Implementing OTP (one-time password) email verification with PHP ensures only the true account owner can reset the password, adding an extra security layer

The post Forgot Password with Email OTP Verification using PHP & MySQL appeared first on CodexWorld.

DataTables Column Filtering with Server-side Processing using PHP

CodexWorld — Thu, 07 Mar 2024 06:05:59 +0000

DataTables is a JavaScript library used to enhance the functionality and add advanced features to HTML tables. The DataTables plugin converts a basic HTML table into an advanced feature-rich table instantly. There are various advanced

The post DataTables Column Filtering with Server-side Processing using PHP appeared first on CodexWorld.

CRUD Operations with Multiple Images in PHP

CodexWorld — Thu, 12 Oct 2023 06:43:33 +0000

CRUD operations are the most used functionality in the web application managed dynamically. The add, edit, and delete functionality helps to manage data with the database on the website. You can integrate CRUD operations with

The post CRUD Operations with Multiple Images in PHP appeared first on CodexWorld.

Import Excel File Data into MySQL Database using PHP

CodexWorld — Mon, 17 Apr 2023 15:11:48 +0000

Excel is a spreadsheet used to store data in tabular form. In the web application, the Excel file format is used mainly for 2 purposes, import and export data. The import feature helps to parse

The post Import Excel File Data into MySQL Database using PHP appeared first on CodexWorld.

DataTables CRUD Operations with PHP and MySQL

CodexWorld — Thu, 23 Feb 2023 06:49:45 +0000

DataTables is a JavaScript library that helps build data tables and instantly add advanced features to HTML tables. In the web application, the DataTables jQuery plugin is the best option for displaying data in a

The post DataTables CRUD Operations with PHP and MySQL appeared first on CodexWorld.

Create and Manage HTML Pages Dynamically with PHP & MySQL

CodexWorld — Fri, 30 Sep 2022 05:27:28 +0000

Dynamic web page creation functionality helps to make the HTML content of the web page manageable by the admin/user. The user can create an HTML web page with dynamic content and modify the page content

The post Create and Manage HTML Pages Dynamically with PHP & MySQL appeared first on CodexWorld.

PHP Event Calendar using FullCalendar JS Library

CodexWorld — Mon, 11 Jul 2022 05:11:43 +0000

The Event Calendar lists the events date-wise in a large calendar view. The events are fetched dynamically and listed under the date cell. An event calendar makes it easier to find the events for a

The post PHP Event Calendar using FullCalendar JS Library appeared first on CodexWorld.

Storing Visitor Log in the Database with PHP and MySQL

CodexWorld — Tue, 22 Jun 2021 10:03:54 +0000

Visitor Log helps to track user activity on the web application. When visitors access the website, you can collect the visitor’s IP address, referrer, browser, and other details, and store them as a log in

The post Storing Visitor Log in the Database with PHP and MySQL appeared first on CodexWorld.

Radius Based Location Search with PHP and MySQL

CodexWorld — Wed, 23 Oct 2019 18:52:48 +0000

The search feature allows the user to find the specific data from a large number of records quickly. Generally, when a search request is submitted, the filtered data is fetched from the database. If you

The post Radius Based Location Search with PHP and MySQL appeared first on CodexWorld.