���ѧۧݧ�ӧ�� �ާ֧ߧ֧էا֧� - ���֧էѧܧ�ڧ��ӧѧ�� - /var/www/dev-kft.petruch.de/classes/tablet.class.php
���ѧ٧ѧ�
<?php class Tablet{ private $sql = false; public $path = 'files/tablet/'; function __construct() { global $sql; $this->sql = $sql; } /** * Add Order * @param object $p * @return boolean */ public function add($p) { if($p->machineID == 0) return false; $color = generateLightColor(); $hash = $this->getHash(); return $this->sql->insert('tablet', 'machineID,name,pin,color,hash,created,changed', [$p->machineID,$p->name,$p->pin,$color,$hash,NOW, NOW]); } /** * Get Tablet Hash */ public function getHash() { $hash = createHash(); if($this->sql->select('id', 'tablet', 'hash=?', $hash, 1)) return $this->getHash(); return $hash; } /** * Delete Order * @param int $orderID * @return boolean */ public function delete($p) { return $this->sql->delete('tablet', 'id=?', [$p->tabletID]); } /** * Change Order * @param object $p * @return boolean */ public function change($p) { return $this->sql->update('tablet', 'machineID,pin,name,color,changed', [$p->machineID,$p->pin,$p->name,$p->color,NOW], 'id=?', $p->tabletID); } /** * Get all Tablets * @return array */ public function getAll() { return $this->sql->select('t.id,t.machineID,t.name,t.color, t.pin, t.hash, m.name AS machineNameShow', 'tablet t, machine m WHERE m.id = t.machineID ORDER BY t.name ASC',); } /** * Get Tablet * @param int $tabletID * @return object */ public function getTablet($tabletID) { return $this->sql->select('t.id,t.machineID,t.name,t.color, t.pin, t.hash, m.name AS machineNameShow', 'tablet t, machine m','m.id = t.machineID AND t.id=?', [$tabletID], 1); } }
| ver. 1.4 |
Github
|
.
| PHP 8.3.33 | ���֧ߧ֧�ѧ�ڧ� ����ѧߧڧ��: 0 |
proxy
|
phpinfo
|
���ѧ����ۧܧ