Программа чтобы работать с базами данных sqlite3 через сеть или socket файлы http://sqlite3s.blindage.org/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Vladimir Smagin 7e6a6cfa36 Изменить 'README.md' 1 month ago
.idea test in php 3 years ago
README.md Изменить 'README.md' 1 month ago
contributors.txt first commit 3 years ago
sqlite3socket.py commit changes bugfix 3 years ago
test.db lala 3 years ago
test.php test in php 3 years ago

README.md

sqlite3socket

Can create socket file or open port to provide non-blocking access to sqlite database. Send plain text SQL query and retrieve answer in JSON.

Configure

Open sqlite3socket.py and comment confBindTo to select what to open, port or socket file.

Test query

Set SQL query:

$sql = 'select value from options where option="transmitter";';

Now you can run query to database:

# php ./test.php 
array(2) {
  [0]=>
  string(6) "result"
  [1]=>
  array(1) {
    [0]=>
    array(1) {
      [0]=>
      string(7) "enabled"
    }
  }
}

First element is a result type, error or result. Second element is a result data or error text.


Author Vladimir Smagin, 2016
Email: 21h@blindage.org
Project page https://git.blindage.org/21h/sqlite3socket