PHP查询sqlite表结构

最新推荐文章于 2024-03-17 00:24:03 发布

chinasonghaiyang

最新推荐文章于 2024-03-17 00:24:03 发布

阅读量694

点赞数

本文链接：https://blog.youkuaiyun.com/chinasonghaiyang/article/details/50194773

版权

<?php
@header('content-type:text/html;charset=utf-8');
$db = new SQLite3('jdb.db');
$q='select name from sqlite_master where type="table"';
$oTableNames=$db->query($q) ;//返回值未结果集
while($row =$oTableNames->fetchArray(SQLITE3_ASSOC) )
{
foreach ($row as $tablename)
{
if($tablename!='sqlite_sequence')
{
echo "TableName——".$tablename.'<br>';
$oTableinfo=$db->query("PRAGMA table_info({$tablename})");
while($row1=$oTableinfo->fetchArray(SQLITE3_ASSOC))
{
print_r($row1['name']);
echo "  ";
}
echo "<br><br>";
}
}
}
$db->close();
?>