PHP
PHP

PHP code IF

This code causes my page to be blank
The correct SQL statements and database connections are in place:

----------------------------------------------------

<?php if ($row_unpaid['Paid'] == "Paid") {
echo <td colspan="12" align="center" class="body_bold_black"><a name="paid" id="paid"></a>Invoice Database (paid)</td>; } ?>

<?php if ($row_unpaid['Paid'] == "Pending") {
echo <td colspan="12" align="center" class="body_bold_black"><a name="unpaid" id="unpaid"></a>Invoice Database (Unpaid)</td>; } ?>

----------------------------------------------------

doctorbillTechAsked: 2015-07-31

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 65

Julian HansenCommented: 2015-07-31

Is it an error that is causing the problem or the fact that neither of those if statements are firing?
What happens when you dump the $row_unpaid variable like so

<?php 
echo '<pre>' . print_r($row_unpaid, true) . '</pre>';
if ($row_unpaid['Paid'] == "Paid") {
                    echo <td colspan="12" align="center" class="body_bold_black"><a name="paid" id="paid"></a>Invoice Database (paid)</td>;  } ?>

 <?php if ($row_unpaid['Paid'] == "Pending") {
                    echo <td colspan="12" align="center" class="body_bold_black"><a name="unpaid" id="unpaid"></a>Invoice Database (Unpaid)</td>; } ?>

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

doctorbillTechAuthor Commented: 2015-07-31

No error
The page is just blank

doctorbillTechAuthor Commented: 2015-07-31

If I run your statement the page is still blank

LVL 111

Ray PaseurCommented: 2015-07-31

"The page is blank" is a symptom of a PHP error that occurred when error_reporting() was set to suppress error messages. PHP failed, it had some information for you, but there was no way to get the information to you. Here are some good settings for figuring out what is going wrong in your script:

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);

Open in new window

You might try adding those statements to the top of your PHP scripts. You might look for an error_log file. You can find its name by looking at the browser output of the phpinfo() function.

doctorbillTechAuthor Commented: 2015-07-31

I get this:

Notice: Undefined variable: details in C:\xampp\htdocs\TickTock_int\invoiceDatabase_pending.php on line 470

doctorbillTechAuthor Commented: 2015-07-31

Thanks Ray - this has sorted it for me
I did not have a variable correctly referenced

LVL 84

Dave BaldwinFixer of ProblemsCommented: 2015-07-31

At the very least, the text for the 'echo' statements needs to be quoted Since double quotes are part of the string, I used single quotes around the whole string.

<?php if ($row_unpaid['Paid'] == "Paid") {
                    echo '<td colspan="12" align="center" class="body_bold_black"><a name="paid" id="paid"></a>Invoice Database (paid)</td>';  } ?>

 <?php if ($row_unpaid['Paid'] == "Pending") {
                    echo '<td colspan="12" align="center" class="body_bold_black"><a name="unpaid" id="unpaid"></a>Invoice Database (Unpaid)</td>'; } ?>

Open in new window

doctorbillTechAuthor Commented: 2015-07-31

This is now working:
------------------------------------------------------
$heading = 'Invoice Database (Unpaid)';
$paidheading = 'Invoice Database (paid)';

<td colspan="12" align="center" class="body_bold_black"><a name="unpaid" id="unpaid"></a>
<?php if ($row_Unpaid['Paid'] == "Paid") {
echo $heading; } ?>
<?php if ($row_Unpaid['Paid'] == "Pending") {
echo $paidheading; } ?></td>

LVL 111

Ray PaseurCommented: 2015-08-01

On how to use quotes correctly in PHP:
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_12241-Quotation-Marks-in-PHP.html

Glad you've got it pointed in the right direction! :-)