I know this is just some annoying syntax thing but i just can't get the code below to work. 开发者_开发知识库 Please can someone help?
if($stmt = $link -> prepare("INSERT INTO google_pre_transaction VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?")) {
/* Bind parameters
s - string, b - boolean, i - int, etc */
$stmt -> bind_param("iiisss",
$m_id,
$page_one['input-one'],
$page_one['input-two'],
$page_one['title'],
$page_one['first'],
$page_one['last']
);
You have 13 ?
and 7 variables. The numbers have to match.
Also, your closing parenthese is outside the quote, which is bad syntax.
This should work:
prepare("INSERT INTO google_pre_transaction VALUES (?,?,?,?,?,?,?)")
For one, you have a lot more ?
then you have parameters in you bind_param. They should be the same amount.
I'm guessing the error is saying exactly that by the way.
精彩评论