小文件php+SQLite存储方案_PHP教程

<br>$db = new SQLite3('mysqlitedb.db'); <br><br>//获取文件2进制流 <br>$filename = "http://www.gxlcms.com/logo.gif"; <br>$handle = fopen($filename, "r"); <br>$contents = fread($handle, filesize ($filename)); <br>fclose($handle); <br>//创建数据表 <br>$db->exec('CREATE TABLE person (idnum TEXT,name TEXT,photo BLOB)'); <br><br>$stmt = $db->prepare("INSERT INTO person VALUES ('41042119720101001X', '张三',?)"); <br>$stmt->bindValue(1, $contents, SQLITE3_BLOB); <br>$stmt->execute(); <br> <br>读数据文件：php2.php <br><span style="CURSOR: pointer" onclick="doCopy('code54679')"><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><!--?php <BR-->$pdo = new SQLite3('mysqlitedb.db'); <br>$results = $pdo->query('select * from person'); <br>while ($row = $results->fetchArray()) { <br>ob_start(); <br>header("Content-Type: image/jpg"); <br>echo $row['photo'] ; <br>ob_end_flush(); <br>} <br>?> <br> <br>网页引用： <br><span style="CURSOR: pointer" onclick="doCopy('code32652')"><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br> <br> <br> <br><meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <br><title>ANSYS教程</title> <br> <br> <br><img src="http://www.gxlcms.com/info.php" width="22" height="30"> <br> <br> <br></li><li><p></p></li><li><p align="left"><span id="url" itemprop="url">http://www.bkjia.com/PHPjc/322429.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http://www.bkjia.com/PHPjc/322429.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">我们草根站长购买的虚拟主机往往都有文件数量限制，大量小文件占用大量资源，落伍精华区也有兄弟推荐豆瓣的解决方法，但是要有主机...</span></p></li><li>                    </li></ol></pre></li></ol></pre>