convert a part of text into html format?

[hisham]

In mysql database I have a field its name: content, type: text , my question: what is the code or how to convert a part of this text into html format? i.e. if the field contain the following text:
Please visit my site

http://www.myserver.com

.
So I need to convert

http://www.myserver.com

into link to the specific url.
Thanks in advance.

 

[HowardMarks]

Hi Hisham. this may be part of the solution you're looking for. it works fine but you must know the name of the URL which is in the string.


<?php

$originalstring = &quot;The URL is

http://www.thisurl.com.

Please click the link&quot;;
$newstring = str_Replace(&quot;

http://www.thisurl.com&quot;,&quot;<a

href='

http://www.thisurl.com'>www.thisurl.com</a>&quot;

,$originalstring);

echo $newstring;


?>


I am investigating ways of searching the string for any web addresses and automatically replacing them, but the above code might help you for now. Nick (Web Developer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

 

[badaze]

Insert directly html command in your database

Please visit my site <a href=&quot;

http://www.myserver.com&quot;>www.myserver.com</a>

.

 

[danielhozac]

There was a thread in which a preg_replace was posted that will convert any email and

http://WWW-addresses

into links. Though I was unable to find it, so I will make an attempt to make a regexp that should work:
$content = preg_replace(&quot;!((

http://)?(www\.|

[A-Za-z0-9\-\.]+\.)?[A-Za-z0-9\-\.]+\.[A-Za-z\.]{2,5}(/[A-Za-z0-9\-\._ ]+)?)!&quot;, &quot;<a href=\&quot;\\1\&quot;>\\1</a>&quot;, $content);
I hope this gets you started, at least. //Daniel

 

[danielhozac]

Actually, I think I read it in faq434-1837 //Daniel