some of my tables fields' contain web site link URL's. i have tried to ensure that a URL is entered as i want w/ the inclusion of http:// instead of the web app user simply entereing www.* for the entry by inserting a value in my HTML for, like so
<input type="text" name="web_site" value="http://" />
so when a user comes upon this field, he or she will be more inclined to enter their input data after the [url]http://.[/url].. thereby resulting in a data entry which is in my preferred format. however, i can NOT control whether the user might either accidentally or purposefully remove my preset input value.
so, considering this margin for error, what can i do so that when i'm SELECTing data from MySQL, i can be sure that if i'm going to put any web site URL data into an output string, that it will in fact contain the necessary http:// prefix, as in
$display_block .= "<p>just click <a href=\"$web_site\" >here</a> to follow the link";
would this best be done via MySQL commands or via PHP, or via some function which i must create?
thanks!!