| $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
|