hola tengo lo siguiente es un insert simple a una tabla .
Código PHP:
$daily = '{"amount":0,"accumulated":0}';
$this->money = 10;
$insert = 'INSERT INTO usuarios (idufb,nick,money,gas,phone,address,mail,daily
,ultiposi,idlevel,idavatars,city,idciud
ad, dailyrents, dailytimeto)
VALUES (? , ? , ? , ? , ? , ? ,?, NOW(), ? , 1, 1, ? ,?,'.$daily.','.$daily.')';
$stmt_insert = $this->conn->prepare( $insert );
$stmt_insert->bindParam(1 , $this->idufb);
$stmt_insert->bindParam(2 , $this->nickname);
$stmt_insert->bindParam(3 , $this->money);
$stmt_insert->bindParam(4 , $this->gas);
$stmt_insert->bindParam(5 , $this->phone);
$stmt_insert->bindParam(6 , $this->address);
$stmt_insert->bindParam(7 , $this->mail);
$stmt_insert->bindParam(8 , $this->point);
$stmt_insert->bindParam(9, $city);
$stmt_insert->bindParam(10, $idcity);
y me sale este error
SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
no se que podria ser..
saludos