Kakaka, one bug can be fixed in one day! <b>Fatal error</b>: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in

about$stmt->execute($categoryIds); – Issue with parameter passing.

I'm really done with this—just one little problem and it's kept me up all afternoon!
It wasn't until I checked the documentation in the evening that I realized the problem was actually with this thing.

PDOException: SQLSTATE[HY093]  Error; The root cause is ; Parameter placeholders in SQL statements; execute() The imported array parameter cannot be correctly matched.。

Error Cause Diagnosis

execute() 期望输入一个值Indexed array(in compliance with  ['value1', 'value2'])perhapsAssociative array(in compliance with  [':name' => 'value']), used to map one-to-one to the corresponding entries in SQL; ?   or  ; :name Placeholder。

if  $categoryIds If the requirements are not met, an error will be reported. Common issues include:

• Array key names are not consecutive.If; $categoryIds  was processed; array_filter() When functions are applied to the data, it may result in a "sparse array" (for example, where the key names are 0, 2, 3, but the value for 1 is missing).execute() Unable to correctly handle this discontinuous index.。

• Invalid key nameIf you are using named placeholders in SQL (e.g.,  ); :id), then ; $categoryIds The key name must be exactly the same (e.g.,  ); [':id' => 1]). Incorrect key name or use of invalid characters (e.g., period ); .) will cause a matching failure。

• Number of parameters does not match：$categoryIds The number of parameters must exactly match the number of placeholders in the SQL statement.

• multidimensional arrayIf; $categoryIds A multidimensional array (e.g., a result set retrieved from a database),execute() 也无法处理

solution

1. Check and reset array indices (most common cause)

If you have used it; array_filter() Or a similar function; please use   first. array_values() Reset Index:

// 假设 $categoryIds 来自过滤
// $categoryIds = array_filter($categoryIds);
$categoryIds = array_values($categoryIds); // 重置索引为 0, 1, 2...
$stmt->execute($categoryIds);

2. Ensure that the key name matches the placeholder.

If you are using named placeholders (e.g.,  ); :cat_id),please check it:

// 正确的做法
$sql = "SELECT * FROM articles WHERE category_id IN (:cat_id1, :cat_id2)";
$stmt = $pdo->prepare($sql);
// $categoryIds 的键名必须和占位符完全一致
$stmt->execute([':cat_id1' => 1, ':cat_id2' => 2]);

// 生成对应数量的 ? 占位符
$placeholders = rtrim(str_repeat('?,', count($categoryIds)), ',');
$sql = "SELECT * FROM articles WHERE category_id IN ($placeholders)";
$stmt = $pdo->prepare($sql);
$stmt->execute($categoryIds); // 直接传入索引数组