<?php include 'includes/functions.php'; include 'includes/header.php'; ?> <article> <?php foreach (getCharacters($mysqli) as $character) { ?> <div class="character"> <h2><?php echo $character->name; ?> </h2> <p>Race <?php echo $character->race; ?> </p> </div> <?php } ?> </article> <?php include 'includes/footer.php';
{ $myDB = new DBFactory(); $sql = $myDB->getMysqlConnexionWithPDO(); $query = $sql->prepare("SELECT chars.*, class.name AS className, spec1.role_name AS role1, spec2.role_name AS role2 FROM chars, specs AS spec1, specs AS spec2, class WHERE chars.spec1 = spec1.id AND chars.spec2 = spec2.id AND spec1.class_id = class.id"); $query->execute(); return $query->fetchAll(); } ?> <div id="roles_content"> <div id="roles"> <h1>Composition de raid</h1> <div class="role" id="raid_chars"> <h2>Raideurs</h2> <ul id="user"> <?php $results = getCharacters(); foreach ($results as $result) { $id = $result['id']; echo '<li class="className class' . ucfirst($result['className']) . '" id="' . $result['id'] . '">' . '<input type="hidden" id="' . $id . '_name" value="' . ucfirst($result['name']) . '" />' . '<input type="hidden" id="' . $id . '_spec1" value="' . $result['spec1'] . '" />' . '<input type="hidden" id="' . $id . '_spec2" value="' . $result['spec2'] . '" />' . '<input type="hidden" id="' . $id . '_role" value="' . $result['role1'] . '" />' . '<input type="hidden" id="' . $id . '_role1" value="' . $result['role1'] . '" />' . '<input type="hidden" id="' . $id . '_role2" value="' . $result['role2'] . '" />' . ucfirst($result['name']) . '<span id="' . $id . '_role_selector" class="roleSelector">' . '<img id="' . $id . '_role1_img" src="./img/role_' . $result['role2'] . '_off.png" title="' . $result['role2'] . '" class="a roleImg" onclick="assignRole(1, \'' . $result['role2'] . '\', ' . $id . ')" />' . '<img id="' . $id . '_role2_img" src="./img/role_' . $result['role1'] . '_on.png" title="' . $result['role1'] . '" class="a roleImg" onclick="assignRole(2, \'' . $result['role1'] . '\', ' . $id . ')" />' . '</span></li>'; } ?> </ul> </div> <div class="role" id="raid_comp"> <h2>Raid</h2> <ul id="raid"> <div class="group"> <h2>Groupe 1</h2> <ul class="gr"> </ul> </div>