Connecting Tech Pros Worldwide Forums | Help | Site Map

script to generate an external link

info@musiclanerecording.com
Guest
 
Posts: n/a
#1: May 28 '07
hello all, if anyone out there could help me i would really appreciate
it. i am very much a novice coder. I have a site we are building and
we have created a section in the admin area to allow the client to add
external links to their web site. the problem we keep running into is
the links that get generated have the home page url in front.

ie. lets say the web site address is http://abc.com and i create an
external link called xyz. the url i put in the link generator is www.xyz.com
but what happens is the script spits out a link with this url:
http://abc.com/xyz.com.

below is the script:

//include external links
$query = "SELECT LINK_HREF, LINK_NAME
FROM LINK";

$lresult = mysql_query($query);

if (mysql_num_rows($lresult) == 0)
{
echo 'Verses being update.';
}
else
{
while ($row = mysql_fetch_array($lresult, MYSQL_ASSOC))
{
print "{$trOpen}" . "<a href=\"{$row['LINK_HREF']}\">" .
"{$row['LINK_NAME']}" . "</a>" . "{$trClose}";
}
}

If anyone could help i would be very grateful

God bless
jason


Steve Belanger
Guest
 
Posts: n/a
#2: May 28 '07

re: script to generate an external link


you could have the users put the http:// inside their links, or manually
adding it in the code before you place the link value inside the href
attribute of the link tag.


<info@musiclanerecording.comwrote in message
news:1180382783.518274.319420@k79g2000hse.googlegr oups.com...
Quote:
hello all, if anyone out there could help me i would really appreciate
it. i am very much a novice coder. I have a site we are building and
we have created a section in the admin area to allow the client to add
external links to their web site. the problem we keep running into is
the links that get generated have the home page url in front.
>
ie. lets say the web site address is http://abc.com and i create an
external link called xyz. the url i put in the link generator is
www.xyz.com
but what happens is the script spits out a link with this url:
http://abc.com/xyz.com.
>
below is the script:
>
//include external links
$query = "SELECT LINK_HREF, LINK_NAME
FROM LINK";
>
$lresult = mysql_query($query);
>
if (mysql_num_rows($lresult) == 0)
{
echo 'Verses being update.';
}
else
{
while ($row = mysql_fetch_array($lresult, MYSQL_ASSOC))
{
print "{$trOpen}" . "<a href=\"{$row['LINK_HREF']}\">" .
"{$row['LINK_NAME']}" . "</a>" . "{$trClose}";
}
}
>
If anyone could help i would be very grateful
>
God bless
jason
>

jsd219
Guest
 
Posts: n/a
#3: May 28 '07

re: script to generate an external link


On May 28, 3:16 pm, "Steve Belanger" <desk...@ebinformatique.com>
wrote:
Quote:
you could have the users put the http:// inside their links, or manually
adding it in the code before you place the link value inside the href
attribute of the link tag.
>
<i...@musiclanerecording.comwrote in message
>
news:1180382783.518274.319420@k79g2000hse.googlegr oups.com...
>
Quote:
hello all, if anyone out there could help me i would really appreciate
it. i am very much a novice coder. I have a site we are building and
we have created a section in the admin area to allow the client to add
external links to their web site. the problem we keep running into is
the links that get generated have the home page url in front.
>
Quote:
ie. lets say the web site address ishttp://abc.comand i create an
external link called xyz. the url i put in the link generator is
www.xyz.com
but what happens is the script spits out a link with this url:
http://abc.com/xyz.com.
>
Quote:
below is the script:
>
Quote:
//include external links
$query = "SELECT LINK_HREF, LINK_NAME
FROM LINK";
>
Quote:
$lresult = mysql_query($query);
>
Quote:
if (mysql_num_rows($lresult) == 0)
{
echo 'Verses being update.';
}
else
{
while ($row = mysql_fetch_array($lresult, MYSQL_ASSOC))
{
print "{$trOpen}" . "<a href=\"{$row['LINK_HREF']}\">" .
"{$row['LINK_NAME']}" . "</a>" . "{$trClose}";
}
}
>
Quote:
If anyone could help i would be very grateful
>
Quote:
God bless
jason
Not sure i follow

joboils@hotmail.com
Guest
 
Posts: n/a
#4: May 28 '07

re: script to generate an external link


