MySQLi查询结果：最好的方法，你关闭，免费，两者？

I have some questions about using MySQLi, queries, and related memory management. The code here is just to clarify my questions, so don't dump on it for error checking, etc. I know that needs to be done :), queri