|
|
Posted by gosha bine on 09/10/07 08:21
On 10.09.2007 01:03 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?
>
You can try PDO_User and its parseSQL function
http://pecl.php.net/package/pdo_user
--
gosha bine
makrell ~ http://www.tagarga.com/blok/makrell
php done right ;) http://code.google.com/p/pihipi
Navigation:
[Reply to this message]
|