PHP Classes

File: index.php

Recommend this page to a friend!
  Classes of Dave Smith   JSON DB Project   index.php   Download  
File: index.php
Role: Example script
Content type: text/plain
Description: Application Usage
Class: JSON DB Project
Create and manage database stored in JSON files
Author: By
Last change:
Date: 7 years ago
Size: 2,370 bytes
 

Contents

Class file image Download
<?php
require_once('jsondb.init.php');
if (
$_REQUEST['process'] and $_REQUEST['dbName']) {
 
$dbName = $_REQUEST['dbName'];
 
$dbData = $jdb->rDataBase($dbName);
 switch (
$_REQUEST['action']) {
  case
'createDB':
  
$jdb->cDataBase($dbName);
   break;
  case
'updateDB':
   if (empty(
$_REQUEST['id'])) {
   
//adding record
   
$id = $jdb->nextRecord($dbData);
   
$dbData[$id]['title'] = (!empty($_REQUEST['title'])) ? $_REQUEST['title'] : $dbData[$id]['title'];
   
$dbData[$id]['author'] = (!empty($_REQUEST['author'])) ? $_REQUEST['author'] : $dbData[$id]['author'];
   } else {
   
$id = $_REQUEST['id'];
    if (empty(
$_REQUEST['title']) and empty($_REQUEST['author'])) {
    
//removing record
    
foreach ($dbData as $key => $value) {
      if (
$key == $id) {
       continue;
      }
      foreach (
$dbData[$key] as $field => $value) {
      
$dbNew[$key][$field] = $value;
      }
     }
    
$dbData = $dbNew;
    } else {
    
//changing record
    
$dbData[$id]['title'] = (!empty($_REQUEST['title'])) ? $_REQUEST['title'] : $dbData[$id]['title'];
    
$dbData[$id]['author'] = (!empty($_REQUEST['author'])) ? $_REQUEST['author'] : $dbData[$id]['author'];
    }
   }
  
$jdb->uDataBase($dbName, $dbData);
   break;
  case
'deleteDB':
  
$jdb->dDataBase($dbName);
   unset(
$dbData);
   break;
 }
} else {
 
$dbName = 'test.jdb';
 
$dbData = $jdb->rDataBase($dbName);
}
?>
<!DOCTYPE HTML>
<html>
<head>
  <title>jsonDB Test Script</title>
</head>
<body>
  <form method="post">
   Database Name: <input type="text" name="dbName" value="<?php
   
echo HtmlSpecialChars($dbName);
  
?>" /><br />
   <input type="radio" name="action" value="createDB" /> Create<br />
   <input type="radio" name="action" value="deleteDB" /> Delete
   <hr />
   Record ID: <input type="text" name="id" /> <em>(Leave blank to use next ID number)</em><br />
   Title: <input type="text" name="title" /><br />
   Author: <input type="text" name="author" /><br />
   <input type="radio" name="action" value="updateDB" /> Update<br />
   <em>(Providing a record id without a title or author will delete that record)</em>
   <hr />
   <input type="hidden" name="process" value="1" />
   <input type="submit" name="formSubmit" value="Submit" />
  </form>
  <hr />
  <?php
   var_dump
($dbData);
 
?>
</body>
</html>