PHPmyadmin 和 csv 导出

Question

我有这段代码，我想说如果股票为负，则更改为零。

我似乎可以让任何事情发挥作用。它通过 cron 作业从 PHP 文件运行。

    // open connection to mysql database
    $connection = mysqli_connect($host, $username, $password, $dbname) or die("Connection Error " . mysqli_error($connection));

    // fetch mysql table rows
    $sql = "select Name, Stock from LMSTOCK";
    $result = mysqli_query($connection, $sql) or die("Selection Error " . mysqli_error($connection));

    $fp = fopen('inventory1.csv', 'w');

         fputcsv($fp, array('SKU', 'QTY in Stock'));

    while($row = mysqli_fetch_assoc($result))    
    {
         fputcsv($fp, $row);
    }

    fclose($fp);

    //close the db connection
    mysqli_close($connection);
?>

谢谢克里斯

Answer 1

这有效。

// open connection to mysql database
    $connection = mysqli_connect($host, $username, $password, $dbname) or die("Connection Error " . mysqli_error($connection));

    // fetch mysql table rows
    $sql = "select Name, Stock from LMSTOCK";
    $result = mysqli_query($connection, $sql) or die("Selection Error " . mysqli_error($connection));

    $fp = fopen('inventory1.csv', 'w');

         fputcsv($fp, array('SKU', 'QTY in Stock'));

    while($row = mysqli_fetch_assoc($result))

    {
         $row['Stock']=max($row['Stock'],0);
         fputcsv($fp, $row);
    }

    fclose($fp);

    //close the db connection
    mysqli_close($connection);
?>