斜拉桥和悬索桥的特点:INSERT INTO 语句的语法错误php

来源：百度文库编辑：高校问答时间：2024/05/01 03:50:22

<?php
include("adodb/adodb.inc.php");
//include_once("include/config.php");
//$db = NewADOConnection("mysql");
//$db->Pconnect($dbhost,$dbuser,$dbpassword,$dbname) or die ("Error in sql".$sql.$db ->ErrorMsg());

$db = NewADOConnection("ado_access");
$access = "data/wwwroot.mdb";
$myDSN = "Provider=Microsoft.Jet.OLEDB.4.0;"."DATA SOURCE=".$access.";"." USER ID=;PASSWORD=;"; //连接字串
$conn = $db ->Connect($myDSN,"","","");

if($_POST['Submit'])
{
$name = trim($_POST['name']);
$number = trim($_POST['number']);
$content = trim($_POST['content']);

$sql = "select * from student";
$result = $db ->Execute($sql) or die ("Error in sql:".$sql.$db ->ErrorMsg());
$total = $result ->RecordCount();
echo $total;
$sql="insert into student (name,number,content) values('$name','$number','$content')";
//echo $sql;
//exit;
$result = $db ->Execute($sql) or die ("Error in sql:".$sql.$db ->ErrorMsg());
if($result)
{
echo "插入成功";
exit;
}
}
?>
我不明白为什么会出现语句语法错误啊。
Error in sql:insert into student(name,number,content) values('云端的日子','200020612','很爱很爱你')INSERT INTO 语句的语法错误。

是不是number的数据类型有问题啊
你具体核一下数据类型
你输入的200020612可够大的

需要长整型哦

INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误 INSERT INTO 语句的语法错误php System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。为什么老是提示我说INSERT INTO 语句的语法错误 [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误 INSERT INTO 语句的语法错误 web\conn.asp, line 22 asp----Microsoft JET Database Engine (0x80040E14)INSERT INTO 语句的语法错误。