How to use SQLCipher on PHP for SQLite3

Question

how can I use SQLCipher on PHP on regular PHP, Apache installation or any other WAMP, ZendServer and so on... On Windows not linux?

OR

How can I use this method for encryption in PHP: http://www.sqlite.org/see/doc/trunk/www/readme.wiki

I need AES encryption for SQLite3.

score -1 · Accepted Answer · edited Jun 02 '13 at 18:09

-1

You can find instructions on building SQLCipher for PHP here

edited Jun 02 '13 at 18:09

Chris

5,584
9
40
58

answered Jun 02 '13 at 18:00

Stephen Lombardo

1,503
8
7

This is for ubanutu operating system what if we have windows operating system – Awais Usmani Feb 14 '14 at 06:43

score -1 · Answer 2 · answered Jan 26 '16 at 11:27

-1

Try this, once installed and enabled in php mods on Wamp (should already be installed):

<?php
try {
  $db = new SQLite3("demo.db");
  $version = $db->query("PRAGMA cipher_version");
  if($version){
    var_dump($version->fetchArray());
  } else {
    throw new Exception($db->lastErrorMsg());
  }
  $db->close();
}
catch (Exception $e){
  echo "Exception", $e->getMessage(), "\n";
}
?>

answered Jan 26 '16 at 11:27

ShaunOReilly

2,186
22
34

this is for sqlite not sqlcipher – Hossein Shahdoost Dec 25 '16 at 16:29

How to use SQLCipher on PHP for SQLite3

2 Answers2