UC知道PHP增加数据的问题
来源：百度知道 编辑：UC知道 时间：2024/06/30 08:18:11
<?php
$strContent = $HTTP_POST_VARS['strContent'];
echo "<li />成功显示：strContent=".$strContent;
$sql = "INSERT INTO 'db_message' . 't_message' ( ";
$sql = $sql." 'intMessageID' , 'strContent' ) ";
$sql = $sql." VALUES ( NULL , '".$strContent."'); ";
//echo "<li />看看" .$sql
$connect = mysql_connect("localhost","root","123") or die("不成功");
$query = mysql_db_query( "db_message", $sql , $connect ) or die("NO.NO.NO！！");
echo "<li />保存成功了";
?>
提示：NO.NO.NO！！
$strContent = $HTTP_POST_VARS['strContent'];
echo "<li />成功显示：strContent=".$strContent;
$sql = "INSERT INTO 'db_message' . 't_message' ( ";
$sql = $sql." 'intMessageID' , 'strContent' ) ";
$sql = $sql." VALUES ( NULL , '".$strContent."'); ";
//echo "<li />看看" .$sql
$connect = mysql_connect("localhost","root","123") or die("不成功");
$query = mysql_db_query( "db_message", $sql , $connect ) or die("NO.NO.NO！！");
echo "<li />保存成功了";
?>
提示：NO.NO.NO！！
$sql = "INSERT INTO 'db_message' . 't_message' ( ";
$sql = $sql." 'intMessageID' , 'strContent' ) ";
$sql = $sql." VALUES ( NULL , '".$strContent."'); ";
错误在这里，前面两行里面的 数据库名，表名，属性列名 不能用单引号，应该是Tab键盘上方（ESC键下方）的那个键...改过来就正确了
改后如下：
$sql = "INSERT INTO `db_message` . `t_message` ( ";
$sql = $sql." `intMessageID` , `strContent` ) ";
$sql = $sql." VALUES ( NULL , '".$strContent."'); ";
应该是生成的sql语句有问题:
试试把
$sql = "INSERT INTO 'db_message' . 't_message' ( ";
$sql = $sql." 'intMessageID' , 'strContent' ) ";
$sql = $sql." VALUES ( NULL , '".$strContent."'); ";
改成
$sql = "INSERT INTO t_message ( ";
$sql = $sql." intMessageID , strContent ) ";
$sql = $sql." VALUES ( NULL ,