RE: Re: Sqlite wrapper for Log package
| From: | Urs Gehrig | Date: | Sun, 04 Jan 2004 20:20:52 +0000 |
| Subject: | RE: Re: Sqlite wrapper for Log package | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-24743@lists.php.net to get a copy of this message | ||
hello
did you know that there is already an sqlite db wrapper in PEAR;
wouldn't it make sense to base Log_sqlite on DB/sqlite too?
to create a table is as simple as (untested):
<?php
require_once 'DB.php';
require_once 'DB/sqlite.php';
$db = DB::connect("sqlite://dummy:@localhost/log.db" );
$db->query("CREATE TABLE log_table ( id INTEGER PRIMARY KEY NOT NULL,
logtime NOT NULL, ident CHAR(16) NOT NULL, priority INT NOT NULL,
message );" );
$db->disconnect();
?>
regards, urs
-----Original Message-----
From: news.php.net: php.pear.dev
Posted At: Sunday, January 04, 2004 7:41 PM
Posted To: news.php.net: php.pear.dev
Conversation: Re: Sqlite wrapper for Log package
Subject: Re: Sqlite wrapper for Log package
http://news.php.net/article.php?group=php.pear.dev
<http://news.php.net/article.php?group=php.pear.dev&article=24742>
&article=24742
Bertrand <mailto:bmansion+at+mamasam+dot+com>
Mansion