PhpminiAdmin Best Alternatives to phpMyAdmin

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | In: Freebies, Javascript & Ajax, 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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

By: Prem Tiwari | Last Updated: | 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 …