note 126374 added to class.sqlite3
| From: | dannsbass at gmail dot com | Date: | Mon, 30 Aug 2021 22:56:36 +0000 |
| Subject: | note 126374 added to class.sqlite3 | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-216841@lists.php.net to get a copy of this message | ||
# get all .dbi files in a directory
$databases_list = glob("directory/*.dbi");
# looping it
foreach ($databases_list as $db_name){
# sanitizing name of file
$db_name =
str_replace('directory/','',str_replace('.dbi','',$db_name));
# Database connection
$db = new SQLite3($db_name);
$result = $db->query("SELECT * FROM your_table_name");
while($data = $result->fetchArray()){
echo $data['column']."<hr>";
}
}
----
Server IP: 45.112.84.4
Probable Submitter: 195.138.250.34 (proxied: 2404:160:801c:2b5b:6872:3c89:d232:1694)
----
Manual Page -- https://php.net/manual/en/class.sqlite3.php
Edit -- https://main.php.net/note/edit/126374
Del: integrated -- https://main.php.net/note/delete/126374/integrated
Del: useless -- https://main.php.net/note/delete/126374/useless
Del: bad code -- https://main.php.net/note/delete/126374/bad+code
Del: spam -- https://main.php.net/note/delete/126374/spam
Del: non-english -- https://main.php.net/note/delete/126374/non-english
Del: in docs -- https://main.php.net/note/delete/126374/in+docs
Del: other reasons-- https://main.php.net/note/delete/126374
Reject -- https://main.php.net/note/reject/126374
Search -- https://main.php.net/manage/user-notes.php