PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Ovunc Tukenmez   PHP MYSQL Undo Query   example.php   Download  
File: example.php
Role: Unit test script
Content type: text/plain
Description: examples
Class: PHP MYSQL Undo Query
Log changes to tables to revert the changes later
Author: By
Last change: Update of example.php
Date: 2 months ago
Size: 1,893 bytes
 

Contents

Class file image Download
<?php
require_once("MYSQLUndo.php");

/**
* setup example 1: lets enable logging for table "test_table"
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->enableLogging('test_table');
if (!
$result){ echo $class1->getLastErrorMessage(); }

/**
* setup example 2: lets disable logging for table "test_table"
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->disableLogging('test_table');
if (!
$result){ echo $class1->getLastErrorMessage(); }

/**
* usage example 1: lets revert back all records which affected in 1 hour before now
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->revertChanges('test_table', gmdate("Y-m-d H:i:s", time() - 60 * 60));
if (!
$result){ echo $class1->getLastErrorMessage(); }

/**
* usage example 2: lets revert back all records which affected until 1 hour before now
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->revertChanges('test_table', null, gmdate("Y-m-d H:i:s", time() - 60 * 60));
if (!
$result){ echo $class1->getLastErrorMessage(); }

/**
* usage example 3: lets revert back all records which affected in 3 hours before now until 1 hour before now
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->revertChanges('test_table', gmdate("Y-m-d H:i:s", time() - 3 * 60 * 60), gmdate("Y-m-d H:i:s", time() - 60 * 60));
if (!
$result){ echo $class1->getLastErrorMessage(); }

/**
* usage example 4: lets revert back (actually delete in this example) only inserted records which affected in 1 hour before now
*/
$class1 = new MYSQLUndo('localhost', 'test_db', 'root', 'password');
$result = $class1->revertChanges('test_table', gmdate("Y-m-d H:i:s", time() - 3 * 60 * 60), null, true, false, false);
if (!
$result){ echo $class1->getLastErrorMessage(); }

?>