Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011

    Unanswered: Tool that alerts for each entry

    Hello everyone,
    I recently joined a company and would like some help. I have just entered in the DB field and have been asked to learn an entire db and know when I click on something in a php page as to which table the data is entered into or taken from.
    I'd like to know if there is a tool that will tell me whenever there is a DB transaction from a php page into my mySQL database. If anyone does know about any such tool, please help me out.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    yes there is such a tool
    ....its called the Mark 1 eyeball
    Visual inspection - Wikipedia, the free encyclopedia

    learn PHP, got through the code and understand what it does

    if you are lucky the PHP may be using stored procedures, but its quite probable it doesn't
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2011
    Thanks healdem.But that doesnt really solve my problem. Please let me know of any other tools (that I can downlaod) you might know.
    Last edited by bharath01; 03-17-11 at 08:13.

  4. #4
    Join Date
    Sep 2009
    San Sebastian, Spain
    I think what you are looking for here is a tool to view the transactions being played in the database under certain conditions. MySQL provides the General Query Log for determining the SQL statements that have been played against the database. Check out MySQL :: MySQL 5.1 Reference Manual :: 5.2.3 The General Query Log
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts