2. PHPRunner General questions
  3. how do I get web addresses in my database?
This topic is locked

how do I get web addresses in my database?

 		7/29/2008 7:43:41 PM
PHPRunner General questions
author

how do I get web addresses in my mysql database?

I've tried longtext. varchar, longblob

I want to link to url address with slideshows for each job I can't seem to get the http://www.mysite.com into the database.

what am I missing (except my mind for even starting this)

Patti
never mind I got it to work. I just had to change it to text area and make the size bigger.
But how can I get the link to not be www.mysite.com but something like ben's pages?
J
 		Jane 7/30/2008

Hi,
to set up field as hyperlink just select corresponding option on the "View as" settings dialog on the Visual Editor tab.
500429 7/30/2008

how do I get the link to be something other than www.mysite.com? I want it to be either a picture or say ben's pictures. How can I do that?
J
 		Jane 7/31/2008

Hi,
to set up link field as picture on the list/view pages use Cusrtom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:

if ($value)

$value = "<a href=\"".$value."\"><img src=\"your_image.jpg\" border=0></a>";
500430 7/31/2008

I just want the link in phprunner to say Click Here for Ben's Pictures instead of www.mysite.com/benspictures.
One thing I guess I need to add a field to my table called display_name but then how do I call that to replace the other name... wow maybe I'm asking to much.
J
 		Jane 8/1/2008

It's hard to understand you.

What page do you use? Does all info is in the database? Where is link description stored?

Please clarify.
500431 8/1/2008

I have a link item_A that will be viewed in an iframe using custom code.

when you are looking at the link right now it says www.mysite.com/item_A.

I want it to still be the same link but say "click here to view ben's pictures."
I would think that I need to have a field when I add item_A that I type in "click here to view ben's pictures" but then... what and where do I tell phprunner to do this exchange of name not properties... if it's even possible.
500432 8/1/2008

Hi,

to set up link field as picture on the list/view pages use Cusrtom format on the "View as" settings dialog on the Visual Editor tab.

Here is a sample:


how would I integrate your code with the one I already have in custom format for the iframe

$value="<a href=\"http://".$value."\"; target=body1>".$value."</a>";
I would rather have it say "click here to view" instead of an image.
J
 		Jane 8/4/2008

Hi,
for example you have two fields:

LinkField - direct link, I.e. "www.mysite.com/item_A";.

DescField - link description, I.e. "click here to view ben's pictures".
Set up Link field as hyperlink on the "View as" settings dialog on the Visual Editor tab, select Display field content option and choose DescField.
500433 8/4/2008

Jane, that won't work for me because as I said I'm using an iframe custom setting I need to know how to add the comand to view "descption_of_slideshow field"" to the code I have in the custom setting

$value="<a href=\"http://".$value."\" target=body1>".$value."</a>";