求帮忙，php+mysql解决办法

求帮忙，php+mysql

PHP code

<?php$con = mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);mysql_select_db("app_zqstudysae", $con);$sql = "insert into imgstore values('for','测试')";mysql_query($sql,$con);?>

imgstore 表是这样子的.
imgnamevarchar(10000)utf8_general_ci否无  
introducetextutf8_general_ci否无


为什么只能插入名字for,introduce没有插入到数据库中?




[解决办法]
insert into imgstore(imgname,introduce) values('for','测试')";
[解决办法]
insert into imgstore(imgname,introduce) SELECT 'for','测试'
[解决办法]

探讨

PHP code

<?php
$con = mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);
mysql_select_db("app_zqstudysae", $con);

$sql = "insert into imgstore values('for','测试')";
my……

[解决办法]
mysql_query($sql,$con) or die(mysql_error());

如有错误，请贴出错误信息。

查看更多 下一篇