note 126374 added to class.sqlite3

From: 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

« previous php.notes (#216841) next »