How to echo variable depending on specific field in table?

Question

Here's a very simplified example of what I am trying to achieve :

GIFT
sender  |  type
phil    |  1
phil    |  2

Here, 1 = cake and 2 = muffin.

$table = query("SELECT sender, type FROM users WHERE sender = Phil");
foreach ($table as $row) {
$sender = $row['sender'];
$type = $row['type'];

echo '$sender has bought a $type';
}

This will output :

Phil has bought a 1
Phil has bought a 2

How can I get the below output instead ?

Phil has bought a cake
Phil has bought a muffin

Should I use an array ?

 $type = array(
 1 => 'cake',
 2 => 'muffin'
 );

The problem is $type is already defined as $row['type'].

Barmar · Accepted Answer · 2013-08-25 02:34:50Z

1

Use an associative array that relates numbers to names:

$types = array(1 => 'cake', 2 => 'muffin');

Then use it as:

echo "$sender has bought a {$types[$type]}";

Note that you must use doublequotes for variables to be expanded inside the string, not singlequotes as in your code.

answered Aug 25, 2013 at 2:34

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Comments

vee · Accepted Answer · 2013-08-25 02:41:33Z

1

Or if you'd like to return this from database:

$table = query("SELECT sender, 
                case when type = '1' then 'cake' 
                     when type = '2' then 'muffin'
                end as type 
                FROM users WHERE sender = Phil");

foreach ($table as $row) {
  $sender = $row['sender'];
  $type = $row['type'];

  echo "$sender has bought a $type"; //Use double quotes for $sender and $type to be interpolated.
}

answered Aug 25, 2013 at 2:41

vee

38.7k7 gold badges76 silver badges80 bronze badges

Comments

Nick Coons · Accepted Answer · 2013-08-25 02:34:11Z

0

Given your example, I would use an array like this:

$items = array(
    "1" => "cake",
    "2" => "muffin"
);

Then do this:

echo "$sender has bought a {$items[$type]}";

answered Aug 25, 2013 at 2:34

Nick Coons

3,6921 gold badge21 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to echo variable depending on specific field in table?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related