Skip to content

Instantly share code, notes, and snippets.

@staabm
Created April 22, 2022 11:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save staabm/a4934f916666ede19dedb5face702615 to your computer and use it in GitHub Desktop.
Save staabm/a4934f916666ede19dedb5face702615 to your computer and use it in GitHub Desktop.
3val error
<?php
$queryString = '
SELECT
land.*,
COALESCE(NULLIF(landsprache.ort, ""), land.ort) AS ort
FROM land
INNER JOIN landsprache ON (land.landid=landsprache.landid and landsprache.spracheid = ?)
WHERE (webinaktiv = 0) ORDER BY COALESCE(NULLIF(landsprache.ort, ""), land.ort) ASC
';
var_dump(preg_match_all('{(["\'])([^"\']+\1)|(\?)}', $queryString, $matches));
var_dump($matches[0]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment