update query in symphony (Method 2)
For example to execute query like UPDATE tableName SET column1 = 'abc',column2 = 'xyz' WHERE…
Read MoreShow tooltip on mouseover
Step 1: Copy this css style code into your header tage right before the end…
Read MoreSorting a two dimensional array in javascript
function sortArray(x,y) { return ((x < y) ? -1 : ((x > y) ? 1…
Read Moreunicode issue in Perl CGI
When some special character(or other language data) is displayed as ‘? ? ? ? ?’…
Read Moreupdate query based on condition
$con = sfContext::getInstance()->getDatabaseConnection(‘propel’); $c2 = new Criteria(); $c2->add(TblTopPeer::TF_ZIPCODE,$topForecastInfo->getForZipcode()); $c2->add(TblTopPeer::TF_FORCASTDATE,$topForecastInfo->getForForecastdate()); $c3 = new Criteria(); $c3->add(TblTopPeer::TF_FID,$topForecastInfo->getForId()); $c3->add(TblTopPeer::TF_USERID,$topForecastInfo->getForUserid());…
Read MoreHow to apply or condition for mysql query in symfony
$cs = new Criteria(); $criterion = $cs->getNewCriterion(HfArticlesPeer::AR_DESCRIPTION,’%’.$searchText.’%’,Criteria::LIKE); $criterion->addOr($cs->getNewCriterion(HfArticlesPeer::AR_TITLE,’%’.$searchText.’%’,Criteria::LIKE)); $criterion1 = $cs->getNewCriterion(HfArticlesPeer::AR_STATUS,’ARCHIVE’,Criteria::EQUAL); $criterion1->addOr($cs->getNewCriterion(HfArticlesPeer::AR_STATUS,’PUBLISHED’,Criteria::EQUAL)); $cs->add($criterion1); $cs->add($criterion); $cs->add(HfArticlesPeer::AR_CATEGORY…
Read MoreNo connection params set for propel
When you are using symfony framework , and when you get the error as “No…
Read Morehow to create html element dynamically in javascript
var itemManCnt=2; function addMoreHomeImage() { if(itemManCnt==6) { alert(“You can upload only 5 files”); return false;…
Read Morefile type validation in javascript
function isValidfile(filename) { file_value = filename; var checkfile = file_value.toLowerCase(); if (!checkfile.match(/(\.doc|\.DOC|\.pdf|\.PDF)$/)) { return false;…
Read Moreimage validation in javascript
function isValidImage(imagename) { imagefile_value = imagename; var checkimg = imagefile_value.toLowerCase(); if (!checkimg.match(/(\.jpg|\.gif|\.png|\.JPG|\.GIF|\.PNG|\.jpeg|\.JPEG)$/)) { return false;…
Read More