bootstrap2014: Connection.html Final Aula

<?php

#http://localhost:8080/aula4/connection.php

define("host","localhost");

define("user","root");

define("password","usbw");

define("database","sistema");

$connect=mysqli_connect(host,user,password,database) or die(header("Location:Erroconnection.html"));

define("table","users");

#$table="passwords";

$sql="SELECT * FROM " . table." order by username";

$query=mysqli_query($connect,$sql) or die($sql);

#var_dump($query);

$total=mysqli_num_rows($query);

if($total>0){

// Há Registos

$fetch=mysqli_fetch_assoc($query);

}

<!DOCTYPE html>

<head>

<title>Document</title>

</head>

<body>

<?php do { ?>

<?php } while($fetch=mysqli_fetch_assoc($query)); ?>

</body>

</html>

bootstrap2014