Find the answer to your Linux question:
Results 1 to 4 of 4
I'm running Fedora and I would like to know how to determine what query is sent to SQL via a web page written in PHP. I'm fairly new to mySQL ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined! DaWoo's Avatar
    Join Date
    Feb 2009
    Location
    New Jersey
    Posts
    16

    [SOLVED] PHP and mySQL


    I'm running Fedora and I would like to know how to determine what query is sent to SQL via a web page written in PHP. I'm fairly new to mySQL and PHP so be easy on me. I know I'm missing tons of information to help you help me. But any help would be greatly appreciated.

  2. #2
    Super Moderator Roxoff's Avatar
    Join Date
    Aug 2005
    Location
    Nottingham, England
    Posts
    3,885
    The easiest way is probably to grep through your php pages for user of the 'mysqli' class, and put logging in where it calls the mysqli instance's 'query' method.
    Linux user #126863 - see http://linuxcounter.net/

  3. #3
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,570
    It might be mysql rather than mysqli especially if the code is older
    What do we want?
    Time machines!

    When do we want 'em?
    Doesn't really matter does it!?


    The Fifth Continent

  4. #4
    Just Joined! DaWoo's Avatar
    Join Date
    Feb 2009
    Location
    New Jersey
    Posts
    16
    thank you for your replies. I was able to obtain the queries grep-ing for mysql. Turns out that they used Java, PHP, and mySQL.

Posting Permissions

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