Question

php提交表单写入数据库的简单问题

<?php
$mysql_host = 'localhost';
$mysql_user = 'root';
$mysql_password = '123456';
$mysql_database = 'cms';
mysql_connect($mysql_host,$mysql_user,$mysql_password) or die(mysql_error());
mysql_select_db($mysql_database) or die (mysql_error());
mysql_query("set name gbk");
if(isset($_post['pname']))
{
$pname = addslashes($_post['pname']);
$pprice = $_post['pprice'];
$pbrand = $_post['pbrand'];
$pmat = $_post['pmat'];
$plenght = $_post['plebght'];
$pcategroy = $_post['pcategroy'];
$ocategroy = $_post['ocategroy'];
$pintroducte = $_post['pintroducte'];
$sql = "insert into content values (null,'$pname','$pprice','$pbrand','$pmat','$plenght','$pcategroy','ocategroy','pintroducte',
now(),". floor(rand()*mysql_insert_id()).")";
mysql_query($sql) or die($mysql_error());
}
echo "数据添加成功，点击<a href='addproduct-1.php'>这里</a>返回";
?>
请问这段代码是否有错，为什么不能向mysql数据库中写入数据。跪求解！谢谢。

Answer 1

看日志啊