Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Apr 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PHP mySqL and DNS???

    Good afternoon all I have a pretty simple webpage with some simple php to connect to my SQL DB and search for certain data. What I would like to do is have the ability to run a search in two tables depending on the input data from the form. Example I have a user who wants to lookup host www.mydomain.com and return both the forward and reverse records associated with that host, also I would like to be able to do this in reverse like if the user wants to search for an ip address like 10.0.0.0 and get the host attached to that and the reverse attached to that. If anyone know a good way of doing this could you please help as I am lost at this point.


    Thanks
    Sunadmn

  • #2
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok so you're going to store this information in your DB? Or are you looking for some PHP functions that do this for your automatically (I know that you can do this in Java...).

    Check out this link if your quest is for the latter:
    http://faq.web2010.com/tutorial/demo_dns.phtml

    If it's the former, then it's just a simple table lookup. Unless you don't know anything about how to query databases in PHP...

    Hope that helps,
    Sadiq.

  • #3
    New to the CF scene
    Join Date
    Apr 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Actually I want to query the DB directly and not actually see what the world sees via lookup I want to be able to see what I have in the zone files that I have put into the DB.

  • #4
    Senior Coder
    Join Date
    Feb 2004
    Posts
    1,206
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Alright, so you're using MySQL? And you've got a bunch of tables with data that are related somehow?

    You're asking us how to query your database then? Well for anyone to help, it really depends on what your database looks like. Unless of course you know SQL and you know what your query should look like, then you're wondering how to use PHP to query your MySQL database using your SQL query?

    I can't help you with setting up your SQL query as I don't know what your database looks like, but here's a couple of links that might help:
    http://hotwired.lycos.com/webmonkey/...tw=programming
    http://hotwired.lycos.com/webmonkey/...tw=programming

    Good luck,
    Sadiq.


  •  

    Posting Permissions

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