123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <?php
- class LtDbConnectionAdapterSqlite implements LtDbConnectionAdapter
- {
- public function connect($connConf)
- {
- if (isset($connConf['pconnect']) && true == $connConf['pconnect'])
- {
- $func = 'sqlite_popen';
- }
- else
- {
- $func = 'sqlite_open';
- }
- $connConf["host"] = rtrim($connConf["host"], '\\/') . DIRECTORY_SEPARATOR;
- if(!is_dir($connConf["host"]))
- {
- if(!@mkdir($connConf["host"], 0777, true))
- {
- trigger_error("Can not create {$connConf['host']}");
- }
- }
- $error = '';
- $connResource = $func($connConf["host"] . $connConf["dbname"], 0666, $error);
- if (!$connResource)
- {
- trigger_error($error, E_USER_ERROR);
- }
- else
- {
- return $connResource;
- }
- }
- public function exec($sql, $connResource)
- {
- if(empty($sql))
- {
- return 0;
- }
- sqlite_exec($connResource, $sql);
-
-
-
-
-
-
- return sqlite_changes($connResource);
- }
- public function query($sql, $connResource)
- {
- $result = sqlite_query($connResource, $sql, SQLITE_ASSOC);
- return sqlite_fetch_all($result, SQLITE_ASSOC);
- }
- public function lastInsertId($connResource)
- {
- return sqlite_last_insert_rowid($connResource);
- }
- public function escape($sql, $connResource)
- {
- return sqlite_escape_string($sql);
- }
- }
|