在PHP中提交表单后,一个字段的数据库字段的内容为"Resource id#12"。这意味着什么?我如何看待这个问题?
$userid = $_POST['userid'];
$paid = $_POST['paid'];
$amountpaid = $_POST['amountpaid'];
$method = $_POST['method'];
$checknum = $_POST['checknum'];
$invoicenum = $_POST['invoicenum'];
mysql_query("INSERT INTO auction_payments (id,purchaser_id,
invoicenum, amountpaid, method, checknum,on_date) VALUES('','$userid','$invoicenum','$amountpaid',
'$method','$checknum',NOW())") or die(mysql_error());
当您从mysql_query
回显或打印结果时,它将返回Resource id #12
。在INSERT
返回受影响的行数mysql_affected_rows
之后,测试结果是否为larger than 0
。我建议使用mysqli
,因为mysql
已折旧。