php连接数据库问题，求大神指导

[SeanLam111]

<?php
include_once 'Conn/Conn.php';
$sql="select * from user";
$stmt=mysqli_prepare($con, $sql);
$result=mysqli_execute($stmt) or die(mysqli_error($con));

while($res=mysqli_fetch_assoc($result)){
echo $res['name']." ".$res['pwd']." ".$res['type'];
}
mysqli_close($con);
?>
然后查不到数据 一直报错
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\wamp\www\PHP_final_129\index.php on line 7

[果酱很好吃]

mysqli_execute 是 mysqli_stmt_execute的别名，只会返回 true 或 false 查询用mysqli_query

[xuzuning]

mysqli_execute 是 mysqli_stmt_execute 的别名

[SeanLam111]

但是我已经用prepare了呀，只能用execute，我想知道mysqli用面向过程的方法如何查询返回一个结果集 ，用来判断用户登录是否成功

[xuzuning]

不是有 bool mysqli_stmt_fetch ( mysqli_stmt stmt ) 吗？

[hongmei85]

$sql = "SELECT `title`,`content`,`create_time` FROM `think_form`";

if($stmt = mysqli_prepare($conn, $sql)){
  //mysqli_stmt_bind_param($stmt, "s", $key);
  mysqli_stmt_execute($stmt);
  mysqli_stmt_bind_result($stmt, $title, $content, $create_time);
  while (mysqli_stmt_fetch($stmt)) {
    echo $title . ' ' . $content . ' ' . $create_time . '<br/>';
  }
}