读书人

求帮忙php+mysql解决办法

发布时间: 2012-03-27 13:44:24 作者: rapoo

求帮忙,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());

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

读书人网 >PHP

热点推荐