php - Doctrine --- search -

-

we use zend frame work , doctrine data base. problem want search string (for example: testin'g) string "single quotes". doctrine query fails retrives data query joins , works fine normal query out joins.

my method 

public function getnewslistgrid($campid,$currentpage,$resultsperpage,$quicksearchtype,$queryv,$sortname,$sortorder,$letterpressed) {     $query = new doctrine_query();     $wherecond ='';     $where='eng.id='.$campid;     $select='';     $search = '';      if($letterpressed == 'all')     {         $where .="";     }     else if($letterpressed == 'radian6')     {         $where .=" , c.news_type = 1";     }     else if($letterpressed == 'google news')     {         $where .=" , c.news_type = 3";     }     else if($letterpressed == 'google blogs')     {         $where .=" , c.news_type = 4";     }     else if($letterpressed == 'hide twitter')     {         $where .=" , c.url not '%twitter.com%'";     }     else if($letterpressed == 'hide facebook')     {         $where .=" , c.url not '%facebook.com%'";     }     else if($letterpressed == 'hide facebook-twitter')     {         $where .=" , c.url not '%twitter.com%' , c.url not '%facebook.com%'";     }     else if($letterpressed == 'show twitter')     {         $where .=" , c.url '%twitter.com%'";     }     else if($letterpressed == 'show facebook')     {         $where .=" , c.url '%facebook.com%'";     }     else if($letterpressed == 'show facebook-twitter')     {         $where .=" , c.url  '%twitter.com%' or c.url '%facebook.com%'";     }       if($queryv!='' && (trim($letterpressed) != 'law' && trim($letterpressed) != 'ls translate')){          $search = ' c.title "%'.mysql_real_escape_string($queryv).'%" ';     }      $select='c.id, c.campaign_id, c.title title, c.domain, c.news_type,c.url, c.active, c.article_date, c.created_date, c.modified_date, t.language_id, t.tr_translated_date, t.tr_translated_by, t.translation_state, t.tr_title, t.raw_title';     if(trim($letterpressed) == 'original')     {         $select='c.id, c.campaign_id, c.title title, c.domain, c.news_type,c.url, c.active, c.article_date, c.created_date, c.modified_date, t.language_id, t.tr_translated_date, t.tr_translated_by, t.translation_state';     }     if(trim($letterpressed) == 'law')     {         $select='c.id, c.campaign_id, c.domain, c.news_type,c.url, c.active,c.article_date, c.created_date, c.modified_date, t.raw_title title, t.language_id, t.tr_translated_date, t.tr_translated_by, t.translation_state';         if($queryv!='')             $search = ' t.raw_title "%'.mysql_real_escape_string($queryv).'%" ';     }     if(trim($letterpressed) == 'ls translate')     {         $select='c.id, c.campaign_id, c.domain, c.news_type,c.url, c.active, c.article_date, c.created_date, c.modified_date, t.tr_title title, t.language_id, t.tr_translated_date, t.tr_translated_by, t.translation_state';         $where .=" , t.translation_state = 1";         if($queryv!='')             $search = ' t.tr_title "%'.mysql_real_escape_string($queryv).'%" ';     }     $wherecond.=$where;        $query->select($select)           ->from('news c')           ->leftjoin('c.translatednews t')           ->leftjoin('c.campaigns eng')            ->where($wherecond)            ->addwhere('eng.tr_language_id=t.language_id')            ->orderby('c.'.$sortname. ' ' . $sortorder)           ->groupby('c.title')           ->addgroupby('c.url');         if(!empty($search))             $query->addwhere($search);          //echo $query->getsqlquery();exit;       /*                           here when output query , run in query browser works fine.       */            $pager = new doctrine_pager($query,$currentpage, $resultsperpage);// here fails retrive data      return $pager;//print_r($pager);exit;

instead of addwhere try use andwhere()


Comments

Post a Comment

Popular posts from this blog

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more