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();  
  }  
    
  $mysqli->close(); 

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/iamtsgx08/archive/2009/05/08/4161274.aspx