WordPress Database Architecture Design With Descriptions

| 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 architecture design. I am going to explain WordPress database architecture design with description of each tables which generate during your …


How To Create MySQL Trigger

| Last Updated: | In: Mysql, Oracle


Mysql Trigger

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. I am taking a real time example here, when a new entry ( New Employee Joining) inserted in to employee …


Fix the WordPress Error Establishing a Database Connection

| Last Updated: | In: Wordpress, WP Labs


wordpress-magazine

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 root causes of this error, i realized that there are many ways to fix this error. Bellow is the lists …


Responsive country,state,city dropdown using PHP

| Last Updated: | In: Core php, Freebies, Javascript & Ajax, Mysql


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. All the country, state, city data and their licensing is free to use so you can use this data for …


Getting Started with MongoDB and PHP

| Last Updated: | In: Core php, Mysql


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 database program with NoSQL database. It stores data in json format. MongoDb is developed by MongoDB Inc in 2007. How …


How to write multiple queries using MySQL Transaction

| 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 new transaction. COMMIT commits the current transaction, making its changes permanent. ROLLBACK rolls back the current transaction, canceling its changes. …


Login with Yahoo Oauth in php

| Last Updated: | In: Core php, Freebies


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. This is a very simple and easy steps to follow. . In order to start working with Yahoo SDK you …


How to create and use Mysql Trigger

| Last Updated: | In: Mysql, Oracle


Mysql Trigger

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 stored procedure is that a trigger is called automatically when a data modification event is made against a table whereas …


Follow us!

Get Free Access of 350+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW