以yii检索时间值[关闭]

Question

hello friends I am newbie to Yii.I have the date and time in mysql database. I just want to know how to retrieve the date and time from mysql.How to write the query in view.php file of yii framework.

Answer 1

Use this guide to configure yii.

Then make sure you configured gii in the above guide and go to yourwebapp/index.php/gii/. This assumes you’re using the URL management component in Yii. If not, head to yourwebapp/index.php?r=gii. Click the generate model link. Then type the name of your table into the form. Click generate. This will generate you an Active directory class for that table. This process is explained with screen shots here.

Now lets say that generated a model from a table called transaction. That model should be located in your models folder. You can call this model in your controllers. Something like:

SiteController:

function actionIndex()
  {
    $model = new Transaction();
    $model->find('id=:id', array(':id'=>10));
    $this->render('index', array('model'=>$model));
  }

In the sites folder under views you would insert this $model object somewhere in the index view:

<div><?php echo $model->theNameOfYourDateColumn ?></div>

Here is the diffinitive yii guide's page for Active Record.