php 预编译查询始终fetch不到数据
<br>include ('../db/MySqlConnect.php');<br>$conn = new MySqlConnect();<br>$mysqli = $conn->getConnection();<br>$sql = 'select id, username, password from admin where id = ?';<br>$seach_id = 1;<br>settype($seach_id, "integer");<br>if($stmt = $mysqli->prepare($sql)) {<br> $stmt->bind_param('i', $seach_id);<br> $stmt->execute();<br> $stmt->bind_result($rs_id, $rs_name, $rs_password);<br> if($stmt->fetch() == NULL) {<br> echo 'no result';<br> } else {<br> printf('id:%s, name:%s, password:%s <br/>', $rs_id, $rs_name, $rs_password);<br> }<br> $stmt->close();<br> $mysqli->close();<br>}<br>sql语句明明可以查询出来数据, 我使用php的非预编译语句($result = $mysqli->query($query);)也可以查询出来记录, 就是上面的查询代码始终在fetch出抓取不到数据,我的php版本是php-5.2.5-x64, 环境是64位的win7, 有遇到过的朋友或知道的能给分析一下么, 我已经困扰2天了....谢谢了










