source: database_list.php@ 30

Last change on this file since 30 was 30, checked in by george, 17 years ago
  • Přidáno: Podpora pro určování v definicích krom tabulky také jméno databáze a jméno primárního identifikačního sloupce.
File size: 1.2 KB
Line 
1<?php
2
3class DatabaseList extends Module
4{
5 var $Dependencies = array('Log', 'User');
6
7 function AddItem($TableId, $Values)
8 {
9 $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
10 $DbRow = $DbResult->fetch_assoc();
11 $TableName = $DbRow['TableName'];
12
13 $this->Database->insert(array('Table' => $TableName), $Values);
14 return($this->Database->insert_id);
15 }
16
17 function DeleteItem($TableId, $ItemId)
18 {
19 $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
20 $DbRow = $DbResult->fetch_assoc();
21 $TableName = $DbRow['TableName'];
22 $this->Database->delete(array('Table' => $TableName, 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
23 }
24
25 function EditItem($TableId, $Values, $ItemId)
26 {
27 $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
28 $DbRow = $DbResult->fetch_assoc();
29 $TableName = $DbRow['TableName'];
30 $this->DeleteItem($TableId, $ItemId);
31 $Values['Id'] = $ItemId;
32 $this->Database->replace(array('Table' => $TableName), $Values);
33 }
34}
35
36?>
Note: See TracBrowser for help on using the repository browser.