<div class = "accept_user">
<div class = "eventos">
<div id="users">
<?php
include "./src/php/basedatos/bdhandler.php";
include "./src/php/basedatos/usershandler.php";
include "./src/php/basedatos/pymeshandler.php";
$db = new bdhandler("localhost", "diu", "root", "");
$pyme = new Pyme();
$user = new Usuario();
if (isset($_POST['admit'])) {
$var = $_POST['user'];
$db->connection->query("UPDATE pertenecer SET puesto = 'aceptado'\n WHERE user1 = '" . $var . "'");
$db->connection->query("UPDATE usuarios SET estado = true\n WHERE user = '******'");
} else {
if (isset($_POST['delete'])) {
$var = $_POST['user'];
$db->connection->query("UPDATE pertenecer SET puesto = NULL\n WHERE user1 = '" . $var . "'");
$db->connection->query("UPDATE usuarios SET estado = false\n WHERE user = '******'");
}
}
$query = $db->connection->query("SELECT * FROM pertenecer WHERE user2 = '" . $_SESSION['empresa'][0] . "'");
while ($aux = $query->fetch_assoc()) {
$query2 = $db->connection->query("SELECT * FROM usuarios WHERE user = '******'");
$result = $query2->fetch_assoc();
$user->get_user($result);
$user->show_user();
if ($aux["puesto"] == NULL) {
echo "\n <form id ='boton_gestion_user' method='POST'>\n <input id='texto' type='text' name='user' value='" . $aux["user1"] . "'>\n <button type='submit' id='boton' name='admit'> ADMITIR </button>\n </form>";
} else {
echo "\n <form id ='boton_gestion_user' method='POST'>\n <input id='texto' type='text' name='user' value='" . $aux["user1"] . "'>\n <button type='submit' id='boton' name='delete'> ELIMINAR </button>\n </form>";
<div class = "eventos">
<div id="noticias">
<?php
include "./src/php/basedatos/bdhandler.php";
include "./src/php/basedatos/noticiahandler.php";
$bd = new bdhandler("localhost", "diu", "root", "");
$consulta = $bd->connection->query("SELECT * FROM pertenecer WHERE user1 = '" . $_SESSION['user'][0] . "'");
$resultado = $consulta->fetch_assoc();
$consulta = $bd->connection->query("SELECT * FROM noticia WHERE empresa = '" . $resultado["user2"] . "'");
$noticia = new Noticia();
while ($row = $consulta->fetch_assoc()) {
$noticia->get_noticia($row);
$noticia->show_noticia();
}
$bd->close();
?>
</div>
</div>
