<!DOCTYPE html>

<html>

<body>

<?php

$servername = "localhost";

$username = "asciorg_operator";

$password = "somajiguda82";

$dbname = "asciorg_ascinew2017";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}

$sql = "SELECT prog_name, prog_director FROM prog";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

   

    while($row = $result->fetch_assoc()) {

        echo "<br> id: ". $row["prog_name"]. " - Name: ". $row["prog_director"]. " " . "<br>";

    }

} else {

    echo "0 results";

}

$conn->close();

?>

</body>

</html>

Creampie