PHP Conditional Syntax Help If/Else?

Question

I need the proper php syntax to handle a situation with my website's breadcrum links for product pages. All of my items are derived from a MySQL database.

The inventory items are organized either by itemCategory or itemAuthor. Not all items have an itemCategory associated with them so in the database they are NULL. All items however, have an itemAuthor.

What I basically want to say is:

If the item has a value for itemCategory, echo the itemCategory. If itemCategory is NULL, echo itemAuthor instead.

Thanks for any help.

echo !is_null($row['itemCategory']) ? $row['itemCategory'] : $row['itemAuthor'];? — gen_Eric
– gen_Eric, Commented Dec 14, 2011 at 19:47

Mob · Accepted Answer · 2011-12-14 19:50:51Z

3

if(empty($itemCategory)) {
  echo $itemAuthor;
} else {
  echo $itemCategory;
}

edited Dec 14, 2011 at 19:50

Mob

11.1k7 gold badges43 silver badges58 bronze badges

answered Dec 14, 2011 at 19:46

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

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

1 Comment

ceejayoz Over a year ago

I'm a little baffled that you're managing breadcrumbs and MySQL access but not if/else statements...

Michas · Accepted Answer · 2011-12-14 20:54:37Z

0

The mysql solution:

SELECT ...
    IFNULL(`itemCategory`, `itemAuthor`) AS `itemCategory`
FROM ...

In PHP You just echo itemCategory. No additional conditions. If it was NULL id database, it will be itemAuthor in PHP.

The php solution:

if ($r['itemCategory']):
    echo $r['itemCategory'];
else:
    echo $r['itemAuthor'];
endif;

The NULL is returned as empty string. It is converted to php false in if expressions.

answered Dec 14, 2011 at 20:54

Michas

9,5966 gold badges41 silver badges64 bronze badges

Collectives™ on Stack Overflow

PHP Conditional Syntax Help If/Else?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related