php mysqli ʹÓÃprepare

  1£¬°ó¶¨²ÎÊý
 
  $mysqli=new mysqli($host,$user,$pass,$db);  
   if(mysqli_connect_errno()){  
    echo 'Á¬½Ó³öÏÖÒì³£ÁË:'.mysqli_connect_error();  
    exit(0);  }  
      
   $sql = 'insert into user(name,pass,email) values(?,?,?)';  
   $stmt = $mysqli->prepare($sql);  
   $stmt->bind_param('sss',$name,$paassword,$email);  
   $name= '2';  
   $paassword=md5('12345');  
   $email = 'iamtsgx08@google.com';     
   $stmt->execute();  
     
   echo 'ÐÞ¸ÄÁË'.$stmt->affected_rows.'ÐÐ';  
     
   $stmt->close();  
   $mysqli->close();
2£¬°ó¶¨½á¹û¼¯
$sql = 'select name,pass,email from user';  
  if($stmt = $mysqli->prepare($sql)){  
    $stmt->execute();  
    $stmt->bind_result($name,$pass,$email); //°ó¶¨½á¹û  
    echo "<table>";  
    while($stmt->fetch()){  
        echo "<tr>";  
        echo "<td>".$name."</td>";  
        echo "<td>".$pass."</td>";  
        echo "<td>".$email."</td>";  
        echo "</tr>";  
    }  
    echo "</table>";  
    $stmt->close();  
  }  
   &nbs