两个来自用户的数据使用PHP进行计算 - Two data from user to make Calculation using PHP

Two data from user to make Calculation using PHP

本文关键字：数据 PHP 计算用户两个 | 更新日期: 2023-09-27

我可以知道PHP中的等式是如何工作的吗？我的所有数据都可以很好地提取，但我如何从用户那里获得两个数据，即$method=$_GET['method'];和$valueinsert=$_GET['valueinsert'];。

$valueinsert=$_GET['valueinsert'];
                        $method=$_GET['method'];
                        error_reporting(E_ALL ^ E_DEPRECATED);
                        //connect to the server
                        $connect= mysql_connect("127.0.0.1","root","");
                        //$conn = new mysqli($servername, $username, $password);
                        if(!$connect)
                        {
                        die('Could not connect: '.mysql_error($connect));
                        }
                        //connect to the database
                        mysql_select_db("fyp",$connect);
                        $query5 = "SELECT method, SUM(revenue), SUM(cost) FROM `table 1` WHERE method = '$method'"; 
                        $result5 = mysql_query($query5) or die(mysql_error());
                        $sql="SELECT * FROM `table 1` WHERE method='$method'";
                        $query=mysql_query($sql,$connect);
                        echo"<table align=center width='80%'>";
                            echo"<td valign='top' width='20%'> ";
                            echo "<b><u>$method </u></b>" ;
                                echo "</br>";
                                while($row = mysql_fetch_array($result5)){
                                    echo "Total Profit = RM ". round($row['SUM(revenue)']- ($row['SUM(cost)']- '$valueinsert' ) ,2);
                                    echo "<br />";
                                }
                        echo"</table>";
                        ?>

您可以直接在sql too 中获得结果

  "SELECT 
    Method
  , SUM(cost) as cost
  , SUM(revenue) as revenue
  , (SUM(Revenue)-SUM(cost))/SUM(Revenue) as result  
  FROM `table 1` 
  WHERE Method = '$Method'";

将查询更改为此

方法1

$query4 = "SELECT Method, SUM(cost) as cost, SUM(revenue) as revenue FROM `table 1` WHERE Method = '$Method'";

以及在获取结果方面。应该像这个

   echo "Total Gross Margin = RM ". round($row['revenue']- $row['cost'] / $row['revenue'],2);

方法2

echo "Total Gross Margin = RM ". round($row['(SUM(Revenue)-SUM(cost))/SUM(Revenue)'],2);