/var/www/html/car/framework/db/CDbCommand.php(543)
531 { 532 if($this->_connection->enableProfiling) 533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 534 535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 536 $message=$e->getMessage(); 537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 539 540 if(YII_DEBUG) 541 $message.='. The SQL statement executed was: '.$this->getText().$par; 542 543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 545 } 546 } 547 548 /** 549 * Builds a SQL SELECT statement from the given query specification. 550 * @param array $query the query specification in name-value pairs. The following 551 * query options are supported: {@link select}, {@link distinct}, {@link from}, 552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 553 * {@link limit}, {@link offset} and {@link union}. 554 * @throws CDbException if "from" key is not present in given query parameter 555 * @return string the SQL statement
#0 |
+
–
/var/www/html/car/framework/db/CDbCommand.php(396): CDbCommand->queryInternal("fetchAll", array(2), array()) 391 * An empty array is returned if the query results in nothing. 392 * @throws CException execution failed 393 */ 394 public function queryAll($fetchAssociative=true,$params=array()) 395 { 396 return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params); 397 } 398 399 /** 400 * Executes the SQL statement and returns the first row of the result. 401 * This is a convenient method of {@link query} when only the first row of data is needed. |
#1 |
+
–
/var/www/html/car/class/models/CCModel.php(105): CDbCommand->queryAll() 100 { 101 $sql .= " where $whereSql "; 102 } 103 $connection = Yii::app()->db; 104 $command = $connection->createCommand($sql); 105 return $command->queryAll(); 106 } 107 108 public function queryAddSql($sql = ''){ 109 $connection = Yii::app()->db; 110 $command = $connection->createCommand($sql); |
#2 |
+
–
/var/www/html/car/class/controllers/IndexController.php(54): CCModel->querySql(" select z.id as zcID,z.cid,z.`createTime`, z.`status`, z.`hot`, ...") 49 50 /** 51 *汽车读取 52 */ 53 $carsql1 = " select z.id as zcID,z.cid,z.`createTime`, z.`status`, z.`hot`, z.`fee`, z.`type`, z.`fromcity`, z.`tocity`, z.`desc`,c.* from yh_zuche as z JOIN yh_car as c where c.id = z.cid and z.status = 1 and z.type=1 limit 0,4"; 54 $zc_car = $zuche->querySql($carsql1); 55 $this->assign('zc_car', $zc_car); 56 57 $carsql2 = " select z.*,c.* from yh_hunqing as z JOIN yh_car as c where c.id = z.cid and z.status = 1 limit 0,4"; 58 $hq_car = $hunqing->querySql($carsql2); 59 $this->assign('hq_car', $hq_car); |
#3 |
+
–
/var/www/html/car/framework/web/actions/CInlineAction.php(49): IndexController->actionIndex() 44 $controller=$this->getController(); 45 $method=new ReflectionMethod($controller, $methodName); 46 if($method->getNumberOfParameters()>0) 47 return $this->runWithParamsInternal($controller, $method, $params); 48 else 49 return $controller->$methodName(); 50 } 51 52 } |
#4 |
+
–
/var/www/html/car/framework/web/CController.php(308): CInlineAction->runWithParams(array("cid" => "14", "page" => "1")) 303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction; |
#5 |
+
–
/var/www/html/car/framework/web/CController.php(286): CController->runAction(CInlineAction) 281 * @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); |
#6 |
+
–
/var/www/html/car/framework/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array()) 260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); |
#7 |
+
–
/var/www/html/car/framework/web/CWebApplication.php(282): CController->run("") 277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); |
#8 |
+
–
/var/www/html/car/framework/web/CWebApplication.php(141): CWebApplication->runController("index") 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 137 $_GET[$name]=$value; 138 } 139 else 140 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 141 $this->runController($route); 142 } 143 144 /** 145 * Registers the core application components. 146 * This method overrides the parent implementation by registering additional core components. |
#9 |
+
–
/var/www/html/car/framework/base/CApplication.php(180): CWebApplication->processRequest() 175 public function run() 176 { 177 if($this->hasEventHandler('onBeginRequest')) 178 $this->onBeginRequest(new CEvent($this)); 179 register_shutdown_function(array($this,'end'),0,false); 180 $this->processRequest(); 181 if($this->hasEventHandler('onEndRequest')) 182 $this->onEndRequest(new CEvent($this)); 183 } 184 185 /** |
#10 |
+
–
/var/www/html/car/index.php(17): CApplication->run() 12 $app = Yii::createWebApplication($config); 13 14 $app->getSession()->open(); 15 $app->setControllerPath(WORK_ROOT.'class/controllers/'); 16 17 $app->run(); |