<!DOCTYPE html>
<html lang="en" class="bg-pink">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Alumnos</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<?php
// Te recomiendo utilizar esta conección, la que utilizas ya no es la recomendada.
$link = new PDO('mysql:host=localhost;dbname=iasms', 'root', ''); // el campo vaciío es para la password.
?>
<div id="main_content">
<div class="container-fluid">
<div class = "panel">
<div class = "panel-heading phead">
<h2 class = "panel-title ptitle"> Lista de estudiantes</h2>
</div>
<div class = "panel-body pbody">
<form method="post" action="">
<div class="container">
<div class="row">
<div class="col-xs-5 col-xs-offset-6">
<div class="input-group">
</div>
</div>
</div>
</div>
<br>
<table class="table table-bordered table-hover">
<thead>
<tr>
<th>id</th>
<th>nombre</th>
<th>apellidos</th>
<th>codigo</th>
<th>contraseñs</th>
</tr>
</thead>
<?php foreach ($link->query('SELECT * from registered_students') as $row){ // aca puedes hacer la consulta e iterarla con each. ?>
<tr>
<td><?php echo $row['id'] // aca te faltaba poner los echo para que se muestre el valor de la variable. ?></td>
<td><?php echo $row['first_name'] ?></td>
<td><?php echo $row['last_name'] ?></td>
<td><?php echo $row['index_number'] ?></td>
<td><?php echo $row['password'] ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
Comentarios sobre la versión: Versión 1.0 (0)
No hay comentarios