StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmysqli bind_param giving error: (1210) Incorrect arguments to mysql_stmt_execute
text
Body
copied!<p>I have this exact same code working great on another server:</p> <pre><code>$mysqli_Cxn = new mysqli($SQL_HOST,$SQL_USER,$SQL_PASS,$SQL_DB); if($mysqli_Cxn->connect_errno){ echo 'Unable to connect!!'; exit(); } $userID=12345; $userFirstName = 'Charley'; $userLocale = 'en_US'; $sql = "UPDATE userProfile SET userFirstName=?, userLocale=? WHERE id=?"; if($stmt = $mysqli_Cxn->prepare($sql)){ if(!$stmt->bind_param('ssi',$userFirstName,$userLocale,$userID)){ echo "<br/><br/>Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error; } if($stmt->execute()){ totalAffected=$stmt->affected_rows; if($totalAffected>=1){ echo '<br/><br/>UPDATE OK: Affected rows = '. $totalAffected; } }else{ echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error; } } $stmt->close(); </code></pre> <p>That code gives me the following output: Execute failed: (1210) Incorrect arguments to mysql_stmt_execute</p> <p>If I change these two lines:</p> <pre><code>$sql = "UPDATE userProfile SET userFirstName=?, userLocale=? WHERE id=?"; $stmt->bind_param('ssi',$userFirstName,$userLocale,$userID); </code></pre> <p>to this:</p> <pre><code>$sql = "UPDATE userProfile SET userFirstName=?, userLocale='en_US' WHERE id=12345"; $stmt->bind_param('s',$userFirstName); </code></pre> <p>...then the Update is successful and I don't get any error.</p> <p><strong>Does anyone know why I can't bind more than one param in this code?</strong></p> <p>I had this code running perfectly on a Centos 4.9, PHP 5.3.3, MySQL 5.0.91/5.0.91-community-log</p> <p>I need to run it on my current server which is Centos 6.2, PHP 5.3.10, MySQL 5.0.95-community-log</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload