首页 > php与数据库 > php pdo连接mysql数据查询数据

php pdo连接mysql数据查询数据

html代码

 

 代码如下 复制代码
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>ansys教程</title>
</head>
<body>
<img src="/info.php教程" width="22" height="30" />
</body>
</html>

php代码

 代码如下 复制代码

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

//获取文件2进制流
$filename = "/www.phprm.com/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();

<?php

 代码如下 复制代码
$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.phprm.com/database/34938.html

欢迎转载！但请带上文章地址^^

标签：fopen

相关文章

发表留言