PHP在上传CSV数据后从SQL计算

Question

我有 CSV 到 SQL 上传页面，该页面为该上传的所有表行添加了时间戳。此代码有效:

//get the csv file
$file = $_FILES['csv']['tmp_name'];
ini_set('auto_detect_line_endings',TRUE);
$handle = fopen($file,"r");
$count = 0;

//loop through the csv file and insert into database
do { 
    if ($count>=0) { 
        mysql_query("INSERT INTO cain (fill_date, ndc, quantity, days_supply, mail_indicator, plan_paid, member_paid, dispensing_fee, compound_indicator, nabp, daw, formulary_indicator, member_id, unc_price, total_members, total_period_rebate) VALUES
            ('".$data[0]."','".$data[1]."','".$data[2]."','".$data[3]."','".$data[4]."','".$data[5]."','".$data[6]."','".$data[7]."','".$data[8]."','".$data[9]."','".$data[10]."','".$data[11]."','".$data[12]."','".$data[13]."','".$data[14]."','".$data[15]."')");
    }
} while ($data = fgetcsv($handle,1000,",")); 
// 

我正在尝试使用 php 根据最近上传(“时间戳”)计算 MySQL 数据的总数，无论是在同一页面还是另一页面上。这是我尝试过的代码，但它不起作用。如果我尝试通过最近更新的数据“时间戳”使用整组数据的计算，我该如何构建这些查询？我只需要对每一行进行加/减/乘/除，然后将所有这些结果相加。

{
$a= mysql_query("SELECT SUM(unc_price + dispensing_fee - plan_paid - member_paid) FROM cain WHERE timestamp = 'SELECT MAX(timestamp) FROM cain'");
}
echo $a;
?>

Answer 1

    {
$a= mysql_query("SELECT SUM(unc_price + dispensing_fee - plan_paid - member_paid) FROM cain WHERE timestamp = (SELECT MAX(timestamp) FROM cain')");
}
echo $a;
?>

您应该像上面一样使用括号