Get multiple values from a function in yii2

Question

I have a function in my Model which is passed a single value and in which I have a query which is giving me two results.

 public static function updImgtbl($id)
{
    $total_images = 0;
    $images_uploaded = 0;

    $sqlquery = "SELECT  SUM(CASE WHEN ims.`installation_id` = $id THEN 1 ELSE 0 END) AS total_images, 
    SUM(CASE WHEN ims.`image_upload_flag` = 1 AND ims.`installation_id` = $id THEN 1 ELSE 0 END) AS images_uploaded
    FROM    `installation_images_site` ims
    INNER JOIN `installations` ins ON ins.`id` = ims.`installation_id`
    WHERE   (ims.`image_upload_flag` = 1 AND ims.`installation_id` = $id)
    OR (ims.`installation_id` = $id) 
    GROUP BY ims.`installation_id`";

    $pt = Yii::$app->db->createCommand($sqlquery)->queryAll();

    foreach ($pt as $val)
    {
        $total_images= $val['total_images'];
        $images_uploaded = $val['images_uploaded'];
    }
    return ["total_images" => $total_images, "images_uploaded"=>$images_uploaded];
}

This function is called from an API

 $response = Installations::updImgtbl($install_id);
        print_r($response);
        exit();

The response is below

Array
(
  [total_images] => 4
  [images_uploaded] => 1
)

But I want to get these values in a variable in my API. How can I achieve it?

Ali MasudianPour · Accepted Answer · 2018-02-10 09:01:14Z

2

You can simply:

list($total_images, $images_uploaded) = array_values($response);

Then, you have total_images value in $total_images variable and images_uploaded in $images_uploaded variable.

I mean:

list($total_images, $images_uploaded) = Installations::updImgtbl($install_id);
echo $total_images; // 4
echo $images_uploaded; // 1

You can read more about list in official doc.

Another way is using extract() function. For example:

$response = Installations::updImgtbl($install_id);
extract($response);   
echo $total_images; // 4
echo $images_uploaded; // 1

edited Feb 10, 2018 at 9:01

answered Feb 10, 2018 at 8:53

Ali MasudianPour

14.5k3 gold badges64 silver badges62 bronze badges

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

1 Comment

Moeez Over a year ago

` list('total_images'=>$total_images, 'images_uploaded'=>$images_uploaded) = Installations::updImgtbl($install_id); print_r($total_images); print_r($images_uploaded); exit();` it works for me :)

Collectives™ on Stack Overflow

Get multiple values from a function in yii2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related