PHP Classes

File: index.php

Recommend this page to a friend!
  Classes of majid ramzani   Keep edit and delete database archive   index.php   Download  
File: index.php
Role: Example script
Content type: text/plain
Description: usage
Class: Keep edit and delete database archive
Access tables keeping deleted records archived
Author: By
Last change:
Date: 12 years ago
Size: 1,153 bytes
 

Contents

Class file image Download
<?php

include "KEDA.class.php";

$table="news";
$time=time();
$subject="test".$time;
$content="content of test ".$time;


//to insert row:
$insert=KEDA::Insert($table," (subject,content,date) values('$subject','$content','$time') ");
if(
$insert) echo "Row inserted. \n <br>"; else echo mysql_error()." \n <br> ";


//to delete
//change it frequently to see result!
$row_id=1;
$delete=KEDA::Delete($table,$row_id);
if(
$delete) echo "Row deleted. \n <br>"; else echo mysql_error()." \n <br> ";


//to delete
//change it frequently to see result!
$row_id=1;
$subject="test ".$time." edited";
$content="content of test ".$time." edited";

$edit=KEDA::Edit($table,$row_id," (subject,content,date) values('$subject','$content','$time') ");
if(
$edit) echo "Row edited. \n <br>"; else echo mysql_error()." \n <br> ";


//see edit and delete archive:
$row_id=1;
echo
"Delete Archive : \n <br>";
var_dump(KEDA::GetDeleteArchive($table));

echo
"Edit Archive : \n <br>";
var_dump(KEDA::GetEditArchiveData($table,$row_id));


//select data from db:
echo "Selected Data : \n <br>";
var_dump(KEDA::Select($table));