PHP changing html element class from SQL variable

Question

Background

Here is the following code which will select four fields from a MySQL table called a_aif
I want to present this data in an html table and highlight the row background where the a_aif.aif_id is equal to remaining_if.aif_id
I have defined a variable in the SQL query that satisfies this condition above and defined it remaining_aifs

Issues - Please see the red arrows/highlighted syntax for where I think the problem lies...

enter image description here

PHP Script

<?php
require_once 'config.php';

$dbh = new PDO($dsn, $dbuser, $dbpass);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

$result = $dbh->query("
    SELECT a_aif.aif_id,
      a_aif.fee_source_id,
      a_aif.company_name_per_sedar,
      a_aif.document_filing_date,
      IF (a_aif_remaining.aif_id IS NULL, 0, 1) remaining_aifs
    FROM  a_aif
      LEFT JOIN a_aif_remaining
        ON a_aif_remaining.aif_id = a_aif.aif_id
    ORDER BY aif_id DESC");

$result->setFetchMode(PDO::FETCH_ASSOC);

if ( !empty($result) ) : endif;

?>

<table>
<tr>
    <th><b>Document ID</b></th>
    <th><b>Pubco Name</b></th>
    <th><b>Filing Date</b></th>
    <th><b>PDF</b></th>
</tr>

<?php foreach($result as $index => $row) : ?>
<tr
    <?php
        if('a_aif.aif_id' === 'remaining_aifs'
        echo "<tr class='highlighted'>";
        else echo "<tr>";
    ?>
>
    <td><?php echo $row[fee_source_id]; ?></td>
    <td><?php echo $row[company_name_per_sedar]; ?></td>
    <td><?php echo $row[document_filing_date]; ?></td>
    <td></td>
</tr>
<?php endforeach;
$dbh = NULL;
?>
</table>

No. Are you even trying to run this yourself to see what happens? For starters, you're missing the ? in <?php and your code results in a parse error when run. — regulatethis
– regulatethis, Commented Jan 3, 2013 at 7:51
What are you actually trying to accomplish with this? Describe that and it might be easier to help you. — regulatethis
– regulatethis, Commented Jan 3, 2013 at 7:53
@regulatethis I've updated the question to include the context. Appreciate your help, been at this one for a while... little confusing for me. — Ben
– Ben, Commented Jan 3, 2013 at 8:16

regulatethis · Accepted Answer · 2013-01-03 17:37:50Z

1

1) empty() is a construct which returns true if the value you pass it is any of the following:

"" (an empty string)
0 (0 as an integer)
0.0 (0 as a float)
"0" (0 as a string)
NULL
FALSE
array() (an empty array)
$var; (a variable declared, but without a value)

2) $result is some value that is being passed in to empty(). No idea what it is set to since you didn't post any other code.

3) The : is an alternative syntax to define a block for the if statement. You'll need to end it with endif; at the end of your block.

This alternative syntax is very popular when using PHP mixed with HTML, typically in a template. Your code might look like this:

<?php if ( !empty($result) ) : ?>
   <span class="result"><?php echo $result; ?></span>
<?php endif; ?>

Note that what you put between the <?php if... and <?php endif; ?> lines can be anything, including more php code or html/text.

More info:

http://www.php.net/empty

http://www.php.net/manual/en/control-structures.alternative-syntax.php

edited Jan 3, 2013 at 17:37

answered Jan 3, 2013 at 7:18

regulatethis

2,36214 silver badges18 bronze badges

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

5 Comments

Ben Over a year ago

Thanks @regulatethis. Can you please expand on number 3? Do I still need to add endif; to this code block (assuming no "else" portion to the If Statement)? - Please note, I have updated the question to reflect this deeper investigation. Thanks

regulatethis Over a year ago

@BenJones You should always close your if statements explicitly, if you want to write maintainable code.

KingCrunch Over a year ago

empty() is not a function, but a language construct. At least with 5.5 this shouldn't make a huge difference anymore, but before the main difference to regular function is, that empty() only accepts variables (not empty('') or empty(doSomething())) Just said :)

regulatethis Over a year ago

@KingCrunch empty() supports expressions since PHP 5.5 so I didn't think mentioning that was particularly necessary or helpful.

KingCrunch Over a year ago

@regulatethis 5.5 isn't released yet ;) So it's obviously necessary to mention, that it wont work in regular installations and especially in every stable production environment

Jakub Sacha · Accepted Answer · 2013-01-03 07:16:11Z

0

this is alternate syntax of "if statement"

you can use

<?php 
if ($condition):
//some code
else:
// some code
endif;
?>

so in your example 1 and 2 are condition which is passed if result is not empty

answered Jan 3, 2013 at 7:16

Jakub Sacha

912 bronze badges

Comments

Surinder ツ · Accepted Answer · 2013-01-03 07:35:38Z

0

An array looks like:

$result= array(); // array defined

$result= ["name","last name"]; // array elements

$result= []; // empty array

If Syntax :

    <?php if ( !empty($result) ) : ?>
       hello control in if 
    <?php else: ?>
       in else condition
    <?php endif; ?>

where empty(); is a php function to check $result has no elements or have elements.

: is a syntax element.

answered Jan 3, 2013 at 7:35

Surinder ツ

1,7883 gold badges17 silver badges27 bronze badges

Collectives™ on Stack Overflow

PHP changing html element class from SQL variable

Background

PHP Script

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Background

PHP Script

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related