PHP and SQL

Report · Dec 17, 2007

Is it possible to use php to display records from an SQL (not MySQL) database hosted on a separate server? I don't need how-to details at this point, just whether or not it is possible. Thanks

Report · Dec 17, 2007

"BrianArena" <webforumsuser@macromedia.com> wrote in message
news:fk6s99$88$1@forums.macromedia.com...
> Is it possible to use php to display records from an SQL (not MySQL)
> database hosted on a separate server? I don't need how-to details at this
> point, just whether or not it is possible. Thanks

You mean Microsoft SQL Server? Yes that is possible

Report · Dec 17, 2007

So is there a difference between Microsoft SQL and (non-Microsoft) SQL. The boss didn't mention "Microsoft" SQL, just SQL.

Report · Dec 17, 2007

BrianArena wrote:
> So is there a difference between Microsoft SQL and (non-Microsoft) SQL. The boss didn't mention "Microsoft" SQL, just SQL.

Microsoft SQL Server is just one of many database systems that use SQL
(Structured Query Language), the standard language for communication
with a relational database. SQL is a common standard used by MySQL,
PostgreSQL, Access, Oracle, Microsoft SQL Server, and many other
database systems.

Unfortunately, although SQL is a standard, each database system uses its
own dialect. The basic commands are the same, but the finer details
differ according to the database system.

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

Report · Dec 17, 2007

Joris van Lier wrote:
> You mean Microsoft SQL Server? Yes that is possible

As Joris says, it's possible. PHP supports all major database systems.

However, the code automatically generated by Dreamweaver server
behaviors supports PHP only in combination with MySQL. To support any
other database, you need to hand-code everything.

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