Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

Converting database data to real values

schmitt
Minted
Posted on Oct 03, '08 at 11:48 am

I’m a php noob but would like to pull some entries from the visit database and derive the timestamp and IP.

The data is stored in the dt and ip_long fields.

Is there a short php command I can run from the command line that converts these into real values? I can hand key them as there are only 10 or so.

Specifically, I am trying to capture the IP address and timestamp of all accesses to a specific page. I don’t think there is a way to do this through the standard interface. I’ve already dumped the data via PHPadmin.

You must be logged in to reply. Login above or create an account