How to Replace All Matched Fields in MySQL

By: Prem Tiwari | Last Updated: | In: Mysql


Sometime you need to replace some string urls with some thing else in your database table. This is very hard to replace the string or urls in database table manually one by one. Mysql replace …

Working With MySQL Events – Complete Beginners Guide

By: Prem Tiwari | Last Updated: | In: Mysql


Hello friends, hope you are doing good. In today’s tutorial, I will explain the very simple and easy steps to working with MySql events with the example. After this tutorial, you will be able to: …

Best MySQL GUI Tools for Developers 2017

By: Prem Tiwari | Last Updated: | In: Mysql


MySQL GUI tools play a big role when you are developing the data storage and management web applications. Nowadays MySQL is the world’s second most common used for relational database management system to deliver the …

Some Useful WordPress MySQL Queries

By: Prem Tiwari | Last Updated: | In: Mysql, WordPress, WordPress Snippets


This is a very quick tutorial about some useful WordPress MySQL queries. In this tutorial, I will share some useful MySQL queries which will help you when you are going to move your WordPress site …

How to get data from mysql using AngularJS and PHP

By: Prem Tiwari | Last Updated: | In: Angular JS, Featured, Mysql


Hi friends, hope you are doing well. In today’s post i will share a very important things with you. Now days AngularJS is the best option to develop next web application. If you are going …

Start using PDO instead of PHP MySQL extension

By: Prem Tiwari | Last Updated: | In: Mysql, PHP Tutorial


Hi Friends, Thanks for be with Freewebmentor. Freewebmentor wishes you Happy New Year 2017. This is the my first post in 2017. Today i am going to share very useful thing. If you are a …

How to Export Data in .CSV File From Mysql Using PHP

By: Prem Tiwari | Last Updated: | In: Mysql, PHP Tutorial


Are you looking to export your mydal data in .csv file using simple PHP code, then please keep your close attention in this post How to Export Data in .CSV File From Mysql Using PHP. …

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. …

Sql User Table Schema For Yii2 Starter Kit

By: Prem Tiwari | Last Updated: | In: Mysql, Yii framework


Are you going to develop your web application in yii2 framwork, then this article will help you. The user table schema is not provided with yii2 starter kit by yii2 framework package. Below is proper …

How to delete duplicate data from database table

By: Prem Tiwari | Last Updated: | In: Mysql, Oracle


Hi friend, today i am going to share How to delete duplicate data from database table. For preventing from duplicate entries in datatbase table you cna use PRIMARY KEY or UNIQUE Index on table with …

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 Install Linux, Apache, MySQL, PHP (LAMP) Server on Ubuntu

By: Prem Tiwari | Last Updated: | In: Freebies, Mysql


LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. As a solution stack, LAMP is suitable for building …

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 …

Facebook style photo gallery with comments

By: Prem Tiwari | Last Updated: | In: Javascript & Ajax, Mysql, PHP Tutorial, Web Technologies


Have you thought about own facebook-style photo gallry system with comments? I have and today I prepared it for you. In this post i explained the easy way to create your Facebook style photo gallery …