booleans with PHP

Question

Dup of http://stackoverflow.com/questions/330709/some-basic-php-questions#330829

Hello,

I have a heap of tinyint fields in a mysql database I need to show with PHP. At the moment I am doing something like this:

if ($row['PAYPAL_ACCEPT'] == "1"){

$paypal = "Yes";

else

$paypal = "No";

}

For each field, which is tedious and seems like there should be a better way, than using an if clause for each field. If there is, what is it?

Answer 1

Try if you want:

$paypal = $row['PAYPAL_ACCEPT'] ? 'YES' : 'NO';

Answer 2

Something like

$paypal = ($row['PAYPAL_ACCEPT'] ? "Yes" : "No");

maybe?

Answer 3

You could write it shorter like:

$paypal = ($row['PAYPAL_ACCEPT']?'Yes':'No');

Answer 4

or you can use not tinyint but enum with values 'Yes' and 'No', then simple output field

$paypal = $row['PAYPAL_ACCEPT'];

Answer 5

Building on what's already been suggested:

// $columns = string array of column names
// $columns = array('PAYPAL_ACCEPT' ... );
foreach($columns as $column) {
  $$column = $row[$column] ? 'YES' : 'NO';
}

then you can access variables using the column names as variable names:

print $PAYPAL_ACCEPT;