hyperlinks

Anon

i have a question i have input boxes for my db where i would put relevant info purtaining to a specific entry. i was wondering is there a code one can write in which that input box can recognize a web address when it sees one ?
for example ... i write a big statement and as soon as a www.blah.com type address shows up - it automatically creates a hyperlink to itself .... any ideas ? thanks for any help.

Anon

$text = ereg_replace("[^{<>[:space:]]+[[:alnum:]/]",}
"<a href=\"http://\0\" target=\"new\">\0</a>", $text);

this will convert any www.****. to a link.
I would say, first delete all http:// from your $text, because logically you wont need them.

Anon

sorry but im new to the game - would i change this script (the form) in order for it to work ?

<td width=119 bgcolor="#CCCCCC" valign="top"><b>Application Info : </b></td>
<td width=448 valign="top">

<input type="text" name="app_info" size="60" length="60" value="n/a" ></td>

or is it in the actual script that inputs the data ? (ie.- the addscript)

<?php
$db = @pg_connect("","","","","funds");
if (!$db) {echo "Could not connect to the Funding database"; exit;}
$query = "INSERT INTO scholarship (schol_id, schol_name, value, deadline, app_info, agency_name, eligibility, field, level) values (nextval('scholarship_schol_id_seq'), '$name', '$value', '$deadline', '$app_info', '$agency', '$eligibility', '$field', '$level')";
$result = @pg_exec($db, $query);
if (!$result) {echo "<b>ERROR:</b>Could not Add the Scholarship Name you entered, please go back and make sure you made a selection for each category."; exit;}
print ("The values were inserted into the database");

[deleted]

I think this will work a lot better:
$text = preg_replace("/(http:\/\/){0,1}www.(([0-9a-zA-Z\/:]+).)+(([0-9a-zA-Z\/:]+))/", "<a href=\"http://\0\" \">\0</a>", $text);

PS, http:// is not optional, it's mandatory. But people are lazy so browsers default to http.

Anon

im still not sure where exactly these statements would be put though, in the form ? or in the script ?

Anon

You could either put that code before you put it into the database, or after you retrieve it from the database. To do the former, it would look something like this:

$text = preg_replace("/(http:\/\/){0,1}www.(([0-9a-zA-Z\/:]+).)+(([0-9a-zA-Z\/:]+))/", "<a href=\"http://\0\" \">\0</a>", $text);

$query = "INSERT INTO scholarship (schol_id, schol_name, value, deadline, app_info, agency_name, eligibility, field, level) values (nextval('scholarship_schol_id_seq'), '$name', '$value', '$deadline', '$app_info', '$agency', '$eligibility', '$field', '$level')";

Then when you insert the data, the $text variable will have hyperlink code added to it. Does that answer your question?