[Freeswitch-users] Getting started with db from php

20 Jul 2012


      Trying to do some stuff with the voicemail database from a php script.
Couldn't quickly find the connection runes to the sqlite DB.

Tried the following, but got the error "file is encrypted or is not a 
database"

<?php
echo sqlite_libversion();
echo "<br>";

echo phpversion();
$dbhandle = sqlite_open('/usr/local/freeswitch/db/voicemail_default.db', 
0666, $error);
if (!$dbhandle) die ($error);

$sql = "SELECT * from voicemail_prefs";

$result = sqlite_exec($dbhandle, $stm, $error);
while ($row = sqlite_fetch_array($result, SQLITE_ASSOC)) {
print_r($row);
}

?>

[Freeswitch-users] Getting started with db from php

Alex