Array not being recognized in heredoc!

slightlyeskew

Hey all! So I'm trying to get my table to produce a row with elements from my arrays:


echo <<<_Summary_Report_
<table border="border">
<tr>
  <th>First Name</th>
  <th>Last Name</th>
  <th>Shareholder ID</th>
  <th>Currently Active Certificates</th>
  <th>Shares</th>
  <th>Current Value</th>
  <th>Current Share Price</th>
</tr>
_Summary_Report_;
$currentNumber = 0;
while($currentNumber < 1)
{
print<<<_HTML_While_
<tr>
<td></td>
<td></td>
<td></td>
<td>$getCertificate[0]</td>
<td>$getNumber[$currentNumber]</td>
<td>$totalvalue[$currentNumber]</td>
<td></td>
</tr>
_HTML_While_;
$currentNumber++;
}

So the $getCertificate[0] prints the appropriate value in the table, however both $getNumber[$currentNumber] and $totalvalue[$currentNumber] do not print a value in the table. Their cells remain blank.

As always, I welcome your suggestions and advice!😃

halojoy

Turn on your error_reporting() in the beginning of script.
This is something you should do, when coding!
You will get notice from PHP that are helpful.

you put this line at the top of your script:
error_reporting(E_ALL);

In this case, I am quite sure, those 2 arrays have no values to display.
If I give them values, your script will work:
$getNumber = array( 17,18);
$totalvalue= array( 20,21);

<?php

error_reporting(E_ALL); // DEBUGGING HELP

$getNumber = array( 17,18);
$totalvalue= array( 20,21);

echo <<<_Summary_Report_
<table border="border">
<tr>
  <th>First Name</th>
  <th>Last Name</th>
  <th>Shareholder ID</th>
  <th>Currently Active Certificates</th>
  <th>Shares</th>
  <th>Current Value</th>
  <th>Current Share Price</th>
</tr>
_Summary_Report_;
$currentNumber = 0;
while($currentNumber < 2)
{
echo <<<_HTML_While_
<tr>
<td></td>
<td></td>
<td></td>
<td>$getCertificate[0]</td>
<td>$getNumber[$currentNumber]</td>
<td>$totalvalue[$currentNumber]</td>
<td></td>
</tr>
_HTML_While_;
$currentNumber++;
}

slightlyeskew

As always halo thanks for the quick response. I edited a bit more out of the script than I probably should have, but both $getnumber and $totalvalue have values stored in them. They both display values when I do $getnumber[0] etc. The same problem occurred when I used $getCertificate[$currentNumber] instead of $getCertificate[0]. Do you have any other advice that I could try?

slightlyeskew

The last reply was posted from in bed on my iPhone. I figured I'd get up and move to the computer to copy paste more of the code so that the issue was clearer 🙂

<?php
$activeCertificate = $db->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = 1 ORDER BY Certificate_Creation_Date DESC");
		while($row = $activeCertificate->fetchRow(MDB2_FETCHMODE_ASSOC))
	{foreach($row as $key => $Certificate)
		{
		$getCertificate[$certificatecounter] = $Certificate;
		$certificatecounter++;						
		}
	}

//I have similar calls to the DB for the creation of the $getNumber and $totalValue arrays.

echo <<<_Summary_Report_
<table border="border">
<tr>
  <th>First Name</th>
  <th>Last Name</th>
  <th>Shareholder ID</th>
  <th>Currently Active Certificates</th>
  <th>Shares</th>
  <th>Current Value</th>
  <th>Current Share Price</th>
</tr>
_Summary_Report_;
while($currentNumber < 1)
//Should be <= $numberofentries
{
print<<<_HTML_While_
<tr>
<td>Blah</td>
<td></td>
<td></td>
<td>$getCertificate[0]</td>
<td>$getNumber[$currentNumber]</td>
<td>$totalvalue[$currentNumber]</td>
<td></td>
</tr>
_HTML_While_;
$currentNumber++;
}	
?>

And again, $getCertificate[$currentNumber] does not work, but it does display the value when I switch to $getCertificate[0].

Also, any pointers on how to make my call to the DB and subsequent assignment to the array prettier would be much appreciated. Thanks again!

halojoy

I have tested this code below which is similar like yours.
( echo is to prefer )

And this works at my server!
It displays those values: 17, 20 and 18,21

Now why dont you use my advice error_reporting(E_ALL);
will save you a lot of guessings .......

<?php

error_reporting(E_ALL); // DEBUGGING HELP

$getNumber = array( 17,18);
$totalvalue= array( 20,21);

echo <<<_Summary_Report_
<table border="border">
<tr>
  <th>First Name</th>
  <th>Last Name</th>
  <th>Shareholder ID</th>
  <th>Currently Active Certificates</th>
  <th>Shares</th>
  <th>Current Value</th>
  <th>Current Share Price</th>
</tr>
_Summary_Report_;

$currentNumber = 0;
while($currentNumber < 2)
{

echo <<<_HTML_While_
<tr>
<td></td>
<td></td>
<td></td>
<td>$getCertificate[0]</td>
<td>$getNumber[$currentNumber]</td>
<td>$totalvalue[$currentNumber]</td>
<td></td>
</tr>
_HTML_While_;

$currentNumber++;
}

halojoy

I think this will work

$activeCertificate = $db->query("SELECT Certificate_Number FROM StockCertificates WHERE ShareholderID = 1 ORDER BY Certificate_Creation_Date DESC");
$getCertificate = array();    

while($row = $activeCertificate->fetchRow(MDB2_FETCHMODE_ASSOC))
{
    $getCertificate[] = $row['Certificate_Number'];
}

johanafm

slightlyeskew;10937773 wrote:
And again, $getCertificate[$currentNumber] does not work, but it does display the value when I switch to $getCertificate[0].

Because you never defined $currentNumber. And had you followed halojoy's advice about turning on all error reporting, you would get E_NOTICE for undefined variable or undefined index.
The reason your work at all is that an undefined variable is evaluated as zero for purposes of integer operations, which means that

++$currentNumber;

Would do the following
1. E_NOTICE for undefined variable
2. substitute the nothingness with 0
3. add 1 and store result in $currentNumber (and now it is defined)

Had your loop been set to any number greater than 1, e.g. while($currentNumber < 2) your code would have worked for every iteration after the first one.

Also, why create a loop to run one iteration?