connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// SQL query to retrieve data
$sql = "SELECT * FROM your_table_name"; // Replace 'your_table_name' with the actual table name
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Output data of each row
while ($row = $result->fetch_assoc()) {
echo "Column1: " . $row["column1_name"] . " - Column2: " . $row["column2_name"] . "
"; // Replace 'column1_name', 'column2_name' with actual column names } } else { echo "0 results"; } // Close connection $conn->close(); ?>
"; // Replace 'column1_name', 'column2_name' with actual column names } } else { echo "0 results"; } // Close connection $conn->close(); ?>
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// SQL query to retrieve data
$sql = "SELECT * FROM your_table_name"; // Replace 'your_table_name' with the actual table name
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Output data of each row
while ($row = $result->fetch_assoc()) {
echo "Column1: " . $row["column1_name"] . " - Column2: " . $row["column2_name"] . "
"; // Replace 'column1_name', 'column2_name' with actual column names } } else { echo "0 results"; } // Close connection $conn->close(); ?>
"; // Replace 'column1_name', 'column2_name' with actual column names } } else { echo "0 results"; } // Close connection $conn->close(); ?>