表单和mysql数据库_php用表单插入mysql数据库不成功 是不是要对php和mysql进行配置啊...

<?php /*********************表单数据处理*********************/$isbn=$_POST['isbn'];$author=$_POST['author'];$title=$_POST['title'];$price=$_POST['price'];echo"$isbn
$au...

/********************* 表单数据处理 *********************/

$isbn = $_POST['isbn'];

$author = $_POST['author'];

$title = $_POST['title'];

$price = $_POST['price'];

echo "$isbn
$author
$title
$price";

if (!$isbn || !$author || !$title || !$price) {

echo "You have not entered all the required detail.
"

."Please go back and try again.";

exit;

}

/************************ MySQL连接 ************************/

$dbc = @ mysql_connect('localhost', 'root', '123456');

mysql_select_db("company",$dbc);

if (mysqli_connect_errno()) {

echo "Error: Could not connect to database.Please try again later.";

exit;

}

/********************************** 执行插入查询 **********************************/

$query = "insert into books values ('".$isbn."', '".$author."', '".$title."', '".$price."')";

$results = mysql_query($query);

if ($results) {

echo mysqli_affected_rows($dbc)." book inserted into database.";

} else {

echo "An error has occurred.The item was not added.";

}

/**************** 关闭 ****************/

mysqli_close($dbc);

?>

谢了 已经搞定了 是php和mysql配置版本问题

展开