Login   Register  
PHP Classes
elePHPant
Icontem

Update Environment: Update database and files from a remote server

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   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: 695 All time: 4,317 This week: 1,523Up
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
Winner


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: 1916132 in Brazil Brazil
Week rank: 1843 Up137 in Brazil Brazil Down
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 README.md 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:695All time:4,317
 This week:0This week:1,523Up