Jump to content

Archived

This topic is now archived and is closed to further replies.

ted_chou12

sqlite list all tables in php?

Recommended Posts

Hi, I found all the functions for create table, insert..etc. but I could find a function that returns all the table? http://www.php.net/manual/en/function.sqlite-open.php

Like there would be tables that the script does not know, and it would be fetched like a wildcard?

<?php
$db_path = "/var/db/blog.db";
$dbh = sqlite_open($db_path);
$query....?
?>

Thanks

Share this post


Link to post
Share on other sites

thanks, it should be like this:

[code]$dbh = sqlite_open($db_path);
$query = sqlite_query($dbh, "SELECT name FROM sqlite_master
WHERE type='table'
ORDER BY name;");
$result = sqlite_fetch_all($query, SQLITE_ASSOC);
foreach ($result as $entry) {
    echo 'Name: ' . $entry['name'];
echo "<br />";
}

[/code]

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.