Url If, then statement @.@

ruri

I was going across a tutorial on how to make a shoutbox and came across these code

<?php
include('chatter.php');
$q = "select * from chatterblock order by id desc ";
$result = mysql_query($q);
while ($row = mysql_fetch_array($result)) {
$id = $row["id"];
$name=$row["name"];
$url = $row["url"];

      $msg = $row["msg"];
      echo "<b>$name</b><br><a href=\"$url\" target=\"new\">Website</a><br>$msg<hr>"; 
 }

I was wondering if there was a way to make it so that
"if url is empty, then don't display"
Because for now at the shoutbox, even if you don't type anything in the [url]http://[/url] section, it will still show up. I've been looking for how to do it x.x" but maybe I'm not searching in the correct terms so..
Thanks in advance!

tommynanda

So.. u dont want to execute

echo "$name <a href=\"$url\" target=\"new\">Website</a> $msg<hr>";

this statement .. if $url is empty rite?

add this to your code

if(!empty($url))
{
echo "$name <a href=\"$url\" target=\"new\">Website</a> $msg<hr>";
}

Good Luck
TommYNandA

DominicIGO

It's only the URL that he doesn't want to display. 😉

echo "<b>$name</b><br>";
if(!empty($url))
{
	echo "<a href=\"$url\" target=\"new\">Website</a><br>";
}
echo "$msg<hr>";

laserlight

<?php
include 'chatter.php';
$q = "SELECT * FROM chatterblock ORDER BY id DESC";
$result = mysql_query($q);
while ($row = mysql_fetch_array($result)) {
	if (!empty($row["url"])) {
		$id = $row["id"];
		$name = $row["name"];
		$url = $row["url"];
		$msg = $row["msg"];
		echo "<b>$name</b><br><a href=\"$url\" target=\"_blank\">Website</a><br>$msg<hr>";
	}
}
?>

Note that you dont need parentheses for the include statement, that it is preferable to capitalise keywords in SQL, and that target="_blank" should be used unless you have a frame named "new".
Additionally, you may wish to apply htmlspecialchars() on data to be displayed.

ruri

thanks 🙁 except i tried all of them but it seems like the codes don't work.
Currently I have laser's on in my php code x.x"
my shoutbox is here:
http://lonesomenight.shyper.com/chatter.html
and the website still shows up so.. :queasy: