Practical MySQL

Describing a Table

When you aren’t logged into the MySQL command line, here’s a handy piece of code […]

Dropping a Table

Consider the following code for deleting a table

Adding Data

Let’s add some data to the table using the code in following example. You may […]

Retrieving Data

Now that some data has been entered into the cats table, following example shows how […]

Updating Data

Changing data that you have already inserted is also quite simple. Consider the following example

Deleting Data

Using AUTO_INCREMENT

When using AUTO_INCREMENT, you cannot know what value has been given to a column before […]

Preventing SQL Injection

It may be hard to understand just how dangerous it is to pass user input […]

Using placeholders

Another way—this one virtually bulletproof—to prevent SQL injections is to use a feature called placeholders. […]

Preventing HTML Injection

There’s another type of injection you need to concern yourself about—not for the safety of […]

Prepared statements in php

Many of the more mature databases support the concept of prepared statements. They have following […]

Select records with Prepared Statement

Consider the following code for selecting the records values from tables with php prepared statement.

prepared statement using like in php

Below is an example for prepares statement with like MySql clause.

Select query with bind and prepare in Prepared Statements

In order to execute Select statements through prepared statements we have to first bind input […]

Debugging prepared statements in php

Prepared statements in PHP sometimes reports a block error which is hard to debug. So […]

Getting MySQL row count of all tables in a database with one query

A quick way to get the row count of all tables in a database is […]