DatabaseCategory

Tutorial on how to connect python with MySQldb Date posted: 20/03/2019 Introduction: In this article helps you in connect python with MySQldb and insert queries in DB.  This example is explained based on Linux environment in Centos 7. Prerequisites: For centOS and RHEL based environment: 2. Pip installation is most… Continue Reading Tutorial on how to connect python with MySQldb

Date posted : 23/01/2019 Create a New User and Grant Permissions in MySQL MySQL MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. Step 1: A new user can be created within the MySQL shell, using the following statement: CREATE USER ‘pheonix’@’localhost’… Continue Reading Create a New User and Grant Permissions in MySQL

PHP Script for CRUD Application Date :06/12/2018 What is CRUD? CRUD refers to the four basic types of Database operations: Create, Read, Update, Delete. Most applications and projects perform  CRUD functionality. This is a important script for all PHP beginners. Once you learn about these CRUD operations, you can use them… Continue Reading PHP Script for CRUD Application

Edit the profile details using Angular2 Dated on: 25/10/2018 In this post we are going to see how to edit the profile details using angular 2. In previous post we have seen how to create the sign up form Step 1: Create the new component or new project as you… Continue Reading Edit the profile details using Angular2

How to install and configure Opencart – 3.0.2 On CentOS – 7. DATE POSTED: 19-10-2018 What is Opencart and its real-time purpose in this world ? OpenCart is a free and open source  online e-commerce web application. It is written in PHP and uses MySQL to store its database. It has… Continue Reading How to install and configure Opencart – 3.0.2 On CentOS – 7.

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