PhpminiAdmin Best Alternatives to phpMyAdmin

Posted by Prem Tiwari | Updated on | in General.


Phpminiadmin best alternatives to phpMyAdmin is a single file 186Kb file written in PHP programming language. No need to install phpminiadmin to access your MySQL database, simply you need to change the database configuration in …

WordPress Database Architecture Design With Descriptions

Posted by Prem Tiwari | Updated on | in WordPress, WordPress Beginners.


In today’s post I will explain very useful thing. If you want to start working on WordPress OR you are a WordPress beginners, then it is very important for you to understand the wordpress database …

How To Create MySQL Trigger

Posted by Prem Tiwari | Updated on | in Mysql, Oracle.


This article will explain how to create Trigger in mysql. A mysql trigger is a procedural code which is automatically executed after response to certain events on a particular table or view in a database. …

Fix the WordPress Error Establishing a Database Connection

Posted by Prem Tiwari | Updated on | in WordPress, WordPress Snippets.


Hi friends, today i am sharing the solution of database connection error in wordpress. One of my client got “Error Establishing a Database Connection” in his wordpress website intermittently. While doing R&D to find the …

Responsive country,state,city dropdown using PHP

Posted by Prem Tiwari | Updated on | in Freebies, JavaScript, Mysql, PHP Tutorial.


I got many request to Responsive country,state,city dropdown values from the database without refresh page using Ajax and PHP. In this article, I’ve put three drop down of country,state,city, drop downs without refreshing the page. …

Getting Started with MongoDB and PHP

Posted by Prem Tiwari | Updated on | in Mysql, PHP Tutorial.


This tutorial provides an introduction to basic database operations using the mongo shell. MongoDB is a document database that provides high performance, high availability, and easy scalability. MongoDB is a free and open-source cross-platform document-oriented …

How to write multiple queries using MySQL Transaction

Posted by Prem Tiwari | Updated on | in Mysql, Oracle.


A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. These statements provide control over use of transactions: START TRANSACTION or BEGIN start a …

Login with Yahoo Oauth in php

Posted by Prem Tiwari | Updated on | in Freebies, PHP Tutorial.


In this post i explain how to Login with Yahoo Oauth in php. Now a days mostly website needs the login using third party websites like Google, Yahoo, facebook or some of the social networks. …

How to create and use Mysql Trigger

Posted by Prem Tiwari | Updated on | in Mysql, Oracle.


Introduction to SQL Trigger A SQL trigger is a special type of stored procedure. It is special because it is not called directly like a stored procedure. The main difference between a trigger and a …

Mysql Tutorial With Query Examples

Posted by Prem Tiwari | Updated on | in Mysql.


MYSQL is a language for accessing databases. If you want to start reading mysql tutorials, then you keep close attention in this post. In this post i will share Our tutorial will helping you for …

How to Connect Database With PHP

Posted by Prem Tiwari | Updated on | in Mysql, PHP Tutorial.


In this tutorial, I will explain simple and easy steps that will help you to create a database connection with MySql database with PHP applications. It is very easy to write a script in PHP …