Very complex variables

[Anon]

I'm making a guest book and I'm trying to do something rather complex but I can't seem to get a way to do it...

In the form, the variable $email is entered which is then altered before being inserted into the database table.

$email = "<b>E-Mail</b>:&nbsp;&nbsp;$email";

Thats fine, I want to be able to click on this once outputted.

So I tried this...

$email = "<b>E-Mail</b>:&nbsp;&nbsp;<a href = "$email">$email</a>";

Not supprisingly this didn't work due to the double use of "", so I tried replacing each set with '' as below.

$email = '<b>E-Mail</b>:&nbsp;&nbsp;<a href = "$email">$email</a>';

outputs $email as a link!

$email = "<b>E-Mail</b>:&nbsp;&nbsp;<a href = '$email'>$email</a>";

gives a message about an error in my SQL syntax.

I can't seem to find any other way to do it, both sets of quotation marks HAVE to be "", but that just isn't possible.

Thanks for any help

[blue928]

your output link should look like this:

echo ("E-mail address:");

echo ("a href=\"mailto:[e-mail]\">This person's email</a>");

//end
u need to be sure to escape the quotation marks in the href. so, if u are using a variable for the email, then the mailto section would look like this:

mailto:$email\">the person's email</a> etc..

i didnt quite follow ur post, but i hope this helps.. if not post again and ill respond with something more clear

[Anon]

Try $email = stripslashes($email);
This may get you past the sql error

CT

[Anon]

I followed you post, so you want to store this in your mysql field:
$value = "<a href = \'mailto:$email\'>$email</a>" ;

[Anon]

Thanks a load, it works great, can't believe I forgot the mailto: part!

When I said I had the mail, I also had a page URL which I thought would be simple, so I tried the same system and found a bug, if the person puts down http://www.site.com its fine, but if they miss out the http:// it doesn't work, if there any way to see if the input for the URL has http:// and if so leave it, and if not add it?

Thanks again

[Anon]

if ($squad_page == "http://") {$squad_page = "<b>Squad URL</b>:&nbsp;&nbsp;<a href=\'$squad_page\'>$squad_page</a>";}
else if ($squad_page != "http://")
{
$squad_page = "http://$squad_page";
$squad_page = "<b>Squad URL</b>:&nbsp;&nbsp;<a href=\'$squad_page\'>$squad_page</a>";
}

Thats something I tried btw, but it just sticks http:// onto the front of everything, not useful is someone puts on http:// themselves, the other way of course would be to start the field with http://, until some bright spark crosses that out and messes it up, whatever I do its possible to mess up, but the less chance the better!

Thanks once more to all the geniuses out there!

[Anon]

i think you're all getting a bit carried away here.

first off, it is best to only store the value of $email in the database. this will keep the field size as small as possible.

when you want to display an address from the db, use something like :

echo "<a href='$db_email'>$db_email</a>";

php variables will not be interpolated if they are not in "" (double quotes) - ''s will not work. if you really want to have ""
s output to your html, use :
echo "<a href=\"$db_email\">$db_email</a>";
(escape the ""s)

to check for the presence of http:// just use :
eregi("http://", $url)

this will return true if its there or false if it isnt so:

$url = "http://phpbuilder.com";

if(eregi("http://",$url){
echo "valid url";
}else{
echo "invalid url";
}
should work for you...

hope this helps...

[Anon]

Thanks, I'll give it a go after a few hours sleep and work shift 🙂

As for simple? I tried to, I was putting in those values and then on the output I had real problems

<?

do {

printf ("

<tr><td>Name:&nbsp;%s</td></tr><tr><td>E-Mail:&nbsp%s</td></tr> etc... to $myrow["name"]... parts

} while ($myrow = mysql_fetch_array($result));

echo "</table>\n";

?>

This was giving me the output okay, but above it all just a list of all the things, like

Name
Email

as blank, so I tried using WHERE is the $result = mysql_query part, which gave an error of the mysql_fetch_array, after a few hours of fustration, I choose another angle.

Anyways, thanks again

Night

[Anon]

Thanks! You did miss one thing, the )) at the end, but after I noticed that it didn't give me 3 errors :-)

if (eregi("http://",$squad_page)) {$squad_page = "<b>Squad URL</b>:&nbsp;&nbsp;<a href=\'$squad_page\'>$squad_page</a>";}
else {
$squad_page = "http://$squad_page";
$squad_page = "<b>Squad URL</b>:&nbsp;&nbsp;<a href=\'$squad_page\'>$squad_page</a>";
}

Thanks again.