Author: smarttips

zend mysql between query

Posted on by smarttips

$aEventsSelect = Engine_Api::_()->getItemTable(‘event’)->select(); if(count($aEventIds) > 0){ $aEventsSelect->where(“event_id IN (?)”, $aEventIds); } if( $filter == “past” ) { $aEventsSelect->where(“endtime <= FROM_UNIXTIME(?)”, time()); } else { $aEventsSelect->where(“endtime > FROM_UNIXTIME(?)”, time()); } if($eventdate != ‘0’) { $whereSql = “‘{$eventdate}’ BETWEEN DATE(starttime) AND DATE(endtime)”; $aEventsSelect->where($whereSql); }

+

fancybox custom css class

Posted on by smarttips

<script type=”text/javascript”> jQuery(document).ready(function(){ jQuery.fancybox.open({ href: ‘<?php echo $this->baseurl(); ?>/user/index/verifypopup’, type: ‘ajax’, wrapCSS : ‘fancybox-emailverify’, closeBtn : false, helpers : { overlay : {closeClick: false, css: {‘z-index’: ‘8010 !important;’} } }, keys : { close : null } }); }); </script>

+