How do you find the last changed tables in phpmyadmin?

When something went wrong with your website or you just want to know which tables are recently changed you can execute the following sql command in PhpMyAdmin: SHOW TABLE STATUS LIKE ; SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE ‘pattern’ | WHERE expr] SHOW…

Create and call procedure in PHP and MySql

A stored procedure has a header and a body using to declarative SQL statements stored inside the database catalog. There are three diffrent ways to pass parameters in procedures : 1) IN-parameters 2) OUT-parameters 3) IN OUT-parameters Database table Create user table with name and…

How to get database backup in your mailbox daily automatically

ew web host do not offer a daily backup of MySQL database while few offer extra charge for automatic backup.This PHP script will help you to get database backup in your mailbox daily automatically. This script  performs three tasks.First it creates backup of MySQL database and…

Simple Microsoft Excel file generation via PHP and Mysql

config.php :- <?php $host_name=”localhost”; $username=”root”; $password=””; $db_name=”test”; //Database Connection $conn=mysql_connect($host_name,$username,$password); //Database Select mysql_select_db($db_name,$conn); ?> BuyerAssistReport.php :- <?php error_reporting (E_ALL ^ E_NOTICE); include(“config.php”); $query  = “SELECT * FROM fruit “; $result = mysql_query($query) or die(mysql_error().’Error, query failed’); $tsv=””; $html=””; $xml = “”; while($row = mysql_fetch_array($result)) {…

FUTURE DATABASE TECHNOLOGIES

http://en.wikipedia.org/wiki/MongoDB http://en.wikipedia.org/wiki/HBase http://en.wikipedia.org/wiki/Redis http://en.wikipedia.org/wiki/Apache_Cassandra

Stored Procedure Lesson ?

Are you writing Stored Procedures if not please take a look at this post. Stored procedures can help to improve web application performance and reduce database access traffic. In this post I want to explain how to create and call the stored procedures from database…

Type of joins in mysql visual explanation:-

Introduction This is just a simple article visually explaining SQL JOINs. Background I’m a pretty visual person. Things seem to make more sense as a picture. I looked all over the Internet for a good graphical representation of SQL JOINs, but I couldn’t find any to my…