prepare('SELECT COUNT(1) FROM machines WHERE machines.name=:name'); $stm -> bindValue('name', $_GET['new']); $result = $stm -> execute(); $result = $result -> fetchArray(); $stm -> close(); if ($result[0] == 0) { $stm = $db -> prepare('INSERT INTO machines (name,key,online) VALUES (:name,:key,0)'); $stm -> bindValue('name', $_GET['new']); $stm -> bindValue('key', bin2hex(random_bytes(64))); $stm -> execute(); $stm -> close(); } $stm = $db -> prepare('SELECT machines.key FROM machines WHERE machines.name=:name'); $stm -> bindValue('name', $_GET['new']); $result = $stm -> execute(); $result = $result -> fetchArray(); echo 'key = ' . $result['key'] . "\n"; die(); } } $columns = array('name', 'online', 'last_update'); $result = $db -> query('SELECT machines.name,machines.online,machines.last_update FROM machines;'); echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo ' ' . "\n"; foreach ($columns as $column) { echo ' ' . "\n"; } echo ' ' . "\n"; while ($row = $result -> fetchArray()) { echo ' ' . "\n"; foreach ($columns as $column) { echo ' ' . "\n"; } echo ' ' . "\n"; } echo '

' . $column . '
' . $row[$column] . '

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