<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>