[anothermacguy]

So, lets say I created a site using Drumbeat 2000 (a year or so back). It was an ASP site. I currently have PHP installed on my beta system. I have also found an ASP to PHP script, which converts your ASP to PHP. The database I was using before was from Access (97). Can I make this all work as it did before? How do I get the ODBC connection I was using before work here? Is there an ODBC manager for OSX thats free? After I set up the ODBC, and convert the ASP to PHP, should everything work?

Once again, everyones help is appreciated. Thanks

[iloveOSX]

i am not aware of an odbc driver. (maybe merent?) do you have to use access?

[genevish]

Some possible solutions, from the PHP site.

[anothermacguy]

No, I don't have to use access. Thats just what the database is in now. I have been meaning to learn MySQL, which would also benefit a number of other things I'm trying to do.

If anyone has some good tutorials for mysql, to help building a simple database, and then connecting this to the web. Please help. I just find Ultradev, and Drumbeat very easy to create dynamic data driven pages. If you have a preferred way, please mention it.

Thanks again.

[iloveOSX]

i really liked the "mysql" book from dubois. search amazon (he's a mac guy too) there is no short answer. you are going to have to bite the bullet and learn mysql. the good enws is that its much esaier than it seems. the great thing about php is the mysql support is built in which means after you install them both (url for mat's installers here) then you will be up and running.

the bad news (which is actually good) is that you will need to edit all your php in text editor. get bbedit 6. it colorizes the php code. the reason why this is good news is that is forces you to design the db and logic flow the site out first! then and only after everything is working do you move in with dreamwaever. (they won't touch the php code) and clean it up and add graphics. no more starting with a pretty html page first then adding code.

the best learning php book imo is the "php fast a easy dev" go to thickbook.com. she wrote a great book.

[iloveOSX]

go to the "MySQL on OS X- Does this one work? " thread for the url.

you can do it. do not be intimated. yes us mac folks prefer the visual tools but if you want to solve all your db/middleware questions then install php and mysql.

you will be very happy.

[anothermacguy]

Thanks iLoveOSX

[genevish]

Here's the tutorial that got me started. Now I code PHP on MySQL for a living. (Sounds like a commercial, doesn't it?)
http://hotwired.lycos.com/webmonkey/99/21/index2a.html

-Scott

------------------
Scott Genevish
genevish@mac.com
------------------

[anothermacguy]

Thanks genevish, thats a great tutorial! Perfect for newbies.

[timster]

I learned PHP in a matter of months, and its a great, useful language for
doing really fun stuff. Someone suggested BBEdit as a good php editor. I might suggest Pepper from www.hekkelman.com. This is turning out to be one elegant text editor, and supports PHP/ and other color syntax coding much better than BBedit, and doesnt exhibit that anti-alias ghosting problem like in BBedit.

It has keyboard mapping too, so you can acutally get "home" and "end" to work just like it should work, (invaluable for programming!)

[iloveOSX]

try them both. they both have demos/. bbedit 6 does color code php. don't know what the antialiad problem is. are you running in osX?