|
|
Posted by Dan99 on 09/09/07 23:03
On Sep 9, 6:15 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> Dan99 wrote:
> > Hello,
>
> > I am working on auditing interactions with a pgsql database using
> > php. So my question is how can i go about obtaining the following
> > information for by only being provided a pgsql query.
>
> > 1. table(s) affected
> > 2. column(s) affected
> > 3. action performed on data (ie. update, insert, select, delete)
> > 4. previous data for each row and column effected (if data changed or
> > deleted)
> > 5. new data for each row and column effected (or existing data if data
> > is being selected)
>
> > Any help with this would be greatly appreciated.
>
> > Thanks,
> > Dan
>
> If you're presented with the query, you can parse it for the tables and
> columns. You can also determine what the action is.
>
> For the rest you would have to query the database itself - there's no
> other way to get it in PHP.
>
> Otherwise you need to check in a postgres group to see if that
> information is available to you somewhere.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================
Yes, I am provided with the actual query (ex. "INSERT INTO table_bob
(column1, column2) VALUES ('value1', 'value2')"). How would I go
about doing the parsing in php?
Navigation:
[Reply to this message]
|