<?php
function connectDB()
{
mysql_connect ("localhost", "root", "toyota");
mysql_select_db("Books");
}
function closeDB()
{
mysql_close();
}
connectDB();
$query="INSERT INTO Computers (name,price,publish_date) VALUES ( '数据结构 ',20.00, '2001-1-1 ')";
$result=mysql_query($query);
if(!$result)
{
echo "insert data failed! <br >";
}
else
{
?>
<table><tr><td>书名</td><td>价格</td><td>出版日期</td></tr>
<?php
$query="SELECT * FROM Computers WHERE price>= 20";
$result=mysql_query($query);
while($row=mysql_fetch_object)
{
echo "<tr><td>$row->name</td><td>$row->price</td><td>$row->publish_date</td></tr>";
}
}
?>
</table>
function connectDB()
{
mysql_connect ("localhost", "root", "toyota");
mysql_select_db("Books");
}
function closeDB()
{
mysql_close();
}
connectDB();
$query="INSERT INTO Computers (name,price,publish_date) VALUES ( '数据结构 ',20.00, '2001-1-1 ')";
$result=mysql_query($query);
if(!$result)
{
echo "insert data failed! <br >";
}
else
{
?>
<table><tr><td>书名</td><td>价格</td><td>出版日期</td></tr>
<?php
$query="SELECT * FROM Computers WHERE price>= 20";
$result=mysql_query($query);
while($row=mysql_fetch_object)
{
echo "<tr><td>$row->name</td><td>$row->price</td><td>$row->publish_date</td></tr>";
}
}
?>
</table>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货