Inser record from db_query

From below query you can insert using db_query db_query('INSERT INTO {itg_menu_manager} (title,url,target,menu_level,menu_name,url_type,section_id,weight) VALUES (:values,:url,:target,:menu_level,:menu_name,:url_type,:section_id,:weight)', array(':values' => "ramji" ,":url" => 'asd', ':target' => 'asd' ,':menu_level' => 'menu_level' , ':menu_name' => 'asd',':url_type' => 'asd',':section_id' => 'asd', ':weight' => 12));

How To Backup Databases Using mysqldump Tool , How to backup a MySQL database , How to backup MySQL database structure only , How to backup multiple MySQL databases into a single file

MySQL GUI tools such as phpMyAdmin, SQLyog and etc, often provide features for backup MySQL databases with ease. However, if your database is big, the backup process could be very slow because the backup file needs to be transferred across the network to your client PC. As the result, the backup process increases the locking... Continue Reading →

WEB CACHE: APC VS MEMCACHED VS VARNISH

With increasing amounts of data and server-side processing, caching systems are as important as ever. There are so many varieties of these systems out there, it can be confusing if you don’t understanding the different nuances. Worse yet, if you pick the wrong caching system for your needs or fail to optimize it correctly, the... Continue Reading →

Query time result in MySQL w/ PHP

$starttime = microtime(true); //Do your query and stuff here $endtime = microtime(true); $duration = $endtime - $starttime; //calculates total time taken This will give you the run time in microseconds.

WordPress.com.

Up ↑