$query=mysql_query($sql,$conn); $result.executeSql$query) ordie("There are error")$conn = mysql_connect("localhost","root","密码")or die("Could not connect : " . mysql_error()); mysql_select_db("数据库名") or die("Could not select database"); $insert="insert into produit(adresse , rproduit , type , matiere , prix ) values('$imagep' , '$idpro' , '$typep' , '$matiere', '$prix')"; mysql_query($insert,$conn)or die(" Could not select les values".mysql_error()); $err=mysql_error(); if($err) { echo "有错误".$err; } else { echo"添加成功"; }
去掉$query=mysql_query($sql,$conn); $result.executeSql$query) ordie("There are error")
<?php $conn=mysql_connect($dbhost,$dbuser,$dbpassword) or die("connect error"); $sele=mysql_select_db($db,$conn) or die("select error"); $sql="insert into news values('".$_POST['title']."','".$_POST['author']."','".$_POST['content']."')"; $query=mysql_query($sql,$conn) or die ("insert error"); if($query) echo " <h1> <center>添加成功! </center> </h1>"; else echo " <h1> <center>添加失败! </center> </h1>"; ?>
$sql="insert into news values('$title','$author','$content')"; 你确定这句添加数据的顺序对么?建议使用 $sql="insert into news(字段1,字段2,字段3,字段) values(字段值1,字段值2,字段值2)"; 上面那样顺序错了就会出错的,尤其是字段类型不一样,我就碰到过!
$result.executeSql$query) ordie("There are error")$conn = mysql_connect("localhost","root","密码")or die("Could not connect : " . mysql_error());
mysql_select_db("数据库名") or die("Could not select database");
$insert="insert into produit(adresse , rproduit , type , matiere , prix ) values('$imagep' , '$idpro' , '$typep' , '$matiere', '$prix')";
mysql_query($insert,$conn)or die(" Could not select les values".mysql_error());
$err=mysql_error();
if($err)
{
echo "有错误".$err;
}
else
{
echo"添加成功";
}
$result.executeSql$query) ordie("There are error")
$conn=mysql_connect($dbhost,$dbuser,$dbpassword) or die("connect error");
$sele=mysql_select_db($db,$conn) or die("select error");
$sql="insert into news values('".$_POST['title']."','".$_POST['author']."','".$_POST['content']."')";
$query=mysql_query($sql,$conn) or die ("insert error");
if($query) echo " <h1> <center>添加成功! </center> </h1>";
else echo " <h1> <center>添加失败! </center> </h1>";
?>
你确定这句添加数据的顺序对么?建议使用
$sql="insert into news(字段1,字段2,字段3,字段) values(字段值1,字段值2,字段值2)";
上面那样顺序错了就会出错的,尤其是字段类型不一样,我就碰到过!