PHPize Online / SQLize Online  /  SQLtest Online

<?php $query = ['body'=>'bum','animal'=>'bee']; $escaped = str_replace(['!', '%', '_'], ['!!', '!%', '!_'], $query); echo "Escaped: $escaped\n\n"; $stmt = $pdo->prepare("SELECT * FROM auction WHERE name LIKE ? ESCAPE '!'"); $stmt->execute(["%$escaped%"]); foreach ($stmt as $i => $row) { echo "$i: " . var_export($row, true) . "\n"; } echo "\n---\n"; $stmt->execute(["%$escaped%"]); $i = 0; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo "$i: " . var_export($row, true) . "\n"; ++$i; } echo "\n---\n"; $stmt->execute(["%$escaped%"]); var_export($stmt->fetchAll(PDO::FETCH_ASSOC));