<!DOCTYPE html>
<html lang="en">
<head>
<title>Articulos</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="
https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <script src="
https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>
<script src="
https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<?php
function conectar(){
$con=mysqli_connect("localhost","root","","dam2d");
return $con;
}
function desconectar(){
mysqli_close(conectar());
}
if(conectar()->connect_error){
die('Error de conexion: '.conectar()->connect_error);
}else{
$sql="SELECT * FROM articulos";
$resul=mysqli_query(conectar(),$sql); Lo que haces en esa linea es conectar a la base de datos y devolver el handler, cada query que hagas conectaras de nuevo a la base de datos?.
Para ésto, si quieres una función para conectar, podría ser algo tal que así $con = null;
function conectar(){
global $con;
$con=mysqli_connect("localhost","root","","dam2d");
}
function desconectar(){
global $con;
mysqli_close($con);
}
echo "<table class='table' border='1'>";
while($linea=mysqli_fetch_array($resul)){
echo "<tr><td colspan='6' align='center'><b>ARTICULOS</b></td></tr>";
echo "<tr><th>ID</th><th>Nombre</th><th>Precio</th><th>Fecha Alta</th><th>Acciones</th></tr>";
echo "<tr>";
echo "<td>",$linea['id'],"</td>";
echo "<td>",$linea['nombre'],"</td>";
echo "<td>",$linea['precio'],"</td>";
echo "<td>",$linea['fechaalta'],"</td>";
$id=$linea['id'];
//echo $id;?>
<form action='editar.php' method='post'>
<input type='hidden' name='id' value='<?php $id ?>'>
<?php
echo "<td><a class='btn btn-warning' href='editar.php?id=".$id."'>EDITAR</a>"." ";
echo "<a class='btn btn-danger' href='eliminar.php?id='".$id."''>ELIMINAR</a></td>";
echo "</form>";
echo "</tr>";
}
}
desconectar();
?>
</body>
</html>
Mostrar Mensajes
