Online PHP editor | output for aLS24

<?php function checkParameters(string $sql) { $countNamed = 0; $countUnnamed = 0; $inQuote = false; for ($i = 0; $i < strlen($sql); ++ $i) { if ($inQuote) { if ($sql[$i] == $quote) { $inQuote = false; continue; } } else { if (in_array($sql[$i], ['"', "'"])) { $quote = $sql[$i]; continue; } } if ($sql[$i] == ':') { $countUnnamed ++; } elseif ($sql[$i] == '?') { $countNamed ++; } } if ($countNamed && $countUnnamed) { throw new Exception("mixed parms in: $sql" . PHP_EOL); } } $sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id"; checkParameters($sql); $sql = "SELECT a, b FROM someTable WHERE a = ? AND b = :id"; checkParameters($sql);