MysqlCategory

Insert data into database using codeigniter Date posted: 04-oct-2018 Please follow  the steps to insert data into database using codeigniter Step 1: Create a new file under the path Application/controllers/Insert.php.Copy the below given code in your view. <?php class Insert extends CI_Controller { public function __construct() { //call CodeIgniter’s default… Continue Reading Insert data into database using codeigniter

Upgrading WordPress Manually in Centos 7 Date Posted : 20-09-2018 In this article, we are about to learn about how to upgrade WordPress version from rear end.We assuming that your have installed LAMP stack. Prerequisite : Acquaintance of WordPress,MySQL Assumptions: Centos 7 is running in your server WordPress version :… Continue Reading Upgrading WordPress Manually in Centos 7

Date Posted: 10-09-2018 In this Post we will explain create dynamic menu from database using codeigniter. We assuming that you are familiar with CodeIgniter’s MVC structure, so We did not going to explain what model and controller in CI are. Step 1: Please execute the following command and create the… Continue Reading Create dynamic menu from database using codeigniter

Date Posted: 05-04-2018 In this we will explain MySql replace NULL values with empty string. Step1: You can create two different tables. using the following query. CREATE TABLE `users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL, `name` varchar(40) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, PRIMARY KEY… Continue Reading MySql replace NULL values with empty string

Error debconf: unable to initialize frontend: Dialog Date Posted: 06-10-2017 Issue:- When got this error while installing mysql via bash script. Its because debconf is trying to control dialog prompt in background. But it doesn’t exist on your server. Fix:- So install dialog and apt-utils apt-get install dialog apt-utils  

ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci” Date Posted: 04-10-2017 Recently, when we tried to resource the dump which we had taken on one server and tried to restore it on another server. The restore failed with an error: ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”… Continue Reading Unknown collation: utf8mb4_unicode_520_ci

Introduction A dropdown list is a common form element used to allow users to select one option from a predefined list. In many web applications, the dropdown values need to be retrieved dynamically from a database instead of being manually added to the HTML code. In this post, we will… Continue Reading How to Create a Dynamic Dropdown List Using PHP and MySQL

Introduction There are situations where you may not be able to access the WordPress admin dashboard due to forgotten credentials, plugin conflicts, a broken dashboard, or other issues. In such cases, you can change the active WordPress theme directly from the backend by updating the theme settings in the WordPress… Continue Reading How to change wordpress themes from backend?

Introduction Changing the WordPress Site URL is a common task when migrating a website to a new domain, moving from HTTP to HTTPS, restoring a backup, or deploying a site to a new server. While WordPress provides options to update the site address from the admin dashboard, there are situations… Continue Reading Change wordpress site URL on backend(Mysql, Mariadb)

Introduction In production environments, changes to the database schema such as creating new tables or altering existing ones should be tracked and communicated to database administrators or development teams. Receiving notifications whenever these Data Definition Language (DDL) operations occur helps maintain audit trails, detect unauthorized schema modifications, and improve operational… Continue Reading Send Email Notification for MySQL CREATE TABLE and ALTER TABLE Events