code adds my url to url for link?

Printable View

08-18-2010, 05:06 PM
I am Abby

code adds my url to url for link?

Code:

<?php // Retrieve all the data from the "webcalendar_events" table $result = mysql_query("SELECT * FROM webcalendar_events ) or die(mysql_error()); echo "Decription: {$row['description']}"; }

I got a calendar from PHPScripts which allows you to enter links in it.
The above script (I snipped) is used to get featured dates to place on the page. Works great, with the help of Traq, but for some reason my webpage added my url to links found in the description field. If the link in the calendar (which works correctly within the calendar) is

Code:

http://www.there.com

the link I get using the above code gives me a link with the address

Code:

http://mysite.com/%22http://www.there.com

Is the problem the script? or the way the calendar puts it into the db?
08-18-2010, 06:08 PM
djr33

It's impossible to know why that is happening from the information you posted.
The first thing to do is check how it is stored in the database. Do you have phpmyadmin or another way to view it directly? If not, I'd recommend doing a much simpler query that just prints out all the data so you can look at it:

PHP Code:

<?php //run this as a new page //then click view>source ///// //connect to the database!! ///// $q = mysql_query('SELECT * FROM `mytable`;'); while($r = mysql_fetch_assoc($q)) { print_r($r); } ?>

It may very well be how the calendar saves it, but we can't know that yet.
08-18-2010, 06:59 PM
I am Abby

Your script gave me an array...the same thing I was getting with the field names.

I looked at the fields in the database and the urls are stored like this

Code:

<a href=\"http://page.com\">link</a>
08-18-2010, 07:07 PM
I am Abby

Array ( [id] => 4 [calendar_id] => 1 [dt] => 2010-08-20 [color] => ffff00 [description] => test of events to be printed on page. tiis is iit KCM )

The above is what I get from the script you gave me. KCM was a link...the link is gone now but the url was my site and the link seperated by %22

I cut all but one record to make it more readable.
08-18-2010, 10:20 PM
djr33

As I said, view it as source code, not as HTML.
The text output in the source code is what you are dealing with.
After that, it should be easy to figure out.
And yes, it will be an array. That is to view this if you do NOT have another way to view it directly. If you have phpmyadmin or another option like that, you should just view it that way.

This is all just to see what format it is stored in and whether it is even possible to do what you are attempting. Once you know that, then you can determine the next step.
08-19-2010, 07:43 PM
I am Abby

Not sure what do you mean "view it as source code"

When I look into the database at the record, the description field has "Another item to test <a href=\"http://uiuc.edu\">U of I</a>" in it.

when I run that code you gave me above...I get a list of everything in the array but the field looks like "Another item to test U of I"
08-20-2010, 05:27 AM
djr33

"view as source" means viewing the HTML code as text, after it is generated by PHP. The easiest way to do that is to create a page on your server, save it, then go to the URL and click "edit>view source" (or whatever method works in your browser).
That was only to be able to view exactly what was being generated from your database. But since you found another way to view it, that is no longer important.

If you have the text stored containing HTML directly (such as the links) it will be a lot harder to modify than if it was stored separately. I'm not sure what to suggest aside from some complex form of search and replace operation.
08-23-2010, 12:51 PM
I am Abby

Wow, I was sick, sick, sick this weekend but I'm better now...don't you just hate getting sick on the weekend!

The source code looks like this...doesn't this look right?

Code:

<body> August 20, 2010 Decription: test of events to be printed on page. this is it <a href=\"http://www.uiuc.edu\">U of I</a>September 14, 2010

But when you move the mouse over the link on the page it looks like

Code:

http://mysite.com/%22http://www.there.com
08-23-2010, 01:09 PM
djr33

Interesting. Is there a base href on the page?
08-23-2010, 04:11 PM
I am Abby

Here is the complete code for the test page. Only thing I changed was the mysql_connect information...

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <?php // Make a MySQL Connection mysql_connect("xxx.xxx.xxx.xx", "login", "password") or die(mysql_error()); mysql_select_db("nlchdb") or die(mysql_error()); // Retrieve all the data from the "webcalendar_events" table $result = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt") or die(mysql_error()); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $monthnames = array( "01"=>"January", "02"=>"February", "03"=>"March", "04"=>"April", "05"=>"May", "06"=>"June", "07"=>"July", "08"=>"August", "09"=>"September", "10"=>"October", "11"=>"November", "12"=>"December"); list($year, $month, $day) = split('[/.-]', $row['dt']); $month = $monthnames[$month]; echo "{$month} {$day}, {$year} ". "Decription: {$row['description']}"; } $q = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt"); while($r = mysql_fetch_assoc($q)) { print_r($r); } ?> </body> </html>

