$params = json_decode('{"category_id": 2, "product_status": "In Stock", "POINT": 0, "LIMIT": 12}'); $sql_query = "SELECT get_sample_products(':params') as jdoc"; $query = $connection->prepare($sql_query); $query->execute(['params' => json_encode($params)]); ERROR : PHP Warning: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number in php shell code:1 Stack trace: #0 php shell code(1): PDOStatement->execute() #1 {main} thrown in php shell code on line 1