【www.gdgbn.com--mysql教程】

html代码

 

 代码如下






php教程" width="22" height="30" />

php代码

 代码如下

$db = new sqlite3("mysql教程itedb.db");

//获取文件2进制流
$filename = "/www.111cn.net/logo.gif";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize ($filename));
fclose($handle);
//创建数据表
$db->exec("create table person (idnum text,name text,photo blob)");

$stmt = $db->prepare("insert into person values ("41042119720101001x", "张三",?)");
$stmt->bindvalue(1, $contents, sqlite3_blob);
$stmt->execute();

 代码如下 $pdo = new sqlite3("mysqlitedb.db");
$results = $pdo->query("select * from person");
while ($row = $results->fetcharray()) {
ob_start();
header("content-type: image/jpg");
echo $row["photo"] ;
ob_end_flush();
}

?>

本文来源：http://www.gdgbn.com/shujuku/26803/