query another database
Posted: 03 March 2008 07:41 AM   [ Ignore ]  
Research Assistant
Avatar
RankRankRank
Total Posts:  676
Joined  02-14-2008

OK - so I’ve got EE doing my bidding nicely, however one of my clients is a recruitment business which advertises vacancies. It would be easy enough to customise a blog to accept job details, however, my client uses a specialised recruitment system with a MySQL db.

Can I get EE to query this if I had the details?

Profile
 
 
Posted: 03 March 2008 07:47 AM   [ Ignore ]   [ # 1 ]  
Research Assistant
RankRankRank
Total Posts:  565
Joined  02-25-2003

Sure. You could make queries using PHP, right?
Just turn on PHP parsing for the template that you are using and then you are ready to go.

http://expressionengine.com/docs/templates/php_templates.html

Profile
 
 
Posted: 03 March 2008 08:36 AM   [ Ignore ]   [ # 2 ]  
Research Assistant
Avatar
RankRankRank
Total Posts:  567
Joined  07-22-2004

sure, SELECT * FROM database.table works in EE,
so you can manipulate tables outside the EE database.

 Signature 

ExpressionEngineer - custom solutions for EE

I EE

Profile
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1743, on December 02, 2009 03:47 PM
Total Registered Members: 120586 Total Logged-in Users: 56
Total Topics: 126624 Total Anonymous Users: 38
Total Replies: 665659 Total Guests: 320
Total Posts: 792283    
Members ( View Memberlist )