note 105444 modified in mysqli-stmt.execute by mez

Re: Note by vedran-b at email dot htnet dot hr I don't know what he managed to do, but under normal circumstances bind_param() does NOT by itself alter the value of the variables passed as arguments. They are however passed by reference, so if you change them after calling bind_param(), the changed values will be used the next time you call execute(). This is due to the original purpose of parametrised statements - it allows you to run the same query repeatedly changing only the input and receiving different output: you only need to call prepare(), bind_param() and (optionally) bind_result() once, then you loop as many times as needed calling execute() on each iteration. --was-- Re: Note by vedran-b at email dot htnet dot hr I don't know what he managed to do, but under normal circumstances bind_param() does NOT by itself alter the value of the variables passed as arguments. They are however passed by reference, so if you change them after calling bind_param(), the changed values will be used the next time you call execute(). This is due to the original purpose of parametrised statements - it allows you to run the same query repeatedly changing only the input and receiving different output: you only need to call prepare(), bind_param() and (optionally) bind_result() once, then you loop as many times as needed calling execute() on each iteration. http://php.net/manual/en/mysqli-stmt.execute.php