Re: problem with bind_param
| From: | Jeremy Mcentire | Date: | Mon, 29 Oct 2007 16:05:35 +0000 |
| Subject: | Re: problem with bind_param | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-263790@lists.php.net to get a copy of this message | ||
The PHP docs show:
$stmt = $mysqli->prepare("INSERT INTO CountryLanguage VALUES (?, ?, ?, ?)");
$stmt->bind_param('sssd', $code, $language, $official, $percent);
for usage. Your $prep->bind_param() doesn't seem to include the definitions. 'sssd' in the above example, string, string, string, decimal. Further, you should probably make sure that your $_POST data is set and isn't null or a variable type other than what is expected.
Jeremy Mcentire
Ant Farmer
ZooToo LLC
On Oct 29, 2007, at 9:51 AM, Hulf wrote:
Hi, I am still having poblems with the php5 functions. I have 4 variables in each. What is the problem? Warning: mysqli_stmt::bind_param() [function.mysqli-stmt-bind-param]: Number of elements in type definition string doesn't match number of bind variables in xxxx on line 21 $prep = $mysqli->prepare ("UPDATE events SET title=?, date=?, content=?, imageUrl=?"); $prep->bind_param ( $_POST['title'], $_POST['date'], $_POST['content'], $_POST['imageUrl']); thanks, H. --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php