在数据库中保存'if condition statement'并以php格式使用它

Question

I have a table named user where I have inserted a value like

($workshop_sales*0.01)+($counter_sales*0.005)+($sub_dealer_sales*0.0075)

in column incentive and value like

if{$workshop_sales>1600000' in column 'open_cond' and value like '}

in close_cond.

Now in my PHP page I have fetched values from that table. How can I use values from my columns open_cond and close_cond because I wish to use it as expression otherwise please help me by giving other way to execute it.I am doing wrong then please give me information whether its possible that I can write 'if statement' in php using it store as a text value in database column value ?? ''

I am getting result as

if($workshop_sales>1600000){2123.085}

but I want to use it as PHP expression in my code.

<?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"];
        ?>
        <tr>
            <td style="text-align:center;"><?php echo $depart; ?></td>
            <td style="text-align:center;"><?php echo $row10["open_condition"]; eval("echo {$row10['incentive']};");echo $row10["close_condition"];?></td>        </tr>
        <?php
        $depaz++;
        $depart++;
    }
    ?>

Here is my table:

<!-- language: lang-none -->

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){         |}

Answer 1

you should not store conditions into your table need to store data like

$workshop_sales and 1600000 in seporate columns

then you can make condition

like something

if($row10["open_condition"] > $row10["open_condition_value"]){
//your code 
}