php的prepare方法,php连接数据库之预处理(prepare)

prestatement

class ConnectSqlite

{

public $db;

public function ConnectSqlite()

{

$this->db=new PDO('sqlite:D:/WWW/jqm/demos/db/serverdatabase');

}

function initStatement($sql)

{

$state=$this->db->prepare($sql);

return $state;

}

}

$connect=new ConnectSqlite;

$state=$connect->initStatement("update users set name=:newname where name=:oldname");

$state->bindParam(":newname", $newname);

$state->bindParam(":oldname", $oldname);

$newname="移动";

$oldname="徐杰";

if($state->execute()){

echo "hi' success updated...";

}else{

echo "fail updated...";

}

$state=$connect->initStatement("select id,loginname,name,password from users where id>:id");

$state->bindColumn(1, $id,PDO::PARAM_INT);

$state->bindColumn(2, $loginname);

$state->bindColumn(3, $name);

$state->bindColumn(4, $password);

$state->execute(array(":id"=>1));

echo '

echo '

';  for($i=0; $icolumnCount(); $i++){   $field=$state->getColumnMeta($i);//获取列名   echo ''.$field["name"]."";  }    $count;   while($state->fetch()){   echo '';   echo ''.$id.'';   echo ''.$loginname.'';   echo ''.$name.'';   echo ''.$password.'';   echo '';   $count++;  }  echo '';         echo "总记录数：".$count."
";  echo "总字段数：".$state->columnCount()."
"; ?>