PHP and mySQL

Discussion in 'Mac Help/Tips' started by kevin49093, Mar 5, 2003.

  1. kevin49093 macrumors regular

    Joined:
    Feb 27, 2002
    Location:
    Colorado
    #1
    Ok guys...
    My brother wants me to put together a simple database driven web site for him.. It is going to be a directory listing of traveler friendly yoga studios. I've begun to look into php and mysql, and they seem to make sense. My question is this, are there any apps or tools out there that can really help in the writing of the pages> I think I've got the actual database side of it figured out, now I just need to display the info!

    Thanks!
     
  2. Taft macrumors 65816

    Taft

    Joined:
    Jan 31, 2002
    Location:
    Chicago
    #2
    This page has everything you need to do a query and display the results in HTML.

    http://www.php.net/manual/en/ref.mysql.php

    Its from the PHP documentation page. (http://www.php.net/manual/en/) This page will be invaluable to you as you start using PHP to build web pages.

    You may also want to check out PostgreSQL (http://www.postgresql.com/). Its like MySQL on steroids and includes such great items as stored procedures and transactions (items MySQL doesn't have). In my opinion, its definitely a more complete and enterprise-ready database.

    Taft
     
  3. macktheknife macrumors 6502a

    macktheknife

    Joined:
    Jan 24, 2002
    #3
    If you happen to have Dreamweaver, it has PHP support. JaneBUILDER is a visual editor for PHP that you might want to check out. It costs about $50 or so, but you might want to check it out:

    http://www.seejanecode.com/
     
  4. kevin49093 thread starter macrumors regular

    Joined:
    Feb 27, 2002
    Location:
    Colorado
    #4
    Thanks...

    Thanks for your tips guys...

    I'm starting to look at it now, it seems a bit coufusing, but I might be able to manage it. I think the server for the site does not allow remote access of the mySQL database, so I'll have to work around that.

    I think I am understanding how to actually create the coded pages (using apps), but don't get how to upload a large ammount of info into the database at once. Am I missing something very simple here?
     

Share This Page