Using php inside a heredoc

slightlyeskew

Hey all!

So I'm trying to use a line of php inside a heredoc statement. Here is an excerpt:

<?php
//assume proper db connection

$submitted_id_to_edit = x;
$A = $db->query("SELECT First_Name FROM ShareholderID = '$submitted_id_to_edit'");

print<<<_HTML_
First Name:<input type=text name="shareholder_first_name" value=<?php $A;?>>
_HTML_

?>

What's the problem here?

I also tried this which didn't compile either:

<?php
//assume proper db connection
$A = $db->query("SELECT First_Name FROM ShareholderID = '$submitted_id_to_edit'");

echo "First Name:<input type=text name=shareholder_first_name value="$A echo">";
?>

Neither one of them worked and I'd really appreciate any help you guys can offer. Thanks so much for your time.

slightlyeskew

edited

halojoy

Try:

<?php
//assume proper db connection

$submitted_id_to_edit = x;
$a = $db->query("SELECT First_Name FROM ShareholderID = '$submitted_id_to_edit'"); 

echo <<<_HTML_
First Name: <input type=text name="shareholder_first_name" value="$a">
_HTML_;

?>

Inside heredoc you can use variables as they are. No need to echo.
I needed one semicolon after HTML;

halojoy

you have to fetch result.
$A, result, is not a string.

$db->fetch or something like this is what to use

<?php
//assume proper db connection

$submitted_id_to_edit = x;
$result = $db->query("SELECT First_Name FROM ShareholderID = '$submitted_id_to_edit'");

$row = $db->fetch_array( $result ); // Maybe ...  $db->fetch($result);
$name = $row['First_Name'];

echo <<<_HTML_
First Name: <input type=text name="shareholder_first_name" value="$name">
_HTML_;

?>

slightlyeskew

Thanks so much for the quick response Halo. I'm a little out of practice with php and forgetting the little things 🙂

halojoy

Thanks.

Maybe you can find the correct way, syntax, how to fetch.
I do not know what database script you are using

This is more close, I think:

$result = $db->query("SELECT First_Name FROM ShareholderID = '$submitted_id_to_edit'"); 

$row = $result->fetch();
$name = $row['First_Name'];