Question

Please forgive my ignorance, I am still very much a beginner, and I don t even know if this is possible.

我需要在数据库中以另一种货币(以欧元计算,产出以美元计)列入价格清单。

I have the form to take the input for the conversion multiplier value and to put the values into an array should be relatively simple (even for me!)

<?php
    // Make a MySQL Connection
    $query = "SELECT price FROM table"; 

    $result = mysql_query($query) or die(mysql_error());

    while($row = mysql_fetch_array($result)){
    echo $row[euros].

    //here is where I need to perform the calculation with the result going into     $row[dollars](euros * ex.rate = dollars)

   UPDATE table SET dollars=INT($row[dollars]);
}
?>

不幸的是,我需要更多地回避这项工作。

我可以列举的是,如何将表格输入与每欧元数值成倍,并将结果写进适当的美元单位,作为分类。

Answer 1

我将做些什么是为此撰写一个单项文件:

UPDATE `table` SET dollars=euros*1.23 WHERE 1

You can, of course, do this in PHP:

<?php
// first, prevent anyone from tampering with the query!
$factor = floatval($user_input);
// then the query itself
$result = mysql_query("UPDATE `table` SET dollars=euros*{$factor} WHERE 1");
?>

While I m writing, when using associative arrays, you should use single quotes, e.g. not $row[dollars] but $row[ dollars ]. Enclose these inside curlies:

echo "dollars: {$row[ dollars ]}";

友情链接