yii2 query database return integer

Question

they can not return the query result as an integer, because I want to save 'id' of the query.

My Controller

$query = (new \yii\db\Query())
         ->select(['id_citta'])
         ->from('citta')
         ->where(['nome_citta' => 'London'])->one();


         $model->save();
         $viaggio_partenza->id_viaggio = $model->id_viaggio;
         $viaggio_partenza->citta_partenza = $query;
         $viaggio_partenza->save();

any suggestions?

public function actionOffri()
   {

    $model = new Viaggi;
    $viaggio_partenza = new ViaggiPartenza;

if($model->load(Yii::$app->request->post()) && $model->validate() && $viaggio_partenza->load(Yii::$app->request->post())){


$query = (new \yii\db\Query())
         ->select(['id_citta'])
         ->from('citta')
         ->where(['nome_citta' => 'Torino'])->one();


         $model->save();
         $viaggio_partenza->id_viaggio = $model->id_viaggio;
         $viaggio_partenza->citta_partenza = $query;
         $viaggio_partenza->save();


}else {....}

I would like to retrieve "id_citta" using the query and save it as "citta_partenza", recovery in the form a string that corresponds to integer in the database.

Can you provide more information about this? I don't quite get it. Where does the query return an integer? After save()? And what are you trying to do here? — Gynteniuxas
– Gynteniuxas, Commented Sep 26, 2016 at 17:33
What are you doing ? Executing $query ,saving $model and using $query — Yasin Patel
– Yasin Patel, Commented Sep 26, 2016 at 17:33

ScaisEdge · Accepted Answer · 2016-09-26 17:50:51Z

2

If you want the single value you should use scalar() and not one()

$query = (new \yii\db\Query())
     ->select(['id_citta'])
     ->from('citta')
     ->where(['nome_citta' => 'London'])->scalar();

Scalar() return the first column of the select.. while one() return the first model (the object related to first row) of the query

or if you need the model

$query = (new \yii\db\Query())
     ->select(['id_citta'])
     ->from('citta')
     ->where(['nome_citta' => 'London'])->one();

then refer to the attribute

   $model->save();
     $viaggio_partenza->id_viaggio = $model->id_viaggio;
     $viaggio_partenza->citta_partenza = $query->id_citta;
     $viaggio_partenza->save();

edited Sep 26, 2016 at 17:50

answered Sep 26, 2016 at 17:41

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Saba Over a year ago

I do not want to return the column but the integer value it has, I'm sorry but I'm a beginner.

ScaisEdge Over a year ago

@saba ..the first column ..(in you case the only column) is exactly the integer for id_citta ..(alias is the value you stored in citta.citta_id

Collectives™ on Stack Overflow

yii2 query database return integer

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related