Home » My SQl

How To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu

About LAMP 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. Since the virtual private server is already running Ubuntu, the…

Read More »

insert current date to mysql automatically in yii framework

here is example to show how could you insert current date before save in yii ! just use beforSave function in your model, public function beforeSave(){ $mysqldate = date( ‘Y-m-d H:i:s’); $this->addedDate = $mysqldate; return parent::beforeSave(); } addedDate…

Read More »

PHP Insert Data Into MySQL

Insert Data Into MySQL Using MySQLi and PDO After a database and a table have been created, we can start adding data in them. Here are some syntax rules to follow: The SQL query must be quoted in…

Read More »

How To reset MySQL Auto_Increament?

There are times when you are in a testing mode and have inserted and delted too many rows of data in one or too many tables you may want to go to production mode and have finished all…

Read More »