Remove character from php variable

Question

I am trying to remove first 51 character of a long URL , I'm using

$sql = $db->Query(some query);
$mysite = $db->FetchArray($sql);
$str = $mysite['url'] ;
$str2 = substr('$str',51);

Above code return blank value, it works fine if i use plan text for $str e.g.

$str = "I am looking for a way to pull the first 100 characters from a string"
$str2 = substr('$str',10);

my url is like "https://dl.dropbox.com/u/55299544/google.html?urlc=http://example.com" i want to get http://example.com from database to show on user page, how can i do this?

Have you checked the return value of FetchArray? Perhaps you'll need to index the array like $mysite[0]['url'], try doing a print_r($mysite); — Cyclonecode
– Cyclonecode, Commented Jun 23, 2013 at 8:25
$mysite = $db->FetchArray($sql) -> this return full URL value it's correct, how can i do print_r($mysite)? — Deepak Punia
– Deepak Punia, Commented Jun 23, 2013 at 8:27

Panama Jack · Accepted Answer · 2013-06-23 08:32:18Z

1

You're making this too complicated. If you are trying to get the http://example.com from the long URL then do this.

<?php
sql = $db->Query(some query);
$mysite = $db->FetchArray($sql);
$str = $mysite['url'] ;

$query = parse_url($str, PHP_URL_QUERY );
parse_str($query, $link);

echo $link["urlc"]; //http://example.com
?>

answered Jun 23, 2013 at 8:32

Panama Jack

24.6k11 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Deepak Punia Over a year ago

OMG! it works, thak you very much @Pjack , one ore question -is this code get example.com character count or anything else? means it also work if i change dl.dropbox.com/u/55299544/google.html?urlc= with some other url?

Panama Jack Over a year ago

Yes it will work with any other URL with querystring parameters. It parses the querystring parameters of the URL into an array. Just supply the key you need to use. For example if your other url is $str = anothersite.com/?url1=myinfo&url2=yoursite.com. So if you want the value of yoursite.com then you would use the same code above and then do $link["url2"]. Hope that makes sense.

Collectives™ on Stack Overflow

Remove character from php variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related