Ok lets start with Part Two…In part one you got enough information how to start with SQL command line. So keep walking and try out other major basic stuff of SQL. I am providing...

For a beginner there is a list of all basic mysql commands. If you are working on command prompt or shell then you should have to learn these basics. I am listing some of basic not...

class Db_Mysqli { static $hostname; static $username; static $password; static $port; static $database; static $connection; /** * * @param String $hostname * @param String $username...

Google provide lots of easy method to integrate map in your HTML or php. Here i am trying just to explain a simple method by which you can pass address at the time of initialization...

This based on standard jquery validate plugin. If you want to display all error in one container on your html page Create a Html form and a error container div. For example <div...

To add or remove html row here i am explaining with simple javascript and html. We can use Jquery and other stuff but it’s just to clear out basic concept by this you can...

Go to terminal window To export type following command “mysqldump -u USERNAME -p dbname tableName > tableName.sql” Here mysqldump           is default mysql command...

We generally need a random password string for different purpose. Here i am sharing a simple php function to generate random password with user specific length. User can pass length...

This is a simple function using php in built “unlink” function. I am using “deleteRootToo” parameter to delete root directory holding all sub directories....

Mostly we used normal insert MySQL query, but in the same time if user inserted special characters then to prevent this we can use normal php function. Below is the example of...