我有一个名为user的表,其中我插入了一个值
($workshop_sales0.01)+($counter_sales0.005)+($sub_dealer_sales*0.0075)
在列incentive和值类似
if{$workshop_sales>1600000' in column 'open_cond' and value like '}
在close_cond中。
现在在我的PHP页面中,我从该表中提取了值。我如何使用open_cond和close_cond中的值,因为我希望将它用作表达式,否则请通过其他方式来执行它来帮助我。我做错了,请告诉我是否可以写'if语句'在PHP中使用它作为文本值存储在数据库列值? “”
我得到的结果是
if($workshop_sales>1600000){2123.085}
但我想在我的代码中将它用作PHP表达式。
$selectalldepartment = "select * from user ";
$selectedalldepartment = mysqli_query($conn,$selectalldepartment);
$selectedalldepartment = mysqli_query($conn,$selectalldepartment);
$depart=1;
while($row10 = mysqli_fetch_assoc($selectedalldepartment))
{
$sqlsel1 = "select * from parameters ";
$sqlsel1q = mysqli_query($conn,$sqlsel1);
$row2 = mysqli_fetch_assoc($sqlsel1q);
//assigned counter sales value
$counter_sales = $row2["counter_sales"];
?>
<?php echo $depart; ?><?php echo $row10["open_condition"]; eval("echo {$row10['incentive']};");echo $row10["close_condition"];?>$depaz++;
$depart++;
}
?>这是我的桌子:
user_id | user_name | incentive |open_cond | close_cond |
1 | Goldy Shahu | ($workshop_sales*0.01)+ | |
| | ($counter_sales*0.005)+ | |
| | ($sub_dealer_sales*0.0075)|if($workshop_sales> |
1600000){ |}