Home > kapil sharma (Page 2)

mysql queries

mysql queries 1. Add column age and desg in emp_prof table. Mysql> use profile; Mysql>alter table emp_prof add column age int; Mysql> alter table emp_prof add column desg char(10); 2. Update all records of emp_prof.(desg= actn,officer) Mysql> use profile; Mysql>update emp_prof set age=24,desg=’officer’ where emp_id=101; Mysql>update emp_prof set age=21,desg=’actn’ where emp_id=102; (follow above queries for other records) 3. Display

Read More

countdown timer in php

countdown timer in php $dateFormat = "d F Y -- g:i a"; $targetDate = $futureDate;//Change the 25 to however many minutes you want to countdown change date in strtotime $actualDate = $date1; $secondsDiff = $targetDate - $actualDate; $remainingDay = floor($secondsDiff/60/60/24); $remainingHour = floor(($secondsDiff-($remainingDay*60*60*24))/60/60); $remainingMinutes = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))/60); $remainingSeconds = floor(($secondsDiff-($remainingDay*60*60*24)-($remainingHour*60*60))-($remainingMinutes*60)); $actualDateDisplay

Read More

get product thumb images on view.phtml

get product thumb images on view.phtml <?php $_images = Mage::getModel('catalog/product')->load($_product->getId())->getMediaGalleryImages(); ?> <?php if($_images){?> <?php $i=0; foreach($_images as $_image){ $i++; ?> <a href="#" onclick="ig_lightbox_show(-1)"> <img src="<?php echo $this->helper('catalog/image')->init($_product, 'thumbnail', $_image->getFile())->resize(108,90); ?>" alt="<?php echo $this->htmlEscape($_image->getLabel());?>" title="<?php $this->htmlEscape($_image->getLabel());?>" /> </a><?php } ?> <?php } ?>

Read More

Magento: How to get product rating and review

Magento: How to get product rating and review code for getting ratings and reviews for any particular product. /* Getting reviews collection object */ $productId = $product->getId(); $reviews = Mage::getModel('review/review') ->getResourceCollection() ->addStoreFilter(Mage::app()->getStore()->getId()) ->addEntityFilter('product', $productId) ->addStatusFilter(Mage_Review_Model_Review::STATUS_APPROVED) ->setDateOrder() ->addRateVotes(); /** * Getting average of ratings/reviews */ $avg = 0; $ratings = array(); if (count($reviews)

Read More

wysiwyg editor Magento Custom Module

wysiwyg editor Magento Custom Module Step 1 – Go to app/code/local/Webkul/Faq/Block here webkul is namespace and faq is module name , under your _prepareLayout() function add this code public function _prepareLayout() { if (Mage::getSingleton(‘cms/wysiwyg_config’)->isEnabled() && ($block = $this->getLayout()->getBlock(‘head’))) { $block->setCanLoadTinyMce(true); } return parent::_prepareLayout(); } Then go to app/code/local/Webkul/Faq/Block/Adminhtml/Faq/Edit/Tab and add

Read More

captcha alpha numeric in php

captcha alpha numeric in php <?php $RandomStr = md5(microtime());// md5 to generate the random string $ResultStr = substr($RandomStr,0,8); $im = @imagecreate(110, 20) or die("Cannot Initialize new GD image stream"); $background_color = imagecolorallocate($im, 0, 0, 0); $text_color = imagecolorallocate($im, 233, 14, 91); imagestring($im, 1, 5, 5, $RandomStr, $text_color); imagejpeg($im,$ResultStr.'.jpg'); imagedestroy($im); //echo ''.$randval.''; ?>

Read More