public function getProductImg()
{
$prod = $this->hasMany(ProductMeta::className(), ['prod_id' => 'prod_id'])->where(['meta_key' => 'prod_img']);
// echo '<pre>';
// print_r($prod); exit;
return $prod;
}
protected function updateProductMeta($prod_id, $meta_key, $meta_value)
{
if (($model = ProductMeta::findOne(['prod_id' => $prod_id, 'meta_key' => $meta_key])) !== null) {
$model->meta_value = $meta_value;
// echo 'updated';
} else {
$model = new ProductMeta();
$model->prod_id = $prod_id;
$model->meta_key = $meta_key;
$model->meta_value = $meta_value;
// echo "inserted";
}
$model->save();
}
<i class="ques"></i>
</p>
</div>
<table class="table dropdown">
<tr>
<td>
<label> Color: </label>
</td>
<td>
<div class="form-group">
<select class="form-control" id="sel1">
<?php
$colors = ProductMeta::getMetaByName($prod->prod_id, 'color');
$colors = explode(',', $colors[0]->meta_key);
?>
<?php
foreach ($colors as $color) {
?>
<option value="<?php
echo $color;
?>
"><?php
echo $color;
?>
</option>
<?php
}
public function getMetaByName($id, $key)
{
return ProductMeta::find()->select('meta_key', 'meta_value')->andWhere(['prod_id' => $id, 'meta_key' => $key])->all();
// return $this->hasMany(ProductMeta::className(), ['prod_id' => 'prod_id'])->where(['id'=> $id, 'meta_key' => $key]);
}
