I have this query in my view.php
<?php
$packageq= Yii::$app->db->createCommand
("SELECT p.package_name,p.`total_charges`
as 'package_charges'
FROM `package` p, estimate e,patient_detail pd
where pd.package=p.id
and e.ipd_patient_id=pd.ipd_patient_id
and e.id=$model->id");
$packages= $packageq->queryAll();
//var_dump($packages);exit;
echo '<table class="table table-striped table-bordered table-hover">';
echo "<tr><th>Package Name</th><th>Amount</th></tr>";
if (![$packages]==''){
foreach($packages as $package){
echo "<tr><td>";
echo $package['package_name'];
echo "</td><td>";
$d= $package['package_charges'];
echo $d;
echo "</td></tr>";
}
}else{
$d=0;
}
var_dump($d);exit;
echo "<tr><td>";
echo 'Total D';
echo "</td><td>";
echo "<tr><td>";
echo 'Total A+B+C+D';
echo "</td><td>";
echo ($a+$b+$c+$d);
echo "</table>";
?>
When I am doing a var_dump for $packages, I am getting
array (size=0)
empty
When I am doing a var_dump for $d I am getting the error variable d is not defined any specific reason for this or I am doing anything wrong here. Thanks for the suggestion.