simple question (i hope)

FrozNic

when a user inserts there website addy into a text field it posts to the dbase just fine...

example:
they insert:
www.microsoft.com
it posts as that into the dbase..

but when i pull it out, instead of making the link just www.microsoft.com it makes it http://localhost/foldername/www.microsoft.com

a little strange...
i thought that it was a local host issue so i uploaded it to the live site, and same problem.

one fix is simply to check and see if [url]http://[/url] is included in the link, and add that to every insert, but, i have a lot of forms and would rather not do that if i don't have to. i'm just wondering if there's a way to make it so that it doesn't add do http://localhost/ (link) to it. thanks for any thoughts... - Froz

tsinka

Hi,

I think you must include [url]http://[/url] because the browser always tries to get the link as a local page relative to the current directory if there is no [url]http://[/url] in front of the url.

To make things easier you might want to create a php function that assembles the URL and to place it in an exctra php script you include where needed. This would make it easier to implement future changes because you would only have to change code at one place 🙂

FrozNic

i think ur right, i'm having no luck, and can't find a darn thing on it. i was thinking maybe you could build an alias or something in apache.conf but, i can't find anything on that either... oh well, guess i'll spend an hour doing garbage i wish i didn't have to do 🙂 thanks..

kevinsequeira

post the code that ure using to insert and get the value out of the database

reg
kevin

FrozNic

form post post.php (example)


<input name="txtweb" type="text" id="email2" size="30" value="<?= $_REQUEST['email'] ?>">

~~post.php~~

			$sql = "INSERT INTO community_cat_listing (community_id, url, name, description, community_category,"
			. " email, contact_first_name, use_first_name, contact_last_name, use_last_name, contact_phone,"
			. " use_phone, contact_cell_phone, use_cell_phone, contact_email, use_email, contact_fax, use_fax,"
			. " start_date, end_date, associate_id) VALUES (" . $_REQUEST['selCom'] . ",'"
			. $_REQUEST['txtweb'] . "','" . $_REQUEST['eventname'] . "','" . $_REQUEST['text'] . "',"
			. $_REQUEST['listing_cat'] . ",'" . $_REQUEST['email'] . "','" . $_REQUEST['first_name'] . "','"
			. $_REQUEST['usefirst'] . "','" . $_REQUEST['last_name'] . "','" . $_REQUEST['uselast'] . "','"
			. $_REQUEST['phone_area'] . $_REQUEST['phone_middle'] . $_REQUEST['phone_end'] . "','" . $_REQUEST['usephone']
			. "','" . $_REQUEST['cell_area'] . $_REQUEST['cell_middle'] . $_REQUEST['cell_end'] . "','" . $_REQUEST['usecell']
			. "','" . $_REQUEST['email'] . "','" . $_REQUEST['useemail'] . "','" . $_REQUEST['fax_area'] . $_REQUEST['fax_middle']
			. $_REQUEST['fax_end'] . "','" . $_REQUEST['usefax'] . "','" . $start_date . "','" . $end_date 
			. "'," . $_SESSION['valid_user_id'] . ")";
			$result = $dbq->Run_SQL($sql);

website is in there... posts just fine

posts to temp table as (exp) www.msn.com

puts in just fine..

when user decides to buy the listing, it comes out of the temp table and goes into main product table. also inserts and queries just fine.. no changes to the link...

then i run the query to pull that data:

$qry = new DBQuery();
			$result = $qry->qryEventByID($_REQUEST['eid']);
	IF (!$result) print "Query Event By ID Select Query Failed<br>";
	ELSE
	{
		$row = mysql_fetch_array($result);
	}

~ ~~here's the actual query~~ ~

	function qryEventByID( $id )
	{
		IF ( $this->DBconnect() )
		{
			$today = date("Y-m-d");
			$sql = "SELECT ccl.url, ccl.name event_name, ccl.description, ccl.email, ccl.contact_first_name, ccl.use_first_name,"
			. " ccl.contact_last_name, ccl.use_last_name, ccl.contact_phone, ccl.use_phone, ccl.contact_cell_phone,"
			. " ccl.use_cell_phone, ccl.contact_email, ccl.use_email, ccl.contact_fax, ccl.use_fax, ccl.start_date,"
			. " ccl.end_date, ce.admission, ce.building_area, ce.street, ce.city, ce.state, ce.zip, ce.zip_plus,"
			. " ce.from_date, ce.to_date, ce.from_time, ce.to_time, cat.name category_name"
			. " FROM community_cat_listing ccl, community_events ce, community c, categories cat"
			. " WHERE ccl.id = ce.community_cat_listing_id "
			. " AND c.id = ccl.community_id AND cat.id = ccl.community_category"
			. " AND ccl.id = " . $id;
			$result1 = mysql_query($sql);
			IF ( !$result1 ) RETURN FALSE;
			RETURN $result1;
		}
		else
		{	
			print "NO CONNECT";
			RETURN FALSE;
		}
	}

~~ end function ~~

then to print it:

                              

<? $row['url'] > "" ? print $fontblack . "<a href=\"" . $row['url'] . "\" target=\"_blank\">" . $row['url'] . "</a>$end" : print $fontblack . 'no website availabe' . $end; ?>

and it prints as
http://localhost.com/www.msn.com

you asked for the code 😛

kevinsequeira

if the url is stored in the db as <a href="http://www.msn.com" target="_blank">www.msn.com</a>

then when u want to print it out just do
<? $row['url'] > "" ? print $fontblack .$row['url'] .$end : print $fontblack . 'no website availabe' . $end; ?>

instead of this

<? $row['url'] > "" ? print $fontblack . "<a href=\"" . $row['url'] . "\" target=\"_blank\">" . $row['url'] . "</a>$end" : print $fontblack . 'no website availabe' . $end; ?>

reg
kevin

FrozNic

i'd do that, cept, not everyone puts in www.msn.com as there link.. some will put in [url]http://[/url] and if i check the beginning of it that would work just fine.

BUT, i'd have to do this in so many places that i'm not so sure i like thinking about it anymore...