HELP mySQL + PHP

Discussion in 'Mac Apps and Mac App Store' started by massie, Jul 3, 2003.

  1. massie macrumors newbie

    Joined:
    Jun 13, 2003
    Location:
    Barnsley
    #1
    hello,

    could anybody help me.

    I have posted in the swicher but now i have a better idea

    i have been using ms access to create databases for my dynamic web pages using asp, but now im a mac user i want to swich to mySQL

    does anybody know how to install this, and also how i can get a GUI to work for it!

    ive followed instructions , but with no luck.. i dont know how to get into my superuser account on OSX!!

    is there another database program thats like access that can work with php?

    what about filemaker pro???

    any advice, tips.. constructive chritisims, please let me know!

    matt
     
  2. conceptdev macrumors regular

    Joined:
    Nov 17, 2002
    #2
    Ok here is a list of tools and links you will need to get started.

    You will need to install php first. So here is the link with instructions.

    Installing PHP

    Here is a link for a great MySQL installation package called MySQL complete.

    MySQL install package

    Now for a graphical frontend I recommend phpMyAdmin very easy to use. Here is the link for that.

    phpMyAdmin link

    Now to edit php you might want to use a light weight developers text editor - I recommend Hydra - it does some other cool stuff like let you work with friends on the same doc in real time but I mainly use it for day to day code work.

    Link for Hydra

    Now all the tools I listed before are opensource and free so you don't have to pay anything. But if you want to use something that takes a lot of the work out of building data driven websites I recommend Macromedia Dreamweaver - its not free but it saves a lot of time.

    Link for dreamweaver

    Good luck - it can seem a bit complicated at first but is worth it.

    BTW - to turn on apache in OS X go to sharing and turn on "personal web sharing" your document root is at Library:Webserver:Documents
     
  3. massie thread starter macrumors newbie

    Joined:
    Jun 13, 2003
    Location:
    Barnsley
    #3
    :D thanks :)

    Thanks,

    i have dreamweaver allready, and ive been using uploaded access databases on a sever so that bit i know. (well using asp anyway.)

    but that was very usefull!

    im gonna be a full MacOSX developer before my time is through..

    matt
     
  4. buffsldr macrumors 6502a

    buffsldr

    Joined:
    May 7, 2001
    #4
    i know enough about fm pro to be dangerous. i recommend it

    if u need help, please ask
     
  5. massie thread starter macrumors newbie

    Joined:
    Jun 13, 2003
    Location:
    Barnsley
    #5
    cheers

    thanks...

    all i want to know about filemake is can you use its files as the back end to php web sites like you can with ms .mdb files with .asp

    just as an alternative to mySQL if i couldnt figure it out

    matt
     
  6. bbarnhart macrumors 6502a

    bbarnhart

    Joined:
    Jan 16, 2002
    Location:
    Stilwell, Kansas
    #6
    I've just been down this road. I built and installed newer versions of php and MySQL. For me, it was difficult because I'm not familiar gcc and UNIX (I am a Windows developer). After two weeks I did get it setup and I'm starting to use it. If you have specific questions, post them here. I don't have a tutorial, but conceptdev provided some good links. Also, search the web for php mysql mac os x. There are tons of articles.

    I believe that MySQL and PHP are already included with Mac OS X, but you do need to turn them on. I think this is a great exercise for learning the Termianl and UNIX.
     
  7. massie thread starter macrumors newbie

    Joined:
    Jun 13, 2003
    Location:
    Barnsley
    #7
    :)

    thanks ill do that

    its great to see so many people are helpfull on here :)
     
  8. sonofslim macrumors 6502a

    sonofslim

    Joined:
    Jun 6, 2003
    #8
    oddly enough, i was just discussing this with some web engineers the other day. it's been my experience, and these guys agreed, that filemaker is a poor choice if your main concern is integration with a front-end. these guys were saying that when the task is to connect a db to php or other some other dynamic front end, if the db happens to be filemaker, most of the time it's easier to migrate to some flavor of sql, visual basic, or other database. getting filemaker to play nice with php (or asp or whatever your environment is) can be such a bear that most of the time it's just not worth it.

    filemaker is great as a stand-alone, but it's not ideal for anything more than the simplest of access or mods by an external application. go with mySQL (my preference) or vb.

    and a very good walkthrough of setting up apache and mySQL (and configuring them properly and securely) under OS X can be found here: http://www.macdevcenter.com/pub/a/mac/2003/04/04/apache_jaguar_pt1.html
     

Share This Page