HELP mySQL + PHP

[massie]

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

 

[conceptdev]

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:Webserverocuments

 

[massie]

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

 

[buffsldr]

i know enough about fm pro to be dangerous. i recommend it

if u need help, please ask

 

[massie]

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

 

[bbarnhart]

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.

 

[massie]

thanks ill do that

its great to see so many people are helpfull on here

 

[sonofslim]

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