Menu
Community /Pin to ProfileBookmark
@NogDogJun 01.2011 — #I do not believe you can do that, just as you cannot call a function within a double-quoted string (you have to concatenate, instead). A couple alternatives are:
...or...
@NogDogJun 01.2011 — #Something like this?
@NogDogJun 02.2011 — #I don't know if this helps any or if we're each visualizing something else, but there's no reason to echo chunks of static HTML within PHP. Only go into PHP mode when you need to output something that is [i]not[/i] static.
@NogDogJun 02.2011 — #
mysql_fetch_assoc() returns an array of values for one result row, where the array keys will be the names of the fields (columns) that were selected (i.e.: it's an [b]assoc[/b]iative array). So when we build the $status array, we're using the value of the "room" column ($row['room']) as the array key for $status while the value will be the phrase determined by whether or not $row['status'] is 1 or not (via the ternary "? :" operator).
It may get a little confusing when you first look at it to realize that we're using an array variable as the key for another array:
@NogDogJun 03.2011 — #I'd probably go with a switch() then, rather than a trying to do a one-liner.
Now, what I might [I]really[/I] do is create a separate table in the DB that contains those status words, and add a JOIN to the original query to grab that word based on the status value, and avoid all this stuff. ?
call a function from inside heredoc?
Hi,
i have this code
[code=php]$fn = ‘testfunction’;
function testfunction($argument) { whatever; }
$string = <<< heredoc
plain text and now a function: {$fn(‘someargument’)}
heredoc;
as far as i know, that should make it but it wont work, i get the following error:
[QUOTE]
Parse error: syntax error, unexpected ‘(‘, expecting ‘}’ in /home3/tokyoint/public_html/asakusa.htm on line 82
why is that? what am i doing wrong? its possible to have a function executed inside heredoc, isnt?
Thank you.
Sign in
to post a comment11 Comments(s) ↴
0
@NogDogJun 01.2011 — #I do not believe you can do that, just as you cannot call a function within a double-quoted string (you have to concatenate, instead). A couple alternatives are:[code=php]
$result = testfunction('someargument');
$string = <<<EOD
plain text and now a function result: $result
some more text
EOD;
[/code]...or...
[code=php]
$string = sprintf(<<<EOD
plain text and now a function result: %s
some more text
EOD
,
testfunction('someargument')
);
[/code]0
@NogDogJun 01.2011 — #Something like this?[code=php]
<?php
function getStatusAll()
{
$status = array();
$query = mysql_query("SELECT room, status FROM rooms");
while ($row = mysql_fetch_assoc($query)) {
$status[$row['room']] = ($row['status'] == 1)
? "<B>Available!</B>"
: "occupied";
}
return $status;
}
$availability = getStatusAll();
foreach($availability as $room => $status) {
echo <<<EOD
Blah blah blah.
Room: $room
Blah blah blah
Availability: $status
Blah blah blah.
EOD;
}
[/code]0
@NogDogJun 02.2011 — #I don't know if this helps any or if we're each visualizing something else, but there's no reason to echo chunks of static HTML within PHP. Only go into PHP mode when you need to output something that is [i]not[/i] static.[code=php]
<?php
$status = array();
$query = mysql_query("SELECT room, status FROM rooms");
while ($row = mysql_fetch_assoc($query)) {
$status[$row['room']] = ($row['status'] == 1)
? "<B>Available!</B>"
: "occupied";
}
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head><title>Example</title></head>
<body>
<p>This is a bunch of static HTML text.</p>
<p>Now we're about to the point where we need the status for room #123.</p>
<p>The status for Room #123 is: <b><?php echo $status[123]; ?></b>.</p>
<p>This is a bunch of static HTML text.</p>
<p>Now we're about to the point where we need the status for room #456.</p>
<p>The status for Room #456 is: <b><?php echo $status[456]; ?></b>.</p>
<p>Okay, that's enough boring stuff for now.</p>
</body>
</html>
[/code]0
@NogDogJun 02.2011 — #I tested the code now and it works beautifully!! thank you! i just would like to ask you a few things so i can understand better how you did it. How does mysql_fetch_assoc work? as far as i understand, it associates the 2 fields, but i got lost after that.
$status[$row['room']] = ($row['status'] shouldnt mean that both values are the same? also, i didnt know you could use '?' to replace the 'if' statement and ':' to replace 'else'. That was very informative, i really appreciate it.[/QUOTE]
mysql_fetch_assoc() returns an array of values for one result row, where the array keys will be the names of the fields (columns) that were selected (i.e.: it's an [b]assoc[/b]iative array). So when we build the $status array, we're using the value of the "room" column ($row['room']) as the array key for $status while the value will be the phrase determined by whether or not $row['status'] is 1 or not (via the ternary "? :" operator).
It may get a little confusing when you first look at it to realize that we're using an array variable as the key for another array:
[code=php]
$row['room'] = 123;
$row['status'] = 1;
$status[$row['room']] = ($row['status'] == 1) ? 'Available' : 'Occupied';
[/code]...is in effect doing...[code=php]
$status[123] = 'Available';
[/code]0
@NogDogJun 03.2011 — #I'd probably go with a switch() then, rather than a trying to do a one-liner.[code=php]
while($row = mysql_fetch_assoc($result)) {
switch($row['status']) {
case 1:
$text = 'available';
break;
case 2:
$text = 'reserved';
break;
case 3:
$text = 'whatever';
break;
default:
$text = 'occupied';
}
$status[$row['room']] = $text;
}
[/code]Now, what I might [I]really[/I] do is create a separate table in the DB that contains those status words, and add a JOIN to the original query to grab that word based on the status value, and avoid all this stuff. ?