DatabaseCategory

Solution to Fix the Character Encoding Mismatch Problem in WordPress Date posted: 29/10/2019 Introduction After switching my hosting account, therefore we might notice special / wired characters on our wordpress blog. This error is due to we have some issue with Database Character Sets in wordpress. If you are facing similar… Continue Reading Solution to Fix the Character Encoding Mismatch Problem in WordPress

MONGODB BASIC OPERATIONS Date posted :11/05/2019 INTRODUCTION: In this tutorial we are going to see about mongodb basic operations. 1)Start mongodb in port The following command used to start the mongodb with the port(27017). 2)Stop mongodb To stop the mongo services the following command used to stop the mongo services.… Continue Reading MONGODB BASIC OPERATIONS

How to use Rx-java with Room in android Date : 08/04/2019 Prerequisite If you need to use Rx-java in android, then add the following dependency in your gradle file as depend on the version of Rx-java you use. // RxJava support for Roomimplementation “android.arch.persistence.room:rxjava2:1.0.0-alpha5” Need of Rx-java Rx-java eliminates the… Continue Reading How to use Rx-java with Room in android

Joining Tables with JOIN Clauses in Database Date posted: 02/05/2019 Join clause: The SQL Join clause is used to combine records from two or more tables in a database. A JOIN means for combining fields from two tables by using common values to each. Different types of joins INNER JOIN – selects… Continue Reading Joining Tables with JOIN Clauses in Database

How to create a project in FireBase Date posted: 22/04/2019 Prerequisite Make sure that you have API higher than 26 through by Click Tools > SDK Manager. Click the SDK Tools tab. Check the Google Repository checkbox, and click OK. Click OK to install. Step 1 : Find the fire base assistant in your android studio application… Continue Reading How to create a project in FireBase

Date :28/03/2019 What is codeigniter? Codeigniter is a php framework to develop the application. Therefore, it provides the many libraries for connecting to the database. Codeigniter simple Add, Edit, Delete, View However, we create database and table. Firstly, database name is considered to be as ‘form’. similarly, creating a table… Continue Reading CODEIGNITER: SIMPLE ADD, EDIT, DELETE, VIEW

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