$sql= "SELECT id FROM t_example_case WHERE id = (SELECT min(id) FROM t_example_case WHERE published=1 and id > $id order by recommend desc,sort desc,create_time desc)"; $command = $connection->createCommand($sql); $nextId= $command->queryScalar(); if (!$nextId) { $sql = "SELECT min(id) FROM t_example_case WHERE published=1"; $command = $connection->createCommand($sql); $nextId= $command->queryScalar(); } //获得喜欢列表 $keyword=$case->keyword; $items=explode(",",$keyword); $items = array_filter($items); $where=' published=1 and id!='.$id.' '.(count($items)>0? ' and (':''); foreach($items as $index=>$item){ if(empty($item))continue; $where.=($index>=1 ? 'or' : '').' keyword like "%'.$item.'%"'; } $where.=count($items)>0? ')':''; $likeQuery=ExampleCase::find()->where($where)->limit(5);
if (!$nextId) { $sql = "SELECT min(id) FROM t_example_case WHERE published=1"; $command = $connection->createCommand($sql); $nextId= $command->queryScalar(); } //获得喜欢列表 $keyword=$case->keyword; $items=explode(",",$keyword); $items = array_filter($items); $where=' published=1 and id!='.$id.' '.(count($items)>0? ' and (':''); foreach($items as $index=>$item){ if(empty($item))continue; $where.=($index>=1 ? 'or' : '').' keyword like "%'.$item.'%"';
$args = $this->controller->bindActionParams($this, $params); Yii::trace('Running action: ' . get_class($this->controller) . '::' . $this->actionMethod . '()', __METHOD__); if (Yii::$app->requestedParams === null) { Yii::$app->requestedParams = $args; } return call_user_func_array([$this->controller, $this->actionMethod], $args); } }
} $result = null; if ($runAction && $this->beforeAction($action)) { // run the action $result = $action->runWithParams($params); $result = $this->afterAction($action, $result); // call afterAction on modules foreach ($modules as $module) { /* @var $module Module */
$parts = $this->createController($route); if (is_array($parts)) { /* @var $controller Controller */ list($controller, $actionID) = $parts; $oldController = Yii::$app->controller; Yii::$app->controller = $controller; $result = $controller->runAction($actionID, $params); Yii::$app->controller = $oldController; return $result; } else { $id = $this->getUniqueId(); throw new InvalidRouteException('Unable to resolve the request "' . ($id === '' ? $route : $id . '/' . $route) . '".');
$params = $this->catchAll; unset($params[0]); } try { Yii::trace("Route requested: '$route'", __METHOD__); $this->requestedRoute = $route; $result = $this->runAction($route, $params); if ($result instanceof Response) { return $result; } else { $response = $this->getResponse(); if ($result !== null) { $response->data = $result;
try { $this->state = self::STATE_BEFORE_REQUEST; $this->trigger(self::EVENT_BEFORE_REQUEST); $this->state = self::STATE_HANDLING_REQUEST; $response = $this->handleRequest($this->getRequest()); $this->state = self::STATE_AFTER_REQUEST; $this->trigger(self::EVENT_AFTER_REQUEST); $this->state = self::STATE_SENDING_RESPONSE; $response->send();
require(__DIR__ . '/../myfolder/vendor/autoload.php'); require(__DIR__ . '/../myfolder/vendor/yiisoft/yii2/Yii.php'); $config = require(__DIR__ . '/../myfolder/config/web.php'); (new yii\web\Application($config))->run();
$_GET = [ 'id' => '179', ];