Again the code does a good job with the exception of adding extra info to the link urls.
08-24-2010, 12:06 AM
djr33

Honestly I have no idea. Clearly some part of the process, unknown to us, is doing something odd. All I can say is double check all the code and be sure that it isn't like that in the database. Can you export/backup the db and go trough it manually?
08-25-2010, 01:56 PM
I am Abby

It looks correct in the database.
Well thanks for your time anyway:)
08-25-2010, 02:36 PM
traq

Quote:

Originally Posted by I am Abby

Code:

this is it <a href=\"http://www.uiuc.edu\">U of I</a>September 14, 2010

But when you move the mouse over the link on the page it looks like

Code:

http://mysite.com/%22http://www.there.com

In your source code, are the backslashes present before the doublequotes ( \" )?

If something (some kind of server configuration, most likely) is automatically adding a base url to your links, it probably looks for href attributes that seem to be internal. The slashes (which shouldn't be there) might be interfering with that check...

Maybe. ( ??? )

Try running stripslashes() on the url the database returns and see if helps.

PHP Code:

while($r = mysql_fetch_assoc($q)) { // try it here - I think that'll catch it stripslashes($r); print_r($r); }

Also try adding an external url ( <a href="http://www.othersite.com">external</a> ) directly into your html and see if the base url is added or not.

You could also contact your service provider and see if there is someway to turn that "feature" off.
08-25-2010, 03:03 PM
I am Abby

one of my friends said because the urls in the source code has slashes

Code:

<a href=\"http://page.com\">link</a>

I should do a remove slashes...so I tried

Code:

// Make a MySQL Connection mysql_connect("xxx.xxx.xxx.xx", "login", "password") or die(mysql_error()); mysql_select_db("nlchdb") or die(mysql_error()); // Retrieve all the data from the "webcalendar_events" table $result = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt") or die(mysql_error()); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { //remove code we don't need to see for this. <snip>---</snip> list($year, $month, $day) = split('[/.-]', $row['dt']); $month = $monthnames[$month]; $str = stripslashes($row['description']; echo "{$month} {$day}, {$year} ". "Decription: {$str}";

and that didn't remove them.
So I came back here and saw your post and tried...

Code:

// Make a MySQL Connection mysql_connect("xxx.xxx.xxx.xx", "login", "password") or die(mysql_error()); mysql_select_db("nlchdb") or die(mysql_error()); // Retrieve all the data from the "webcalendar_events" table $result = mysql_query("SELECT * FROM webcalendar_events WHERE dt >= now() AND color='ffff00' ORDER BY dt") or die(mysql_error()); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { stripslashes($row); //remove code we don't need to see for this. <snip>---</snip> list($year, $month, $day) = split('[/.-]', $row['dt']); $month = $monthnames[$month]; echo "{$month} {$day}, {$year} ". "Decription: {$row['description']}";

Again it did not take the slashes out...is there another way to do it?

I not only put

Quote:

<a href="http://www.othersite.com">external</a>

on the page I also placed

Quote:

echo "<a href=\"http://www.othersite.com\">external</a>";

within the code tags...both worked correctly.
08-25-2010, 03:28 PM
traq

You might try stripslashes() in the individual entry that holds the link - I just noticed that $r is the entire row. Try stripslahes($r['link']) (or whatever the column that holds the link is called).

If you write a normal external link directly in your html, do you still get this problem? or is it limited to the links this script is generating?
08-25-2010, 03:52 PM
I am Abby

Code:

<snip> list($year, $month, $day) = split('[/.-]', $row['dt']); $month = $monthnames[$month]; echo "{$month} {$day}, {$year} ". "Decription: {stripslahes($row['description'])}"; }

The above gave me an error
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

I tried that earlier and it's the reason I tried

Code:

<snip> $str = stripslashes($row['description']; echo "{$month} {$day}, {$year} ". "Decription: {$str}";

which did not remove the slashes
08-25-2010, 04:45 PM
I am Abby

It worked.
Thanks Boys;)