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(); ?>
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(); ?>