exec('CREATE TABLE IF NOT EXISTS boxbrdash(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title_name VARCHAR(100), ateam_id VARCHAR(100), bteam_brand VARCHAR(100), cteam_model VARCHAR(100), dteam_user VARCHAR(100), status VARCHAR(100), expire VARCHAR(100), createdon VARCHAR(100))'); $rows = $dbboxbra->query('SELECT COUNT(*) as count FROM boxbrdash'); $row = $rows->fetchArray(); $numRows = $row['count']; #$HOSTa = $lurl = (isset($_SERVER['HTTPS']) && ($_SERVER['HTTPS'] !== 'off') ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/img/boxbr_demo.png'; $date = date('Y-m-d H:i:s'); if(isset($_GET['delete'])){ $dbboxbra->exec('DELETE FROM boxbrdash WHERE id=' . $_GET['delete']); $msg = '?messageE=Item Deletado!'; header('Location: dash.php'.$msg); } include 'includes/header.php'; echo ' ' . "\n"; echo '
' . "\n"; if (isset($_GET['message'])) { echo '

'.$_GET['message'].'

'; } if (isset($_GET['messageA'])) { echo '

'.$_GET['messageA'].'

'; } if (isset($_GET['messageE'])) { echo '

'.$_GET['messageE'].'

'; } if (isset($_GET['messageS'])) { echo '

'.$_GET['messageS'].'

'; } echo ' ' . "\n"; echo '
' . "\n"; echo "\n"; echo ' ' . "\n"; echo '
' . "\n"; echo "\n"; echo ' ' . "\n"; echo '
' . "\n"; echo '

   Gerenciador de Clientes

' . "\n"; echo '
Add Cliente' . "\n"; echo ' ' . "\n"; echo '
' . "\n"; echo '
' . "\n"; $dbboxbra = new SQLite3('./api/.boxbr_dash.db'); $res = $dbboxbra->query('SELECT * FROM boxbrdash'); while ($row = $res->fetchArray()) { echo ' ' . "\n"; } $dbboxbra->close(); echo '
Cliente Usuario ID Marca Modelo Criado em Validade Status Editar Deletar
'.$row['title_name'].' '.$row['dteam_user'].' '.$row['ateam_id'].' '.$row['bteam_brand'].' '.$row['cteam_model'].' '.$row['createdon'].' '.$row['expire'].' '.$row['status'].'
' . "\n"; echo "\t\t" . '
' . "\n"; echo '' . "\n"; echo "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '
' . "\n"; ?> function myFunction(DIV) { var x = document.getElementById(DIV); var y = document.getElementById(DIV+"show"); if (x.style.display === "none") { x.style.display = "block"; y.className = "fa fa-minus"; } else if (x.style.display === "block") { x.style.display = "none"; y.className = "fa fa-plus"; }else { x.style.display = "none"; y.className = "fa fa-plus"; } } '."\n"; echo ' ' . "\n"; echo ' ' . "\n"; ############# end ############## include 'includes/footer.php'; require ('includes/boxbr.php'); print "\n"; ?>