How to use isset condition for mysql query output

Question

I get some data from MySQL, and I print the data as echo $row['ref'];.

Sometimes echo $row['ref']; returns empty result. I want to compose a condition like echo isset($row['ref']) ? $row['ref']:'Unknown'; which will show Unknown word if echo $row['ref']; returns empty result.

Thanks in advance.

use empty instead of isset the php function empty will check if the variable exist and is not empty — Beginner
– Beginner, Commented Dec 18, 2016 at 9:28

Beginner · Accepted Answer · 2016-12-18 09:38:45Z

1

As you mention in your scenario which

isset($row['ref']) ? $row['ref']:'UnKnown';

you stated that you receive an empty value even you use isset which mean $row['ref'] exist but it is empty

use empty instead of isset the php function empty will check if the variable exist and is not empty

This will prevent you from having an empty value for your variable $ref

$ref= (!empty($row["ref"])) ?$row["ref"]: "UnKnown";

Demo

edited Dec 18, 2016 at 9:38

answered Dec 18, 2016 at 9:31

Beginner

4,1183 gold badges19 silver badges27 bronze badges

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

Comments

Michiel van Alphen · Accepted Answer · 2016-12-18 09:50:37Z

1

Perhaps 'ref' is present as an array key but has null as value.

<?php $row = array('ref' => null); echo (!empty($row['ref'])) ? $row['ref'] : 'UnKnown'; ?>

edited Dec 18, 2016 at 9:50

answered Dec 18, 2016 at 9:16

Michiel van Alphen

614 bronze badges

2 Comments

SOFe Over a year ago

?? is only for non-null. It does not do what empty() does.

Beginner Over a year ago

the empty function alone is enough

Hikmat Sijapati · Accepted Answer · 2016-12-18 09:22:54Z

0

Try ternary operator like this......

$ref= $row["ref"] ?$row["ref"]: "UnKnown";
echo $ref;

answered Dec 18, 2016 at 9:22

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

Comments

Panda · Accepted Answer · 2017-09-21 11:10:03Z

0

If isset doesn't work, it might be that mysqli returns the result as an empty string.

You may want to use the ?: operator for quick if-false fallback:

echo $row["ref"] ?: "UnKnown";

See: How do I use shorthand if / else?

edited Sep 21, 2017 at 11:10

Panda

6,8846 gold badges46 silver badges61 bronze badges

answered Dec 18, 2016 at 9:21

SOFe

8,3065 gold badges37 silver badges67 bronze badges

Collectives™ on Stack Overflow

How to use isset condition for mysql query output

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related