Using Dreamweaver 8 to generate PHP/ODBC Code

[Guest]

Is there a way for Dreamweaver to generate PHP/ODBC code instead of MySQL code?????

[Newsgroup_User]

Yes! Just connect to any database you want to.
Dave
"NeilSwartz" <webforumsuser@macromedia.com> wrote in message
news:fseiah$mr4$1@forums.macromedia.com...
> Is there a way for Dreamweaver to generate PHP/ODBC code instead of MySQL
code?????
>

[Newsgroup_User]

NeilSwartz wrote:
> Is there a way for Dreamweaver to generate PHP/ODBC code instead of MySQL code?????

Yes, but only if you code it by hand. If you would like Dreamweaver to
do automatic code generation for PHP/ODBC, file a feature request
through the official form:

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

The more people request a particular feature, the more likely it is to
be included in a future release.

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

[Newsgroup_User]

Sorry I did not know that dreamweaver generated code for php was only for
MySQL only? I use vbscript and it can be used for both.
Why is that? I think I could use CF and Asp.net vbscript with MySQL also.
Dave
"David Powers" <david@example.com> wrote in message
news:fsek9t$on0$1@forums.macromedia.com...
> NeilSwartz wrote:
> > Is there a way for Dreamweaver to generate PHP/ODBC code instead of
MySQL code?????
>
> Yes, but only if you code it by hand. If you would like Dreamweaver to
> do automatic code generation for PHP/ODBC, file a feature request
> through the official form:
>
> http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform
>
> The more people request a particular feature, the more likely it is to
> be included in a future release.
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

[Newsgroup_User]

Baxter wrote:
> Sorry I did not know that dreamweaver generated code for php was only for
> MySQL only? I use vbscript and it can be used for both.
> Why is that?

The PHP code generated by Dreamweaver was originally developed about
five years ago, when connection to a database relied on
database-specific functions. So, you needed completely different
functions to query MySQL, PostgreSQL, MS SQL Server, etc.

A third-party developer called InterAKT created a Dreamweaver extension
called PhAKT, which uses ODBC connections. However, InterAKT was bought
by Adobe a couple of years ago; and PhAKT was never updated to work with
newer versions of Dreamweaver. A group of PhAKT enthusiasts want to
create an open-source version, but I don't think they ever got very far.

PHP now has PDO (PHP Data Objects), which is completely
database-neutral. One reason it hasn't been incorporated into
Dreamweaver is because PDO requires a minimum of PHP 5.1, and the vast
majority of hosting companies still offer only PHP 4. Since the vast
majority of hosting companies offer PHP in conjunction with MySQL, the
Dreamweaver combination makes a lot of sense, but it's not ideal for
everyone. However, I suspect that the feeling is that anyone who wants
to use PHP in conjunction with a database other than MySQL is more
likely to have the skill to code everything by hand.

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