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.

在声明之前绑定一个变量会抛出一个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 之后声明变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！