hi我正在使用以下php代码将记录插入SQL数据库。。。但是代码不起作用。。
<?php
include_once("config.php");
$academicDate = $_POST['aDate'];
$academicDescription = $_POST['aDescription'];
$academicTitle = $_POST['aTitle'];
$sql = "INSERT INTO academicnews (id, newsDate, newsDescription, newsTitle) VALUES ('', $academicDate, $academicDescription, $academicTitle)";
if (mysql_query($sql)) {
echo "Record Aded to Database. Hit OK to add more";
}else{
echo "Failed to add record to database";
}
?>
请注意，id是一个autoincrement编号。。。。。config.php文件代码为.
<?php
########## MySql details (Replace with yours) #############
$username = "root"; //mysql username
$password = "s1j55b123456789"; //mysql password
$hostname = "localhost"; //hostname
$databasename = 'dominie'; //databasename
$connecDB = mysql_connect($hostname, $username, $password)or die('could not connect to database');
mysql_select_db($databasename,$connecDB) or die(mysql_error());
?>
我该如何解决这个（它echos未能添加记录）问题。。。任何帮助都将不胜感激。。提前感谢…：）
请尝试一下：
$sql = "INSERT INTO academicnews (newsDate, newsDescription, newsTitle) VALUES ('$academicDate', '$academicDescription', '$academicTitle')";
我看到的是，当值不是数值时，您不会在值周围使用引号。
尝试：
$sql = "INSERT INTO academicnews (id, newsDate, newsDescription, newsTitle) VALUES ('%', '$academicDate', '$academicDescription', '$academicTitle')";
试试这个
$sql = "INSERT INTO academicnews (newsDate, newsDescription, newsTitle) VALUES ($academicDate, $academicDescription, $academicTitle)" ;