提交的表单返回';资源id#12';结果


Submitted form returns 'Resource id #12' as result

在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已折旧。