主页 > 知识库 > 网络编程 > PHP >

PHP

在PHP5中使用PDO访问SQLite3

来源:中国IT实验室 作者:佚名 发表于:2012-11-21 13:16  点击:
代码 1 : html ?php $dsn = sqlite:sql.db; try { $dbh = new PDO($dsn, $user, $password); // 建立连接 echo PDO Connection OkBR; // 建表 $dbh-exec(CREATE TABLE PKU(id integer,name varchar(255))); //echo Create Table okBR\n; print(Create Table
代码 1
<html>
<?php
$dsn = 'sqlite:sql.db';
 
try
{
    $dbh = new PDO($dsn, $user, $password);       //建立连接
 
    echo 'PDO Connection Ok<BR>';
 
       //建表
    $dbh->exec("CREATE TABLE PKU(id integer,name varchar(255))");
 
    //echo 'Create Table ok<BR>\n';
       print("Create Table ok<BR>\n");
 
    $dbh->exec("INSERT INTO PKU values(1,'jarjin')");
 
    echo 'Insert Data ok<BR>';
 
    $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;
}
?>
</html>
 
代码 2
<html>
<?php
 
       //$pdo = new PDO('sqlite::memory:');   //内存中的数据库
       $pdo = new PDO('sqlite:mydb.db');
       $pdo->exec('CREATE TABLE test(ID INT NOT NULL PRIMARY KEY, Field VARCHAR(12) NULL);');
       $stmt = $pdo->prepare('INSERT INTO test(ID, Field) VALUES(?, ?)');
 
       $one = 1;
       $two = 2;
       $null = NULL;
      
       // Try with PDO_PARAM_NULL
       $stmt->bindParam(1, $one, PDO::PARAM_INT);       //绑定参数
       $stmt->bindParam(2, $null, PDO::PARAM_STR);
       assert($stmt->execute());
 
       // Try with PDO_PARAM_STR
       $stmt->bindParam(1, $two, PDO::PARAM_INT);
       $stmt->bindParam(2, $null, PDO::PARAM_STR);
       assert($stmt->execute());
      
       // Check we have rows..
       $stmt = $pdo->prepare('SELECT * FROM test');
       assert($stmt->execute());
       var_dump($stmt->fetchAll());
      
       // Check we have rows with field is null
       echo '<hr />';
       $stmt = $pdo->prepare('SELECT * FROM test WHERE Field IS NULL');
       assert($stmt->execute());
       var_dump($stmt->fetchAll());       //显示查询结果
?>
</html>

    有帮助
    (0)
    0%
    没帮助
    (0)
    0%