Tech Row with no contents, how to remove in output?

[Publisher Bucks]

So I have a table that has a row of URLs in it, some of the rows do not have any data in them.

When outputting the data to a page, how can I make it so that the code where that url should appear dissapears from the page?

This is the code I'm using:

<strong><a href="<?php echo $One; ?>">One</a></strong> |
<strong><a href="<?php echo $Two; ?>">Two</a></strong> |
<strong><a href="<?php echo $Three; ?>">Three</a></strong> |
<strong><a href="<?php echo $Four; ?>">Four</a></strong></p>

One, Two, Three & Four are all links to our product on a specific online store, I'm thinking its something to do with either and "if" or an "echo" statement(?) but I cant seem to figure out the right code to get it working.

Basically, if the row for 'Two' has no data in it, how do i get it to just vanish from the 4 options?

So instead of:

One | Two | Three | Four

It shows:

One | Three | Four

The data calls are in an array at the top of the page if that helps any?

[NatalieK]

no, my bad, what i said was wrong from what i´d read...


bounce for you, good luck

[zerovic]

Hi,

You can put a simple IF before each row

<?php if($One) { ?> <strong><a href="<?php echo $One; ?>">One</a></strong> | <?php } ?>
<?php if($Two) { ?> <strong><a href="<?php echo $Two; ?>">Two</a></strong> | <?php } ?>
<?php if($Three) { ?> <strong><a href="<?php echo $Three; ?>">Three</a></strong> | <?php } ?>

etc

You can also use trim($var) and strlen($var) > 0 if there is a chance that your DB has rows with only spaces by mistake.

'The data calls are in an array at the top of the page if that helps any?'

If you have everything in your array, you can simply use the function implode() and you are good to go.

Show me a print_r of your array and I can help you further.

Cheers,
z

[Publisher Bucks]

Originally Posted by zerovic

Show me a print_r of your array and I can help you further.

This is literally all the code I have in the page (its real basic).

<?php

$id=intval($_GET['id']);

if($id==0)

{

header( "Location: /search" ); //or any other page like 404

exit;

}

$pdo=hookitup();

$table = "ProductLibrary";

$sql="select * from " . $table . " where ID=" . $pdo->quote($id);

//echo "sql=" . $sql . "<br>";

$stmt=$pdo->query($sql);

//echo "rows back=" . $stmt->rowcount() . "<br>";

$row=$stmt->fetch(PDO::FETCH_ASSOC);

$id = $row['ID'];
$Category = $row['Category'];
$Name = $row['Name'];
$One = $row['One'];
$Two = $row['Two'];
$Three = $row['Three'];
$Four = $row['Four'];

?>

Im just echo'ing the data onto the page where I need to display it from the array.

[Publisher Bucks]

Originally Posted by zerovic

Hi,

You can put a simple IF before each row

That will work even if all im pulling into the page from the database is the URL itself?

[Publisher Bucks]

That IF statement works perfectly for what I needed, thank you so much for the code 👍

[zerovic]

Yeah, looking at your code, the IF function is what you are looking for

[k0nr4d]

Originally Posted by zerovic

Hi,

You can put a simple IF before each row



etc

You can also use trim($var) and strlen($var) > 0 if there is a chance that your DB has rows with only spaces by mistake.

'The data calls are in an array at the top of the page if that helps any?'

If you have everything in your array, you can simply use the function implode() and you are good to go.

Show me a print_r of your array and I can help you further.

Cheers,
z

You have to use isset() or empty() now, otherwise it throws a fatal error in PHP8

[Clown]

Originally Posted by k0nr4d

You have to use isset() or empty() now, otherwise it throws a fatal error in PHP8

Correct. Proper error checking is a must for PHP.

[zerovic]

Originally Posted by k0nr4d

You have to use isset() or empty() now, otherwise it throws a fatal error in PHP8

Yeah, you are right.