How can one display an icon and link it to a database in PHP?

To display an icon and link it to a database in PHP, you can use HTML code within your PHP file. You can create an anchor tag `<a>` with the icon image as its content and set the `href` attribute to a PHP file that connects to the database. Inside the PHP file, you can write the code to fetch data from the database and display it accordingly. 

&lt;!-- HTML code to display icon linked to database --&gt;
&lt;a href=&quot;database.php&quot;&gt;&lt;img src=&quot;icon.png&quot; alt=&quot;Database icon&quot;&gt;&lt;/a&gt;

&lt;?php
// database.php
// Connect to database and fetch data
$servername = &quot;localhost&quot;;
$username = &quot;username&quot;;
$password = &quot;password&quot;;
$dbname = &quot;database&quot;;

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

if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}

$sql = &quot;SELECT * FROM table&quot;;
$result = $conn-&gt;query($sql);

if ($result-&gt;num_rows &gt; 0) {
    while($row = $result-&gt;fetch_assoc()) {
        echo &quot;Data: &quot; . $row[&quot;column&quot;]. &quot;&lt;br&gt;&quot;;
    }
} else {
    echo &quot;0 results&quot;;
}

$conn-&gt;close();
?&gt;

Keywords

HTML CSS PHP MySQL database integration

Related Questions