我有一家公司，它以CSV文件的形式提供关于库存、价格等所有详细信息的产品提要。我使用以下脚本用CSV文件更新我的数据库：
<?php
echo "Update wordt uitgevoerd.... <br><br>";
$mysqlHost = "localhost";
$user = "username";
$password = "password";
$link = mysql_connect($mysqlHost, $user, $password)
or die('Could not connect: ' . mysql_error());
$handle = fopen("update.csv", "r");
while (($data = fgetcsv($handle, 1000, ";")) !== false) {
$model = mysql_real_escape_string ($data[0]);
$price = mysql_real_escape_string ($data[5]);
$quantity = mysql_real_escape_string ($data[7]);
mysql_select_db("wowtoxco_oc1", $link);
$result = mysql_query(
"UPDATE oc_product SET price='$price', quantity='$quantity'
WHERE model='$model'"
) or die(mysql_error());
echo $model . " - art.nr. locked -> ";
echo $price . " prijs updated -> ";
echo $quantity . " voorraad updated.<br>";
}
fclose($handle);
mysql_close($link);
echo "<br>Script uitgevoerd.";
?>
问题是：CSV文件中的价格例如为1.25，其中OpenCart预计为1.25。
脚本有没有办法在运行查询之前用句点替换逗号？
$price = str_replace(",", ".", $price);
// here your run your query
$result = mysql_query("UPDATE ..." ) or die(mysql_error());