Can PHP be used to pull data from a ColdFusion db?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cdickson
Forum Contributor
Posts: 120
Joined: Mon Apr 05, 2004 1:30 pm
Location: Michigan, USA

Can PHP be used to pull data from a ColdFusion db?

Post by cdickson »

We have a client who wants to change their web site from CF to PHP.

They have their own database, but also currently pull information from an outside ColdFusion database.

Is it possible to redevelop the site in PHP and call data from a CF database on just one page?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Does ColdFusion actually have its own RDBMS? I thought CF was a server-side processing language like PHP and the like? Maybe post some of code from your CF app (the part with the connection details) so we can see what you're connecting to and how.
User avatar
cj5
Forum Commoner
Posts: 60
Joined: Tue Jan 17, 2006 3:38 pm
Location: Long Island, NY, USA

Post by cj5 »

Is there such thing as a "ColdFusion" database? I think not. I'm sure the database that ColdFusion pulls from is probably a MSSQL server. In that case PHP can use an ODBC bridge to connect to that.
cdickson
Forum Contributor
Posts: 120
Joined: Mon Apr 05, 2004 1:30 pm
Location: Michigan, USA

Post by cdickson »

Everah wrote:Does ColdFusion actually have its own RDBMS? I thought CF was a server-side processing language like PHP and the like? Maybe post some of code from your CF app (the part with the connection details) so we can see what you're connecting to and how.
I was presuming that CF draws from MySQL or MSSQL. Since I don't know anything about CF I wasn't exactly sure how to pose the question.
cj5 wrote:Is there such thing as a "ColdFusion" database? I think not. I'm sure the database that ColdFusion pulls from is probably a MSSQL server. In that case PHP can use an ODBC bridge to connect to that.
I hope that this is the case - will check into the ODBC bridging process.

Thanks!
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Find out which RDBMS your CF app connects to (and if you can, look at the app's connection string). Then post back here or search these forums for 'Connect PHP to <insert_your_db_server_here>'.
cdickson
Forum Contributor
Posts: 120
Joined: Mon Apr 05, 2004 1:30 pm
Location: Michigan, USA

Post by cdickson »

Thanks for pointing me in the right direction. I'll see what I can find out.
Post Reply