sqlite list all tables in php?

[ted_chou12]

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

[Pikachu2000]

It appears you need to run a query to return that information: http://www.sqlite.org/faq.html#q7

[ted_chou12]

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]