|
|
Posted by Jerry Stuckle on 09/10/07 01:22
Dan99 wrote:
> 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?
>
Not easy, but you can check out regular expressions. Strcmp will also work.
Maybe check the library or bookstore for books on parsing strings?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|