extracting links as clickable links from sql table

Question

Been at this for a while and cant figure it out so i thought id come to the ppl who know. my php / sql is so-so but.....this is what im trying to do / figure out..

i have a database setup to take in messages (of any sort) and works fine. The user enters data in a field, hits send, and the message gets logged.

But when a user puts in a link for example " http://www.google.com " its stored in the DB just fine but when its printed back onto the page, it comes back as plain text, what i want is that when the page throws back the message with the link in it, that the link is live and clickable.

Ive googled my a$# off but im guessing im searching for the wrong thing (or im missing something unbeknownst to me. )

Any tips/*direction* etc, ill gladly accept. also, I dont mind doing the work/research so if you have links only ill take those too.

Thanks in advanced.

Of course, you must construct an html link in order to have a clickable link...You need to recognize the link and surround it with the right html markup — Damien Pirsy
– Damien Pirsy, Commented Mar 5, 2012 at 13:04

Guillaume Poussel · Accepted Answer · 2012-03-05 13:04:02Z

1

You need to parse messages plain text in order to find links. Then, change link texts by adding an anchor tag (<a>).

This link should help you.

answered Mar 5, 2012 at 13:04

Guillaume Poussel

9,8522 gold badges35 silver badges43 bronze badges

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

1 Comment

somdow Over a year ago

thanks that got it working. On that link, the example kept throwing errors, turns out the problem was a quoting problem...double quotes within another set of double quotes. i just changed the inner pair to single and works 100%. thanks for the link.

Community · Accepted Answer · 2017-05-23 10:34:51Z

1

you need regular expressions to detect links and convert them to <a href="$link">...</a> see the answer here:

PHP validation/regex for URL

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Mar 5, 2012 at 13:03

Not_a_Golfer

49.5k15 gold badges130 silver badges95 bronze badges

Comments

Arif · Accepted Answer · 2012-03-05 13:07:47Z

0

<a href="<?php echo "your_field"; ?>"> <?php echo "your_field"; ?> </a>

answered Mar 5, 2012 at 13:07

Arif

1,2116 gold badges31 silver badges60 bronze badges

3 Comments

Guillaume Poussel Over a year ago

The OP said messages (of any sort) so I guess there is not a field which contains only the link. Links are mixed up with plain text.

Arif Over a year ago

@S0pra in the above question, its stated that (when a user puts in a link for example " google.com " its stored in the DB just fine ) i m talking about that LINK_FIELD :-p

somdow Over a year ago

yeah thats what i mean S0pra. i have say a paragraph and in that paragraph of text, a link somewhere in there, i need a way to parse that on print into a clickable link.

adamdehaven · Accepted Answer · 2012-03-05 13:18:48Z

0

Something like this should work (I took this from some code I wrote for a client):

$query = mysql_query("SELECT * FROM wcordersinfo WHERE dealer_id = '" . $dealer_id . "' && drawing_num = " . $_GET['reference_id'] . "");
    while ($orders = mysql_fetch_array($query)) {
        if ($orders['drawing_num'] != '') {
            $link_open = '<a href="http://www.example.com/dealers/order-details.php?reference_id=' . $orders['drawing_num'] . '">';
            $link_close = '</a>';
        } else {
            $link_open = $link_close = '';
        }

and then where you want to display the content:

<?php echo "<li>' . $link_start . $orders['carrier'] . $link_end . '</li>"; ?>

answered Mar 5, 2012 at 13:18

adamdehaven

5,92010 gold badges64 silver badges84 bronze badges

Comments

Moritz · Accepted Answer · 2012-03-05 14:08:21Z

0

You may want to check out http://www.php.net/manual/en/function.preg-replace.php for replacing regular expressions with something.

There you want to replace every website with a typical html link syntax like <a href="...">...</a>

edited Mar 5, 2012 at 14:08

answered Mar 5, 2012 at 13:04

Moritz

2661 silver badge8 bronze badges

2 Comments

Damien Pirsy Over a year ago

Note that "<a>" alone isn't valid, you need to indicate the href attribute too

Moritz Over a year ago

yes I know that:D That was the short answer. I assumed he knows that :)

Collectives™ on Stack Overflow

extracting links as clickable links from sql table

5 Answers 5

1 Comment

Comments

3 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

3 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related