<div class="marco_perfil">
<?php
include "./src/php/basedatos/bdhandler.php";
$db = new bdhandler("localhost", "diu", "root", "");
if (isset($_SESSION['user'])) {
include "./src/php/basedatos/usershandler.php";
$query = $db->connection->query("SELECT * FROM usuarios WHERE user = '******'user'][0] . "'");
$user = new Usuario();
$user->get_user($query->fetch_assoc());
$user->show_profile();
} else {
if (isset($_SESSION['empresa'])) {
include "./src/php/basedatos/pymeshandler.php";
$query = $db->connection->query("SELECT * FROM empresas WHERE user = '******'empresa'][0] . "'");
$pyme = new Pyme();
$pyme->get_pyme($query->fetch_assoc());
$pyme->show_profile();
} else {
include "./src/php/basedatos/usershandler.php";
$query = $db->connection->query("SELECT * FROM usuarios WHERE user = '******'admin'][0] . "'");
$user = new Usuario();
$user->get_user($query->fetch_assoc());
$user->show_profile();
}
}
$db->close();
?>
</div>
<a href="index.php?contenido=modificar"><div id="logout">MODIFICAR PERFIL</div></a>
$var3 = "empresas";
$var4 = 'empresa';
} else {
$var = "NUEVOS APELLIDOS";
$var2 = "apellidos";
$var3 = "usuarios";
$var4 = 'user';
}
if (isset($_POST['aceptar'])) {
include "./src/php/basedatos/bdhandler.php";
include "./src/php/basedatos/usershandler.php";
include "./src/php/basedatos/pymeshandler.php";
$db = new bdhandler("localhost", "diu", "root", "");
$query = $db->connection->query("SELECT * FROM " . $var3 . " WHERE user = '******'");
if (isset($_SESSION['empresa'])) {
$user = new Pyme();
$user->get_pyme($query->fetch_assoc());
} else {
$user = new Usuario();
$user->get_user($query->fetch_assoc());
}
// Carga de nuevos datos
if ($user->check_password($_POST['pass'])) {
if ($_POST['nombre'] != "") {
$nombre = $_POST['nombre'];
} else {
$nombre = $user->nombre;
}
if ($_POST[$var2] != "") {
$apellidos = $_POST[$var2];
} else {
<div class = "empresas_select">
<h1>SELECCIONE UNA EMPRESA:</h1>
<?php
include "./src/php/basedatos/pymeshandler.php";
$pyme = new Pyme();
if (isset($_POST['submit'])) {
$query = $db->connection->query("SELECT * FROM empresas WHERE user = '******'Pyme'] . "'");
$pyme->get_pyme($query->fetch_assoc());
$db->connection->query("INSERT INTO pertenecer( user1, user2 )\n\t\t\t\t\t\t\t\t\t\t\tVALUES( '" . $user->user . "', '" . $pyme->user . "' )\n\t\t\t\n\t\t\t\n\t\t\t");
header("location:index.php?contenido=miempresa");
}
$query = $db->connection->query("SELECT * FROM empresas");
echo '<form method="post">
<select name="Pyme">
';
while ($row = $query->fetch_assoc()) {
$pyme->get_pyme($row);
echo '<option value="' . $pyme->user . '">' . $pyme->nombre . '</option>';
}
echo ' </select>
<br><br>
<input type="submit" name="submit">
</form>';
?>
</div>
<div class="banner_empresa">
<a>Empresas</a>
</div>
<div class ="marco_empresa">
<?php
include "./src/php/basedatos/bdhandler.php";
include "./src/php/basedatos/pymeshandler.php";
$pyme1 = new Pyme();
$pyme2 = new Pyme();
$db = new bdhandler("localhost", "diu", "root", "");
$query = $db->connection->query("SELECT * FROM empresas");
$cont = 2;
for ($i = 1; $i < 6; $i += 2, $cont += 2) {
$pyme1->get_pyme($query->fetch_assoc());
$pyme2->get_pyme($query->fetch_assoc());
if ($i % 3 == 0) {
$width1 = "350px";
$width2 = "400px";
} else {
$width1 = "400px";
$width2 = "350px";
}
echo "\t<img id='foto_izquierda' height = '220px' width = '" . $width1 . "' src ='./assets/img/" . $pyme1->foto . "'>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div id = 'desc_empresa_" . $i . "'> " . $pyme1->nombre . " </div>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<img id='foto_derecha' height = '220px' width = '" . $width2 . "' src ='./assets/img/" . $pyme2->foto . "'>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<div id = 'desc_empresa_" . $cont . "'> " . $pyme2->nombre . " </div>\n\t\t\t\t\t\t\n\t\t\t\t\t";
}
?>
</div>
