<?php use BattleChores\domain\creature\CreatureAttributeGateway; include 'config.php'; try { $database = new PDO($dsn, $user, $password); } catch (PDOException $e) { print 'Connection failed: ' . $e->getMessage(); } $errorCount = 0; if (!isset($_POST['Name']) || strlen($_POST['Name']) < 1) { print "<p>Please specify a name for the attribute</p>"; $errorCount++; } if (strlen($_POST['Name']) > 50) { print "<p>The attribute's name must be shorter than 50 characters</p>"; $errorCount++; } if ($errorCount == 0) { $attributeGateway = new CreatureAttributeGateway($database); $insertSuccess = $attributeGateway->insertNew($_POST['Name'], $_POST['Type']); if ($insertSuccess) { print "<p>Attribute " . $_POST['Name'] . " successfully added to the Database</p>"; } else { print "<p>Error Adding attribute " . $_POST['Name'] . "</p>"; } }
</select><br /> <input type="text" name="Name"> <input type="submit" value="Create"> <input type="reset" value="Restart"> </form> </div> <div> <h2>Attributes</h2> <table> <tr> <td>id</td> <td>name</td> <td>attribute type</td> </tr> <?php $attributegateway = new CreatureAttributeGateway($database); $attributes = $attributegateway->selectAll(); foreach ($attributes as $attribute) { print "<tr>"; print "<td>" . $attribute['id'] . "</td>"; print "<td>" . $attribute['name'] . "</td>"; print "<td>" . $attribute['type_name'] . "</td>"; print "</tr>"; } ?> </table> </div> </main> </body> </html>