Kod
Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in XXXX on line XX
PDO::errorCode(): HY093
PDO::errorCode(): HY093
Kod
function addTo($table,$col,$value)
{
if($query = $this->connection->prepare("INSERT INTO :table (:col)
VALUES (':value')")){
echo gettype($table);
echo gettype($col);
echo gettype($value);
$query->bindParam(':table',$table);
$query->bindParam(':col',$col);
$query->bindParam(':value',$value);
$query->execute();
echo "\nPDO::errorCode(): ", $query->errorCode();
}
}
{
if($query = $this->connection->prepare("INSERT INTO :table (:col)
VALUES (':value')")){
echo gettype($table);
echo gettype($col);
echo gettype($value);
$query->bindParam(':table',$table);
$query->bindParam(':col',$col);
$query->bindParam(':value',$value);
$query->execute();
echo "\nPDO::errorCode(): ", $query->errorCode();
}
}
Co może być nie tak?