建立表格应该是成功了,但是我要怎么样让它显示出来?想查看一下效果对错
<?php
$dbServer='zim.cs.uow.edu.au';
$dbUser='zc822';
$dbPass='yowaiboh';
print "<b>Start connecting...<br>";
print "Connected.<br>";
$con = mysql_connect($dbServer,$dbUser,$dbPass);
if (!$con)
{
die('Could not connect:' . mysql_error());
}
// Create table in my_db database
mysql_select_db("zc822", $con) or die("Could not select database". mysql_error());
$sql = "CREATE TABLE OrderStatus
(Anadrol int,
Dianabol int,
Deca int,
Trenbolone int,
Clen int,
Sustanon int,
Humangrowthhormone int,
Hcg int,
Winstrol int,
FirstName varchar(15),
LastName varchar(15),
Address varchar(50),
ContactNumber int,
Payment bit,
CardNumber int,
Month int,
Year int,
Comment text)";
if (mysql_query($sql,$con))
{
echo "<br>table created";
}
echo "Error creating table: " . mysql_error();
print "<br>Loading....Please wait....<br>";
$sql1="INSERT INTO OrderStatus(Anadrol,Dianabol ,Deca,Trenbolone,Clen,Sustanon,Humangrowthhormone,Hcg,Winstrol,FirstName, LastName, Address, ContactNumber, Payment, Cardnumber,Month, Year, Comment)
VALUES ('$_POST[Anadrol]','$_POST[Dianabol]','$_POST[Deca]','$_POST[Trenbolone]','$_POST[Clen]','$_POST[Sustanon]','$_POST[Human]','$_POST[Hcg]','$_POST[Winstrol]','$_POST[firstname]','$_POST[lastname]','$_POST[address]','$_POST[contactnumber]','$_POST[payment]','$_POST[Cardnumber]','$_POST[month]','$_POST[year]','$_POST[comment]')";
if (!mysql_query($sql1,$con))
{
die('Error: ' . mysql_error());
}
echo "Your order has been successfully submitted~";
?>
那个查询语句是什么....能具体点吗..
追答嗯,我看楼上已经把你的问题解决了,显示出了ID号,但貌似不是你要的结果,我就把你要的给写出来 吧,不过要重新写一个SQL执行了
你的插入执行完毕后再执行查询,来查看表里面数据
$sqlstr='select * from OrderStatus';
$rs=mysql_query($sqlstr)
while($array=mysql_fetch_array($rs)){
echo $array['Anadrol'].....;
}
详细的字段比较多,我就不写了
能具体一点不...
追答刚刚试了下,表格建立成功了也是 0 rows affected,于是查了下资料,该函数只对关联的 INSERT,UPDATE 或 DELETE 查询所影响的记录行数有用。看了下楼主的代码,可以根据insert语句判断
if (!mysql_query($sql1,$con))
{
die('Error: ' . mysql_error());
} else {
echo "Your order has been successfully submitted~,and the id is " . mysql_insert_id($con);//返回刚刚插入的id号,既然都能插入数据成功,那么说明表也建立成功了
}
能加下百度hi或者qq么...有新的问题了,弄完给你加分哈~
追答什么问题,在能力范围内的可以
本回答被提问者采纳