Inserting variables in Yii2 to Database

Question

I am trying to insert $product, $pric and $user to database table cart. Following is the function that I have created in SiteController.php.

public function actionCartadd($id)
        {
                $product = Additem::find()
                        ->select('product')
                        ->where(['id' => $id])
                        ->one();
                $pric =  Additem::find()
                        ->select('price')
                        ->where(['id' => $id])
                        ->one();

                $user = Yii::$app->user->identity->username;


                $connection = Yii::$app->getDb();

                $result = Yii::$app->db->createCommand()
                        ->insert('cart', [
                        'product' => '$product',
                        'price' => '$pric',
                        'user' => '$user',
                        ])->execute();
                if ($result)
                         return $this->render('custstore');
        }

However, this end up in error. Can anyone suggest any fix

What error? Please show us

law_81
– law_81

2019-11-21 07:33:17 +00:00
Commented Nov 21, 2019 at 7:33 — law_81
– law_81, Commented Nov 21, 2019 at 7:33

Shringiraj Dewangan · Accepted Answer · 2019-11-20 20:24:34Z

1

Try this following code

$result = Yii::$app->db->createCommand()->insert('cart', [
    'product' => $product->product, 
    'price' => $pric->price,
    'user' => $user
])->execute();

answered Nov 20, 2019 at 20:24

Shringiraj Dewangan

78410 silver badges27 bronze badges

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

Comments

Michael Krutikov · Accepted Answer · 2019-11-20 15:20:47Z

0

Look at this fragment:

'product' => '$product',
'price' => '$pric',
'user' => '$user',

Use double quotes in values or just variables without quotes

Also, better way to fetch product and price:

$productItem = Additem::findOne($id);
if ($productItem instanceof Additem) {
    $product = $productItem->product;
    $pric = $productItem->price;
}

answered Nov 20, 2019 at 15:20

Michael Krutikov

5121 gold badge4 silver badges11 bronze badges

2 Comments

Gautham Sreenivasan Over a year ago

I am trying to insert the contents to the database table and I am not trying to fetch it. Also marking the values using double quotes or without any quotes didn't work.

law_81 Over a year ago

He meana you don't need to call two times the function find. you can get the Model as he write in the answer and get all properties of the Model. It's better.

Collectives™ on Stack Overflow

Inserting variables in Yii2 to Database

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related