www.wysiwygwebbuilder.com

Code: Select all

<?php
echo "DB Test";
// Database connection details
$servername = "";
$username = " ";
$password = "";
$dbname = "";
echo "DB Test connecting";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
echo "DB Test done";
echo $conn;
// Check connection
if ($conn->connect_error) {
   
    die("Connection failed: " . $conn->connect_error);
}
echo "<p>2ID: "  . " - title: " .   "</p>";
// Write a SQL query to select data from a table
$sql = "SELECT id, title FROM filedownloads";
$result = $conn->query($sql);

// Iterate through the result set and display data
if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<p>ID: " . $row["id"] . " - title: " . $row["title"] . "</p>";
    }
} else {
    echo "0 results";
}

// Close the connection
$conn->close();
?>