Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
php script to perform one way copy/sync operations between a sql file and an EZ Realty mysql database.
The script should be able to copy data from a sql file to EZ Realty mysql database, using some parameters.
The sql file and mysql database dont have the same estructure, and script must do match between fields.
1) The sql file is a dump of a real estate site database, and the destination database is an EZ Realty Real estate listing database.
2) There should be the possibility to perform update of mysql database based in some criteria:
records in sql file of a certain kind of type (for example: apartments and houses)
records in sql file of a certain kind of business (for example: rentals)
records in sql file of a certain kind of region (for example: region XX and region YY)
3) There should be the possibility to copy (update) records that already exists in database
For example, is record in sql file was updated and date/hour of update is after existing date/hour in mysql database.
4) The images are placed in a local folder, and they should be copied to EZ Realty records, and paths renamed.
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)