#Detalle de empleados
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Dashboard</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
<?php include('config.php'); ?
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
<style type="text/css">
.wrapper{ width: 650px;
margin: 0 auto;
}
.page-header h2{ margin-top: 0;
}
table tr td:last-child a{ margin-right: 15px;
}
</style>
<script type="text/javascript">
$(document).ready(function(){ $('[data-toggle="tooltip"]').tooltip(); });
</script>
</head>
<body>
<div class="wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<div class="page-header clearfix">
<h2 class="pull-left">Detalle de Empleados</h2>
<a href="create.php" class="btn btn-success pull-right">Agregar nuevo empleado</a>
<a href="ordenasc.php" class="btn btn-success pull-right">Ordenar Nombre Ascendente </a>
<a href="http://pc/sistem/menu.php" class="btn btn-success pull-right">Salir</a>
//<a href="search-form.php"class="btn btn-success pull//-righ">Buscar Nombre</a>
<a href="filterdatabase.php"class="btn btn-success pull-righ">Buscar Nombre database</a>
<script>
$(document).ready(function(){ $("#myInput").on("keyup", function() { var value = $(this).val().toLowerCase();
$("filterdatabase.php").filter(function() { $(this).toggle($(this).text().toLowerCase().indexOf(value) > -1)
});
});
});
</script>
<!--- Search form --->
<div class="md-form mt-0">
<div class="form-control">
<input class="filterdatabase.php" type="text" placeholder="Search" aria-label="Search">
</div>
<?php
// Include config file
require_once "config.php";
// Attempt select query execution
$sql = "SELECT * FROM employees";
if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table class='table table-bordered table-striped'>";
echo "<thead>";
echo "<tr>";
echo "<th>#</th>";
echo "<th>Name</th>";
echo "<th>Address</th>";
echo "<th>Salary</th>";
echo "<th>Action</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>";
while($row = mysqli_fetch_array($result)){ echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['address'] . "</td>";
echo "<td>" . $row['salary'] . "</td>";
echo "<td>";
echo "<a href='read.php?id=". $row['id'] ."' title='View Record' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'></span></a>";
echo "<a href='update.php?id=". $row['id'] ."' title='Update Record' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
echo "<a href='delete.php?id=". $row['id'] ."' title='Delete Record' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";
echo "</td>";
echo "</tr>";
}
echo "</tbody>";
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{ echo "<p class='lead'><em>No records were found.</em></p>";
}
} else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
</div>
</div>
</div>
</div>
</body>
</html>
