Real Estate Forums

MLS listings and IDX Solutions Discuss implementation of MLS / IDX solutions, MLS providers and how to improve conversion using the multiple listings service available in your area.

Reply
 
Thread Tools Display Modes
Old 02-26-2008, 07:05 AM
Cameron Cameron is offline
New real estate webmaster
 
Join Date: Feb 2008
Posts: 4
Cameron is on a distinguished road
Default php mySQL to Actionscript/Adobe Flex

Hi all
I'm new to real estate site development, with experience with php, mysql, actionscript, html, css. I want to create a php script to parse mls data and populate a mysql database for subsequent listing on the site I'm developing. I was thinking I could then convert the DB to xml and use it in a Adobe Flex user interface through actionscript. I think this is feasible. Does anyone see any holes in the logic of what I'm suggesting? Has anyone done something like this? Also, is there a resource for php MLS integration that could get me jumpstarted on that end of things? I'm eager to share my experience and thanks in advance for your help.
Cameron
Reply With Quote
Old 02-26-2008, 10:11 AM
webmaster's Avatar
webmaster webmaster is offline
Administrator
 
Join Date: Apr 2004
Posts: 13,816
webmaster will become famous soon enough
Default Re: php mySQL to Actionscript/Adobe Flex

Really depends on what you are planning for the FLEX deployment, often times creative tallented developer types go way to far on the "cool factor" and create something that the general public simply does not understand.

Were you thinking you were just going to connect an xml feed to a flash output or something? There is a simple example of this at www.realsourcebrokers.com (Check out the flash map on the right hand side, it connects to the mysql database for the FAR IDX feed
__________________
Strep throat! - Yup tis the season - boooo if you are wondering why you haven't seen me as much it's because I had strep throat for a week, feeling better just playing catch up. Merry Ho Ho folks
Reply With Quote
Old 02-26-2008, 01:41 PM
Cameron Cameron is offline
New real estate webmaster
 
Join Date: Feb 2008
Posts: 4
Cameron is on a distinguished road
Default Re: php mySQL to Actionscript/Adobe Flex

The flash map is a great sample, thanks for the inspiration.
I'd like to make the interface more than a static table view. Accordion menus come to mind. Maybe it sounds flashy, but I think it could be cool and useful. First thing however, I'd like get the mls into a database, or access a remote database. My client has already submitted a request to the Tucson Assoc of Realtors, but I honestly don't know what to expect. Will they give me an ftp login to download CSV files based on given parameters, that I can then put into a local mysql database? Or will it be a remote database hosted by MLS that processes user requests live?
Reply With Quote
Old 02-26-2008, 03:13 PM
webmaster's Avatar
webmaster webmaster is offline
Administrator
 
Join Date: Apr 2004
Posts: 13,816
webmaster will become famous soon enough
Default Re: php mySQL to Actionscript/Adobe Flex

It's typically an FTP push in whatever their format is CSV is common, then you just write your own cron script for future download that includes a parsing script to import the IDX data into mysql or whatever your flavor is - once data is in a normalized format I am sure you know what to do with a database
__________________
Strep throat! - Yup tis the season - boooo if you are wondering why you haven't seen me as much it's because I had strep throat for a week, feeling better just playing catch up. Merry Ho Ho folks
Reply With Quote
Old 02-26-2008, 05:11 PM
Cameron Cameron is offline
New real estate webmaster
 
Join Date: Feb 2008
Posts: 4
Cameron is on a distinguished road
Default Re: php mySQL to Actionscript/Adobe Flex

Sounds good, thanks for the info. I'll update on how things go.
Reply With Quote
Old 03-09-2008, 01:00 PM
RS305 RS305 is offline
New real estate webmaster
 
Join Date: Mar 2008
Location: Miami, FL
Posts: 17
RS305 is on a distinguished road
Default Re: php mySQL to Actionscript/Adobe Flex

Quote:
Originally Posted by webmaster View Post
It's typically an FTP push in whatever their format is CSV is common, then you just write your own cron script for future download that includes a parsing script to import the IDX data into mysql or whatever your flavor is - once data is in a normalized format I am sure you know what to do with a database
Do you have experience in getting this data from the various boards? Is there a central store of this data, or is it done on the per-board basis everywhere?
__________________
SellFoN.com | Webinars & Tutorials
Lead Generation and Marketing for Real Estate Professionals
Reply With Quote
Old 07-29-2008, 12:47 PM
blueinkdesign blueinkdesign is offline
New real estate webmaster
 
Join Date: Jul 2008
Posts: 1
blueinkdesign is on a distinguished road
Default Re: php mySQL to Actionscript/Adobe Flex

I am looking to hire someone to create an XML feed or other MLS-dynamic data feed for use in flash. The MLS I am dealing with is Aspen, Colorado. Anyone have any experience? Interested in the project?
-Adam
Reply With Quote
Old 07-29-2008, 07:21 PM
webmaster's Avatar
webmaster webmaster is offline
Administrator
 
Join Date: Apr 2004
Posts: 13,816
webmaster will become famous soon enough
Default Re: php mySQL to Actionscript/Adobe Flex

Adam, are you doing all the flash work?
__________________
Strep throat! - Yup tis the season - boooo if you are wondering why you haven't seen me as much it's because I had strep throat for a week, feeling better just playing catch up. Merry Ho Ho folks
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
php and mysql rajpreet Coding 4 12-01-2007 03:20 AM
Require PHP scripts to display NWMLS mysql queries on website darthwader MLS listings and IDX Solutions 6 03-01-2007 12:00 AM
Mysql database - php won't insert data?? RESynergy Coding 3 01-23-2007 11:08 PM

For our members

Main Sections

IDX Coverage Areas

Spiders Welcome

All times are GMT -7. The time now is 09:08 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.