PHP: PDO+mysql not working with pipe sign (|)

Question

I have the following code:

$stmt = $conn->prepare("INSERT festiwal_zdjecia (uuid, url, rok) VALUES(?, ?, ?) "
            ."ON DUPLICATE KEY UPDATE rok = ?;");
$stmt->execute(array($uuid,$z,$rok,$rok));

The $z variable is equal to 'xxx|yyy.jpg'. After running the script, in the db I can see: url = 'xxx'.

You are binding parameters correctly as far as I can tell so the pipe sign should not be causing any problem. How are you verifying the input data and the inserted value? — Álvaro González, Oct 30 '18 at 09:11

score 1 · Accepted Answer · answered Oct 30 '18 at 08:14

1

Use Bind param to escape the pipe PDO::PARAM_STR Refer to the following post Use bound parameter multiple times

answered Oct 30 '18 at 08:14

Varyable D San

41
1

Having several `?` placeholders does not really count as using bound parameters multiple times (that's a problem that affects named `:foo` placeholders) and I always thought that `PDO::PARAM_STR` is the default in most drivers. I honestly can't figure out what this answer has to do with the question, nor why it's been accepted by the OP :-? – Álvaro González Oct 31 '18 at 09:52
This answer was accepted because it worked (although I agree it's weird) – kade99 May 06 '20 at 04:12

PHP: PDO+mysql not working with pipe sign (|)

1 Answers1