LeifHorseslayer LeifHorseslayer - 3 months ago 6
MySQL Question

How do I display different images using MySQL/PHP when database connected/not connected?

I'm new to PHP and MYSQL, and I have what I think is going to be a relatively easy question.

My objective is to show one image (a green flashing light) when the database is connected, and display another image (a red flashing light) when there is no database connection.

I imagine it should be a simple variation on this:

<?php
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>


But if I attempt to add an image to where it echos "Connected successfully" I receive an error.

I'm attempting to add the image like this:

<?php
$servername = "localhost";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("<img src="Red_Light.gif" style="width:10px;height:10px;"> " . $conn->connect_error);
}
echo "<img src="Green_Light.gif" style="width:10px;height:10px;">";
?>


I probably have the completely wrong syntax but any help is appreciated.

Many thanks,
Leif

Answer
if ($conn->connect_error) {
    die("<img src=\"Red_Light.gif\" style=\"width:10px;height:10px;\"> " . $conn->connect_error);
} 
echo "<img src=\"Green_Light.gif\" style=\"width:10px;height:10px;\">";

Whole problem seems to be related to not escaping the quote marks.