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

Question

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

MuthaFury · Accepted Answer · 2016-08-23 09:16:35Z

2

You can use Janno answer or you may use this (by changing " to ':-

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;'>";

answered Aug 23, 2016 at 9:16

MuthaFury

8051 gold badge7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Janno Over a year ago

Yes, single-quotes between doublequotes or vice versa works too. Could've added this as a comment instead of a separate answer tho.

MuthaFury Over a year ago

@Janno hehe, kinda lazy to write as comment, so I write it as answer, let him/her choose :D

Janno · Accepted Answer · 2016-08-23 09:14:03Z

1

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.

answered Aug 23, 2016 at 9:14

Janno

5324 silver badges16 bronze badges

1 Comment

LeifHorseslayer Over a year ago

Thank you for your help!

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related