How to check if the user has entered or not entered data to Mysql using PHP?

Question

I'm trying to see if the user has entered a website URL into the database with the following code. If the user did not enter their website's URL, do not display anything. If the user did enter their website, display the website.

I think I'm doing it wrong.

    <?php
    if (!empty($url))
    {
    echo'';
    } else { 
    echo'p>Website: <a href="<?php echo "http://","$url"; ?>" title="<?php echo "$url"; ?>"><?php echo "http://","$url"; ?></a></p>';
    } 
    ?>

There are a number of odd things going on here. Where is $url coming from, for a start? I think we need to see more code - if this is it, then you're not even accessing a database O.o — user97410
– user97410, Commented Oct 6, 2009 at 0:53

jeroen · Accepted Answer · 2009-10-06 01:44:59Z

2

Apart from the wrong order (you need to remove ! before the empty()), you also have some errors in the echo part: the < is missing for the < p > tag and you are including php tags in your string.

It should read something like:

echo '<p>Website: <a href="http://' . $url . '" title="' . $url . '">http://' . $url . '</a></p>';

edited Oct 6, 2009 at 1:44

answered Oct 6, 2009 at 1:30

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

Comments

nickf · Accepted Answer · 2009-10-06 00:53:06Z

1

what you've got there is that you're checking if it's NOT empty (that is, there is some data), you're echoing an empty string. If it IS empty, then you're echoing it out.

Remove the ! in the first line and you should be right.

answered Oct 6, 2009 at 0:53

nickf

548k199 gold badges660 silver badges727 bronze badges

2 Comments

22. Over a year ago

I only get this now Website: " title="">.

yoda Over a year ago

in that case, the error isn't in that block of code, is earlier.

yoda · Accepted Answer · 2009-10-06 00:53:42Z

1

You're simple mismatching the meaning of "!" :

<?php
if (!empty($url))
{
echo'p>Website: <a href="<?php echo "http://","$url"; ?>" title="<?php echo "$url"; ?>"><?php echo "http://","$url"; ?></a></p>';
} else { 
echo'';
} 
?>

answered Oct 6, 2009 at 0:53

yoda

11k19 gold badges68 silver badges94 bronze badges

Collectives™ on Stack Overflow

How to check if the user has entered or not entered data to Mysql using PHP?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related