in reply to Web Logs Using DBI
This somewhat looks familiar. Kind of like what's on page 364 of "Writing Apache Modules with Perl and C" - A DBI Database Logger. Must be the table.
Note: since when is a reserved word in MySQL you'll have to escape it with backticks. This isn't explained in the Eagle book.
This is a good tutorial. However, please give credit where its due if you used a book or another article as a reference to write it.
BMaximus
Yields:create table access_log ( `when` datetime not null, host varchar(255) not null, method varchar(4) not null, url varchar(255) not null, auth varchar(50), referer varchar(255), status smallint(3) default 0, bytes int(8) );
+---------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------------------+-------+ | when | datetime | | | 0000-00-00 00:00:00 | | | host | varchar(255) | | | | | | method | varchar(4) | | | | | | url | varchar(255) | | | | | | auth | varchar(50) | YES | | NULL | | | referer | varchar(255) | YES | | NULL | | | status | smallint(3) | YES | | 0 | | | bytes | int(8) | YES | | NULL | | +---------+--------------+------+-----+---------------------+-------+
Note: since when is a reserved word in MySQL you'll have to escape it with backticks. This isn't explained in the Eagle book.
This is a good tutorial. However, please give credit where its due if you used a book or another article as a reference to write it.
BMaximus
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: Web Logs Using DBI
by btrott (Parson) on Sep 10, 2001 at 12:51 UTC | |
by stonecolddevin (Parson) on Apr 21, 2003 at 03:55 UTC | |
by Anonymous Monk on Apr 29, 2003 at 03:58 UTC |
In Section
Tutorials