@subpackage TYPO3 Flow

November 26, 2012 Leave a comment
Categories: TYPO3 Flow

Magento Home Page Slideshow – Free Extension

August 2, 2012 Leave a comment
Categories: Magento

Magento How to Change Modify Product Type? Free Extension

August 2, 2012 Leave a comment
Categories: Uncategorized

Magento Brand Manufacturer Management Free Extension

August 2, 2012 Leave a comment
Categories: Magento

Howto Use Joomla DSlideshow Component in your project?

July 9, 2012 Leave a comment

Dslideshow component consists of two joomla extensions, Dslideshow compoent itself and mod_dslideshow module, in order to display the slideshow on your joomla pages, you would need to enable the mod_dslideshow module under Module Management,  assign a position to it, and then show it on pages you want the slideshow to be displayed on.

In order to add slides to slideshow, goto Components->DSlideshow and add slides there.

If you have any questions submit a comment.

Categories: Joomla

Ubuntu/Linux Tar Exclude Directory

October 19, 2011 Leave a comment

To exclude directory from tar here is the command.

tar -cvpf ./test.tar --exclude="/path/to/dir1/*" --exclude="/path/to/dir2/*" /path/to/
Categories: Ubuntu

Magento – Debug Query and Prepared Statements via Profiler

September 9, 2011 Leave a comment

Zend Framework provides comprehensive classes for debugging insert, update, delete and select queries, while magento is based on Zend Framework we can utilize Zend_Profiler to debug queries and prepared statements.

If you are familiar with Magento Resource Models ( Models residing in Mysql4 directory ) you should be able to achieve this easily via $this->_getWriteAdapter() which returns Varien_Db_Pdo object, here is an example

$sql = 'INSERT INTO table1(column1, column2) VALUES(:col1, :col2)';
$bind = array(':col1'=>'value for column1', ':col2'=>'value for column2');
$adapter = $this->_getWriteAdapter();
$adapter->query($sql, $bind); //execute query and bind parameters to it.

$adapter->getProfiler()->setEnabled(true); //enable profiler
print $adapter->getProfiler()->getLastQueryProfile()->getQuery();  //print last executed query
print_r($adapter->getProfiler()->getLastQueryProfile()->getQueryParams()); //print binding parameters

Categories: Magento, Zend Framework