Page 1 of 1
Can PHP be used to pull data from a ColdFusion db?
Posted: Fri Apr 28, 2006 9:04 am
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?
Posted: Fri Apr 28, 2006 10:29 am
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.
Posted: Fri Apr 28, 2006 10:47 am
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.
Posted: Fri Apr 28, 2006 11:12 am
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!
Posted: Fri Apr 28, 2006 12:26 pm
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>'.
Posted: Fri Apr 28, 2006 12:54 pm
by cdickson
Thanks for pointing me in the right direction. I'll see what I can find out.