MySQLi - 在 bind_param 之后声明变量?
这可能是一个完全愚蠢的问题，但我看过几个例子，在将变量放入 bind_param 后声明变量:
http://devzone.zend.com/article/686
This may be a completely dumb question, but I've seen a couple examples declaring the variables AFTER putting them in bind_param:
http://devzone.zend.com/article/686
我以前从未见过这样做过，我所有的编程知识都表明我应该事先定义它们.这是一种有效/首选的方式吗?
I've never seen this done before and all my programming knowledge says I should define them before hand. Is this a valid/preferred way?
推荐答案
这是可能的，因为绑定的是对相关变量的引用，但我发现它的风格非常糟糕:
This is possible, because what gets bound is a reference to the variable in question, but I find it horribly bad style:
它使代码更难阅读、维护和调试 - 变量可以进一步更改，甚至可以在绑定和查询之间调用的其他函数中更改.
It makes code harder to read, maintain and debug - the variable could be changed further down the line, or even in other functions called in between the binding and the query.
在声明之前绑定一个变量会抛出一个(不，它没有.干杯@webbiedave)E_NOTICE消息
Binding a variable before declaring it will throw an (No it doesn't. Cheers @webbiedave)E_NOTICE message
如果您问我，为了将来的可读性，查询应该在一个地方构建，然后立即执行.
If you ask me, a query should be built in one place, and then executed straight away, for the sake of future readability.
相关文章