Cod: Selectaţi tot
<?php
session_start();
include'core/database/connect.php';
include'includes/functions/variabile.php';
$n_apply = "";
$e_apply = "";
$o_apply = "";
$a_apply = "";
$x_apply = "";
$r_apply = "";
$id = 0;
$errors = array();
$succes = array();
$auth_add = $_SESSION['auth'];
if (isset($_POST['apply_submit'])) {
$n_apply = $_POST['apply_nume'];
$e_apply = $_POST['apply_email'];
$o_apply = $_POST['apply_ore'];
$a_apply = $_POST['apply_age'];
$x_apply = $_POST['apply_exp'];
$r_apply = $_POST['apply_rule'];
if (empty($n_apply)) { array_push($errors, "Numele este necesar!"); }
if (empty($e_apply)) { array_push($errors, "E-mail este necesar!"); }
if (empty($o_apply)) { array_push($errors, "Orele sunt necesare!"); }
if (empty($a_apply)) { array_push($errors, "Varsta este necesara!"); }
if (empty($x_apply)) { array_push($errors, "Experienta este necesara!"); }
if (empty($r_apply)) { array_push($errors, "Raspunsul este necesar!"); }
if (count($errors) == 0) {
if (!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/i", $e_apply)) {
array_push($errors, "E-mail invalid!");
} else {
if ($r_apply == $rules) {
if ($a_apply > $varsta) {
$nickname = $_SESSION['auth'];
$sql = "INSERT INTO $table_apply (auth, nume, email, varsta, ore, exp, rule) VALUES ('$nickname', '$n_apply', '$e_apply', '$a_apply', '$o_apply', '$x_apply', '$r_apply')";
mysqli_query($db, $sql);
array_push($succes, "Ai aplicat cu succes pentru admin!");
} else {
array_push($errors, "Nu ai varsta necesara!");
}
} else {
array_push($errors, "Citeste regulamentul sau introdu cheia corect!");
}
}
}
}
if (isset($_POST['comment'])) {
$authComm = $_SESSION['auth'];
$comment = $_POST['comments'];
if (empty($comment)) { array_push($errors, "Introdu un comentariu!"); }
if (count($errors) == 0) {
mysql_query($db, "INSERT INTO $table_apply (authComm, comment) VALUES ($authComm, $comment)");
header('Location: apply.php');
array_push($succes, "Comentariu postat!");
}
}
if (isset($_GET['view'])) {
$id = $_GET['view'];
$rec = mysqli_query($db, "SELECT * FROM $table_apply WHERE id=$id");
$record = mysqli_fetch_array($rec);
$v_auth = $record['auth'];
$v_nume = $record['nume'];
$v_email = $record['email'];
$v_age = $record['varsta'];
$v_ore = $record['ore'];
$v_exp = $record['exp'];
$v_status = $record['raspuns'];
$v_id = $record['id'];
}
if (isset($_GET['accept'])) {
$id = $_GET['accept'];
mysqli_query($db, "UPDATE $table_apply SET raspuns='Acceptat' WHERE id='$id'");
header('Location: apply.php');
array_push($succes, "Aplicatie acceptata!");
}
if (isset($_GET['reject'])) {
$id = $_GET['reject'];
mysqli_query($db, "UPDATE $table_apply SET raspuns='Respins' WHERE id='$id'");
header('Location: apply.php');
array_push($succes, "Aplicatie respinsa!");
}
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
mysqli_query($db, "DELETE FROM $table_apply WHERE id=$id");
header('location: add_admin.php');
}
$commrow = mysqli_query($db, "SELECT authComm, comment FROM $table_apply WHERE id='$id'");
$results = mysqli_query($db, "SELECT * FROM $table_apply ORDER BY id ASC");
include'includes/overall/header.php';
if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) {
?>
<?php
if (!$_GET['view']) {
?>
<div class="apply">
<div class="apply_title">
<h1>Aplica pentru admin</h1>
</div>
<form action="apply.php" method="POST">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<?php include('errors.php'); ?>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-user fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Nume real" name="apply_nume">
</div>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-envelope-o fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Adresa de e-mail" name="apply_email">
</div>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-clock-o fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Link ore jucate (minim 15)" name="apply_ore">
</div>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-graduation-cap fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Varsta (minim 16 ani)" name="apply_age">
</div>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-info fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Experienta admin" name="apply_exp">
</div>
<div class="input-group margin-bottom-sm">
<span class="input-group-addon"><i class="fa fa-list-ol fa-fw" aria-hidden="true"></i></span>
<input class="form-control" type="text" placeholder="Ai citit regulamentul?" name="apply_rule">
</div>
<div class="change_btn">
<button type="submit" name="apply_submit">Aplica</button>
</div>
</form>
</div>
<div class="apply_table">
<div class="apply_title">
<h1>Aplicatii</h1>
</div>
<table>
<thead>
<tr>
<th>Nickname</th>
<th>Nume real</th>
<th>Stare</th>
</tr>
</thead>
<tbody>
<?php while($row = mysqli_fetch_array($results, MYSQLI_ASSOC)) { ?>
<tr>
<td><a href="apply.php?view=<?php echo $row['id']; ?>"><?php echo $row['auth']; ?></a></td>
<td><?php echo $row['nume']; ?></td>
<td><?php echo $row['raspuns']; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<?php
} else { ?>
<div class="apply_view">
<div class="apply_title">
<h1>Aplicatia lui <?php echo $auth; ?></h1>
</div>
<table>
<thead><?php
echo '<tr><th>Nickname</th><td>' . $v_auth . '</td></tr>';
echo '<tr><th>Nume real</th><td>' . $v_nume . '</td></tr>';
echo '<tr><th>E-mail</th><td>' . $v_email . '</td></tr>';
echo '<tr><th>Varsta</th><td>' . $v_age . '</td></tr>';
echo '<tr><th>Ore jucate</th><td><a href="' . $v_ore . '" target="_blank">Ore jucate</a></td></tr>';
echo '<tr><th>Experienta</th><td>' . $v_exp . '</td>';
echo '<tr><th>Status</th><td>' . $v_status . '</td></tr>'; ?>
</thead>
</table>
<?php
if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) {
?>
<div class="apply_btn">
<?php
$auth = $_SESSION['auth'];
$sql2 = "SELECT type FROM admins WHERE auth='$auth'";
$result2 = mysqli_query($db, $sql2);
if (mysqli_num_rows($result2) > 0) {
// output data of each row
while($rowd = mysqli_fetch_assoc($result2)) {
if (($rowd['type'] == 'admin') === true) {
?>
<a href="apply.php?accept=<?php echo $v_id; ?>"><input type="submit" class="accept" value="Accepta"></a>
<a href="apply.php?reject=<?php echo $v_id; ?>"><input type="submit" class="reject" value="Respinge"></a>
<a href="apply.php?delete=<?php echo $v_id; ?>"><input type="submit" class="delete" value="Sterge"></a>
<?php } } } ?>
<a href="apply.php"><input type="submit" class="back" value="Inapoi"></a>
</div>
<?php } ?>
<div class="comments">
<div class="show_comm">
<?php include('errors.php'); ?>
<div class="comm_title">
<h4>Comentarii</h4>
</div>
<?php while($row2 = mysqli_fetch_array($commrow, MYSQLI_ASSOC)) { ?>
<div class="show_comment">
<p><font color="#49afcd"><?php echo $row2['authComm']; ?></font></p><br>
<p><?php echo $row2['comment']; ?></p>
</div>
<?php } ?>
<div class="comments_txt">
<textarea placeholder="Adauga un comentariu..." name="comments"></textarea><br>
<input type="submit" name="comment" class="comment" value="Comenteaza">
</div>
</div>
</div>
</div>
<?php } ?>
<?php } else { header('Location: login.php'); } include'includes/overall/footer.php'; ?>
Iar comentariile sa apara astfel:
Codul este facut de mine, si cred ca am gresit prin baza de date unde am inserat comentariile.. (ma gandesc cum sa repar, dar aici chiar nu stiu ce solutie sa preiau sa nu imi dea eroare..)