连接mysql:
<?php
$dbh = new PDO('mysql:host=localhost; port=3306; dbname=test', 'root', '123456');
$sql = "INSERT INTO `img` (`imgurl` ,`imgnote`)VALUES (:imgurl, :imgnote)";
$stmt = $dbh->prepare($sql);
$parm = array(':imgurl'=>'/ad/asdf',':imgnote'=>'123456');
$stmt->execute($parm)
?>
连接sqlite:
<?php
$aax=dirname(__FILE__);
echo $aax."<br>";
$dsn = "sqlite:$aax\sql.db";
try {
$dbh = new PDO($dsn, $user, $password);
echo 'PDO Connection Ok','
';
$dbh->exec("CREATE TABLE PKU(id integer,name varchar(255))");
echo 'Create Table ok','
';
$dbh->exec("INSERT INTO PKU values(1,'jarjin')");
echo 'Insert Data ok','
';
$dbh->beginTransaction();
$sth = $dbh->prepare('SELECT *FROM PKU');
$sth->execute();
$result = $sth->fetchAll();
print_r($result);
$dsn=null;
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
$dsn=null;
}
?>
连接mdb
try{
$db = new PDO("odbc:driver={microsoft access driver (*.mdb)};dbq=".getcwd()."\\aaaa.mdb");
} catch (Exception $e) {
echo "Failed:".$e->getMessage();
}