MySQLi-在bind_param之后声明变量? [英] MySQLi - declaring variable after 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.

在声明变量之前将其绑定将引发E_NOTICE消息(不，它不会.为@webbiedave干杯)

Binding a variable before declaring it will throw an E_NOTICE message (No it doesn't. Cheers @webbiedave)

如果您问我，查询应该放在一个地方，然后立即执行，以备将来阅读.

If you ask me, a query should be built in one place, and then executed straight away, for the sake of future readability.

这篇关于MySQLi-在bind_param之后声明变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！