Is it possible to use one parameter in a prepared mysqli-statement multiple times with only binding it one time?
something like this
$stmt = $mysqli->prepare(SELECT * FROM user WHERE age BETWEEN ?1 - 2 AND ?1 + 2);
Just to close the question:
The answer is no.
If you want to bind a parameter only one time and using it multiple times in a query you have to use PDO and this maybe also needs a special configuration.
But sure there are workarounds. See the other answers to this question.