PHP Classes

Update Environment: Update database and files from a remote server

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files Example   View files View files (10)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2012-08-15 (2 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 703 All time: 4,332 This week: 1,320Up
Version License PHP version Categories  
update-enviroment 1BSD License5.3PHP 5, Databases, Systems administration
Description Author  

This class can update database and files from a remote server.

The main class can connect to a remote MySQL database using PDO and retrieve the list of tables to compare with the locale MySQL database synchronize the new tables that need to be created or the existing tables that need to be updated.

Another class can also synchronize files referenced by specific database table records as they contain data not stored in the database itself.

A list of specific tables may be intentionally excluded from the synchronization process.

Innovation Award  
PHP Programming Innovation award winner
September 2012

Prize: One yearly subscription to the PHP Solutions magazine
Some database applications manage content information that can be large. Usually those application store large content in separate files and just keep a reference in the database to the data files.

In this situation, if you want to backup or synchronize the database contents you also need to transfer the data files.

This class provides a solution that can synchronize both the MySQL database data and any separate files associated to given table fields.

Manuel Lemos
Picture of Alexsandro Souza
Name: Alexsandro Souza <contact>
Classes: 2 packages by
Country: Brazil Brazil
Age: 26
All time rank: 1925132 in Brazil Brazil
Week rank: 990 Up79 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

  Files folder image Files  
File Role Description
Files folder imageclass (4 files)
Files folder imagedownloaded (2 files)
Files folder imageexample (3 files)
Accessible without login Plain text file Data Auxiliary data

  Files folder image Files  /  class  
File Role Description
  Plain text file DataBase.class.php Class Class source
  Plain text file Download.class.php Class Class source
  Plain text file RecordFilter.class.php Class Class source
  Plain text file UpdateDataBase.class.php Class Class source

  Files folder image Files  /  downloaded  
File Role Description
  Accessible without login Image file pendrive.gif Photo Photograph
  Accessible without login Image file testeimage.png Photo Photograph

  Files folder image Files  /  example  
File Role Description
  Accessible without login Plain text file Customer.class.php Aux. Example script
  Accessible without login Plain text file index.php Example Example script
  Accessible without login Plain text file Product.class.php Aux. Example script

 Version Control Unique User Downloads Download Rankings  
 100%Total:703All time:4,332
 This week:0This week:1,320Up