Question

php+mysql 网页问题

数据库AAA 下有 数据表BBB 下有 栏CCC 和 栏DDD 和 栏EEE

要在网页上实现 CCC+DDD*EEE=多少。3个栏数据显示出来，并计算出来，显示出列式。。。

请高手们帮写下代码！！！

Answer 1

<?php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("AAA", $con);

$result = mysql_query("SELECT * FROM BBB");

echo "<table border='1'>
<tr><th>CCC</th><th>DDD</th><th>EEE</th><th>CCC+DDD*EEE</th></tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['CCC'] . "</td>";
echo "<td>" . $row['DDD'] . "</td>";
echo "<td>" . $row['EEE'] . "</td>";
echo "<td>" . intval($row['CCC'])+intval($row['DDD'])*intval($row['EEE']) . "</td>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>

Answer 2

不说明白谁知道是什么问题呀！

Answer 3

什么问题？

Answer 4

问题呢？看不到啊