mysqli_stmt_bind_param question
| From: | Jason Pruim | Date: | Fri, 04 Apr 2008 13:41:27 +0000 |
| Subject: | mysqli_stmt_bind_param question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44862@lists.php.net to get a copy of this message | ||
Hi Everyone,
I have a MySQL database that I am accessing from PHP. The table in question has a auto increment field on it and I don't want to include that in my add/edit/update query's to the database... But I can't seem to figure out how to ignore it? Everything I have done seems to fail.. I am using prepared statements so I"m not sure it that is it, but I would like to keep using them since it reduces the security issues a little... Here is the code from one of my prepared statements:
//Create the statement
mysqli_stmt_prepare($stmt, "INSERT INTO legionCurrent VALUES ( ?,?,?,?,?,?,?,?)");
mysqli_stmt_bind_param($stmt, 'ssssssss', $FName, $LName, $Add1, $Add2, $City, $State, $Zip, $XCode)or die(mysqli_error($addlink));
//Add the record
mysqli_stmt_execute($stmt) or die(mysqli_error($addlink));
Here is the error I get in my logs:
[Fri Apr 4 09:35:32 2008] [error] PHP Warning: mysqli_stmt_bind_param() [<a href='function.mysqli-stmt-bind-param'>function.mysqli-stmt-bind-param</a>]: invalid object or resource mysqli_stmt\n in /Volumes/RAIDer/webserver/Documents/dev/OLDBv2/add.php on line 91
Line 91 is the mysqli_stmt_bind_param() line above
My database structure looks like this:
| FName | LName | Add1 | Add2 | City | State | Zip | XCode | Reason | RecordI know there is away to do it, but all my searching and reading hasn't told me anything... I've looked in the php manual, and mysql, plus various websites... and I just can't figure this one out... RTFM's are appreciated, as long as M is defined! :) Thanks for taking the time to look! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com japruim@raoset.com