php预处理怎么连接数据库,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()."
";

?>