On Mon, 28 May 2007 20:16:42 GMT, "Steve Belanger"
<desktop@ebinformatique.comwrote:
Quote:
>you could have the users put the http:// inside their links, or manually
>adding it in the code before you place the link value inside the href
>attribute of the link tag.
>
>
><info@musiclanerecording.comwrote in message
>news:1180382783.518274.319420@k79g2000hse.googleg roups.com...
Quote:
>hello all, if anyone out there could help me i would really appreciate
>it. i am very much a novice coder. I have a site we are building and
>we have created a section in the admin area to allow the client to add
>external links to their web site. the problem we keep running into is
>the links that get generated have the home page url in front.
>>
>ie. lets say the web site address is http://abc.com and i create an
>external link called xyz. the url i put in the link generator is
>www.xyz.com
>but what happens is the script spits out a link with this url:
>http://abc.com/xyz.com.
>>
>below is the script:
>>
>//include external links
>$query = "SELECT LINK_HREF, LINK_NAME
>FROM LINK";
>>
>$lresult = mysql_query($query);
>>
>if (mysql_num_rows($lresult) == 0)
>{
>echo 'Verses being update.';
>}
>else
>{
>while ($row = mysql_fetch_array($lresult, MYSQL_ASSOC))
>{
>print "{$trOpen}" . "<a href=\"{$row['LINK_HREF']}\">" .
>"{$row['LINK_NAME']}" . "</a>" . "{$trClose}";
>}
>}
>>
>If anyone could help i would be very grateful
>>
>God bless
>jason
>>
>
Not everyone will input a url in the format to suit you, so better
write a line to *remove* the "http://" from the input so that your
adding http:// to the output will not double up.
jsd219
Guest
 
Posts: n/a
#5: May 28 '07

re: script to generate an external link


On May 28, 3:47 pm, jobo...@hotmail.com wrote:
Quote:
On Mon, 28 May 2007 20:16:42 GMT, "Steve Belanger"
>
>
>
<desk...@ebinformatique.comwrote:
Quote:
you could have the users put the http:// inside their links, or manually
adding it in the code before you place the link value inside the href
attribute of the link tag.
>
Quote:
<i...@musiclanerecording.comwrote in message
news:1180382783.518274.319420@k79g2000hse.googlegr oups.com...
Quote:
hello all, if anyone out there could help me i would really appreciate
it. i am very much a novice coder. I have a site we are building and
we have created a section in the admin area to allow the client to add
external links to their web site. the problem we keep running into is
the links that get generated have the home page url in front.
>
Quote:
Quote:
ie. lets say the web site address ishttp://abc.comand i create an
external link called xyz. the url i put in the link generator is
>www.xyz.com
but what happens is the script spits out a link with this url:
>http://abc.com/xyz.com.
>
Quote:
Quote:
below is the script:
>
Quote:
Quote:
//include external links
$query = "SELECT LINK_HREF, LINK_NAME
FROM LINK";
>
Quote:
Quote:
$lresult = mysql_query($query);
>
Quote:
Quote:
if (mysql_num_rows($lresult) == 0)
{
echo 'Verses being update.';
}
else
{
while ($row = mysql_fetch_array($lresult, MYSQL_ASSOC))
{
print "{$trOpen}" . "<a href=\"{$row['LINK_HREF']}\">" .
"{$row['LINK_NAME']}" . "</a>" . "{$trClose}";
}
}
>
Quote:
Quote:
If anyone could help i would be very grateful
>
Quote:
Quote:
God bless
jason
>
Not everyone will input a url in the format to suit you, so better
write a line to *remove* the "http://" from the input so that your
adding http:// to the output will not double up.
Well, i just added the http:// to the address and everything worked,
so i think what i will do is hardcode in the http:// so the client
only has to put www.xxx.xxx

dave
Guest
 
Posts: n/a
#6: May 28 '07

re: script to generate an external link


Quote:
Well, i just added the http:// to the address and everything worked,
so i think what i will do is hardcode in the http:// so the client
only has to putwww.xxx.xxx
Thats all fine to take the easy way, but clients WILL enter
http://www.example.com.

Unless you have a select box/checkbox/radio buttons etc where you
write the values out, expect users to enter invalid data

If you expect data in a specific format, you need to validate it (or
as the previous poster explained, strip the http:// if it exists)

jsd219
Guest
 
Posts: n/a
#7: May 29 '07

re: script to generate an external link


On May 28, 5:13 pm, dave <dave.wa...@gmail.comwrote:
Quote:
Quote:
Well, i just added the http:// to the address and everything worked,
so i think what i will do is hardcode in the http:// so the client
only has to putwww.xxx.xxx
>
Thats all fine to take the easy way, but clients WILL enterhttp://www.example.com.
>
Unless you have a select box/checkbox/radio buttons etc where you
write the values out, expect users to enter invalid data
>
If you expect data in a specific format, you need to validate it (or
as the previous poster explained, strip the http:// if it exists)
I really appreciate all the help, thank you all very much

God bless
jason

Closed Thread


Similar PHP bytes