<?php
$servername = "xxxxxxxxx";
$username = "xxxxxxx";
$password = "xxxxxxxx";
$dbname = "xxxxxx";
$conn = new mysqli($servername, $username, $password, $dbname);
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$sql = "SELECT ID, Produto FROM Registo";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "ID: " . $row["ID"]. " - Name: " . $row["Produto"]. "<br>";
}
} else {
echo "0 results";
}
mysqli_close($conn);
?>