Database - 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.

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 and Export CSV File using PHP and MySQL

CodexWorld — Tue, 19 Feb 2019 11:30:05 +0000

Import and Export feature is very useful for the data management section. The Import functionality allows the user to upload and insert multiple data in the database. Using the Import feature, the bulk data can

The post Import and Export CSV File using PHP and MySQL appeared first on CodexWorld.

Save WYSIWYG Editor Content in Database using PHP and MySQL

CodexWorld — Tue, 05 Feb 2019 19:24:20 +0000

The WYSIWYG editor allows the user to insert the HTML formatted text in the input field. You can easily add WYSIWYG HTML editor to textarea using jQuery plugin. There are many jQuery plugins are available

The post Save WYSIWYG Editor Content in Database using PHP and MySQL appeared first on CodexWorld.

DataTables Server-side Processing with PHP and MySQL

CodexWorld — Tue, 25 Sep 2018 05:24:54 +0000

DataTables is a jQuery plug-in that provides a quick and easy way to list data in a tabular format on the web page. You can add the sorting, filtering, and pagination functionality to the HTML

The post DataTables Server-side Processing with PHP and MySQL appeared first on CodexWorld.

Delete Multiple Records from Database in CodeIgniter

CodexWorld — Wed, 01 Aug 2018 18:49:45 +0000

Delete multiple records on a single click is very useful for the large data list. This feature provides a user-friendly way to remove multiple records from the database quickly. The user doesn’t need to click

The post Delete Multiple Records from Database in CodeIgniter appeared first on CodexWorld.

How to Restore MySQL Database from SQL File using PHP

CodexWorld — Thu, 08 Feb 2018 18:41:24 +0000

Generally, the import section of phpMyAdmin is used to import or restore the database from a SQL file. Like phpMyAdmin, there are various options are available to restore the tables of MySQL database. To import

The post How to Restore MySQL Database from SQL File using PHP appeared first on CodexWorld.

How to Change WordPress Admin Username

CodexWorld — Thu, 20 Jul 2017 17:30:52 +0000

If you try to change your WordPress username, you will see the notification like this – Usernames cannot be changed. But many times we need to change the WordPress admin username for security purposes. In

The post How to Change WordPress Admin Username appeared first on CodexWorld.

Store and Retrieve Image from MySQL Database using PHP

CodexWorld — Mon, 17 Jul 2017 18:04:30 +0000

Generally, when we upload image file in PHP, the uploaded image is stored in a directory of the server and the respective image name is stored in the database. At the time of display, the

The post Store and Retrieve Image from MySQL Database using PHP appeared first on CodexWorld.

How to Connect Multiple Database in CodeIgniter

CodexWorld — Wed, 12 Jul 2017 16:05:41 +0000

Generally, one database is used for a single web application. But sometimes we need to use two or more database in a single site. If your application built with CodeIgniter framework, it’s very easy to

The post How to Connect Multiple Database in CodeIgniter appeared first on CodexWorld.