Changing echoed out text on page to links with Javascript or PHP from MySQL Query

Question

So i am making a very basic site where someone types in a box some text and it posts it into mysql.

Example:

Here is my post with a cool link - htt://www.coolness.com

The following script simply grabs the column wanted from the database and echos it on a line.

<?php
$con = mysql_connect("localhost","####","####");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("####", $con);

$result = mysql_query("SELECT * FROM posts");

while($row = mysql_fetch_array($result))
  {
  echo $row['post_content'];
  echo "<br />";
  }

mysql_close($con);
?>

The link is in plain text and instead I would like either php or javascript to write it as a hyperlink by adding the whole bit to it.

I've looked through examples, but nothing seemed to work when I tried to apply them.

Any tips would be great.

This link shows someone solving the same problem stackoverflow.com/questions/8027023/… — chris_code
– chris_code, Commented Jun 16, 2012 at 16:27
This link shows someone solving the same problem stackoverflow.com/questions/8027023/… — chris_code
– chris_code, Commented Jun 16, 2012 at 16:28

Matsemann · Accepted Answer · 2012-06-16 16:08:11Z

1

Hope I understood what you meant:

Change to

while($row = mysql_fetch_array($result))
  {
  echo '<a href="' . $row['post_content'] . '">' . $row['post_content'] . '</a>';
  echo "<br />";
  }

What this code does, is that it prints the links inside <a> tags, which are links.

answered Jun 16, 2012 at 16:08

Matsemann

22k20 gold badges60 silver badges91 bronze badges

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

2 Comments

Isaac Boda Over a year ago

Correct, but not everything they post into the database will be a link. This would just make the whole post in mysql a link. Here is my post with a cool link - urladdress into Here is my post with a cool link - <a href="urladdress">urladdress</a>

Matsemann Over a year ago

Okey, now I think I understand what you meant. You could use a regular expression (regex) to find URLs in the text, and then surround those with the <a href=""> stuff.

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

1

Use preg_replace() in PHP. Pass it a regular expression for a URL, how you want that matched URL to be replaced, and then the string you pulled from your DB.

You want to turn "http://www.coolness.com" into "http://www.coolness.com'>http://www.coolness.com".

See this question for discussion on regexes for URL matching, and this piece of the PHP documentation for more on the preg_replace() function.

EDIT: SO seems to have had fun with my second line there! It should read:

You want to turn "http://www.coolness.com" into "<a href='http://www.coolness.com'>http://www.coolness.com</a>".

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Jun 16, 2012 at 16:17

Richard

1,0821 gold badge7 silver badges15 bronze badges

Collectives™ on Stack Overflow

Changing echoed out text on page to links with Javascript or PHP from MySQL Query

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related