Is it possible to use dreamweaver to connect to an access db with PHP? I know
the option in DW is PHP MySQL. I love dreamweaver and hate that future
versions won't support asp. So I'm trying to expand my horizons to the PHP
MySQL Apache phenomenon. I'm having a hell of a time with mysql and apache, so
before I give up entirely, I figured maybe I'll take baby steps. So in an
effort to get a working dynamic site and to learn PHP at the same time, I want
to do the above mentioned?

Can I do it?

Mack879w wrote:
> Is it possible to use dreamweaver to connect to an access db with PHP?

Yes, but only if you code everything by hand. If you want to use
Dreamweaver server behaviors, you need to use MySQL.

> I love dreamweaver and hate that future
> versions won't support asp.

I can't say what will happen in future versions, but the next version of
Dreamweaver (CS4) WILL support ASP. What is being dropped is support for
ASP.NET.

> So I'm trying to expand my horizons to the PHP
> MySQL Apache phenomenon. I'm having a hell of a time with mysql and apache, so
> before I give up entirely, I figured maybe I'll take baby steps.

MySQL and Apache are very easy to use. If you want something to guide
you through the process in simple steps, consider grabbing hold of a
copy of my book, "The Essential Guide to Dreamweaver CS3 with CSS, Ajax,
and PHP". It covers Apache, PHP, and MySQL setup in great detail, and
also guides you through setting up a database, and using all the PHP
server behaviors.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

I've heard they are easy to use, and I realize how popular they both are. I
have had nothing but headaches with them. I do have your book and followed
that. I keep getting errors from the service not starting to the Instance
Config Wiz not even starting. Solutions range from reinstalling to hacking the
exe and recompiling. (Both of these solutions come from the MySQL website). It
just gets so aggrevating. I have a little expirience with ASP and never had
these difficulties. I don't want to part with Dreamweaver and use Expression
but if I can't get PHP and MySql to work, I may have too. At this point, it's
just too difficult to get working when I know something else that doesn't give
me nearly as many problems.

Mack879w wrote:
> I keep getting errors from the service not starting to the Instance
> Config Wiz not even starting. Solutions range from reinstalling to hacking the
> exe and recompiling. (Both of these solutions come from the MySQL website).

I've never heard of anything like that being necessary. It sounds as
though you have either downloaded the wrong version of MySQL or there is
something blocking the program (probably a firewall or anti-virus
program). MySQL comes complete with a Windows installer, so it should be
no different from installing any other program. However, many people
find that XAMPP solves all their problems, as it installs Apache, PHP,
MySQL, and phpMyAdmin in a single operation.

> just gets so aggrevating. I have a little expirience with ASP and never had
> these difficulties. I don't want to part with Dreamweaver and use Expression

As I said before, Dreamweaver is NOT ending support for classic ASP. I
haven't tried Expression Web, but online reviews say it has only limited
support for ASP.

Since ASP is no longer being developed by Microsoft, sooner or later
you'll have to bite the bullet and switch to ASP.NET, PHP, or ColdFusion.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/