StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5425097
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-03-24T20:27:22.177
FavoriteCount
0
LastActivityDate
2011-03-24T20:27:22.177
LastEditDate
LastEditorUserId
0
OwnerUserId
353790
ParentId
5424792
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
there's a few steps you can take to get a clean url. Firstly you need to make sure there is a protocol to make parse_url work correctly so you can do: <pre><code>//Make sure it has a protocol if(substr($url,0,7) != 'http://' || substr($url,0,8) != 'https://') { $url = 'http://' . $url; } </code></pre> Now we run it through <code>parse_url()</code> <pre><code>$segments = parse_url($url); </code></pre> But this is where it get's complicated because the way domain names are constructed is that you can have 1,2,3,4,5,6 .. .domain levels, meaning that you cannot detect the domain name from all urls, you have to have a pre compiled list of tld's to check the last portion of the domain, so you then can extract that leaving the website's domain. There is a list available here : <a href="http://mxr.mozilla.org/mozilla-central/source/netwerk/dns/effective_tld_names.dat?raw=1" rel="nofollow">http://mxr.mozilla.org/mozilla-central/source/netwerk/dns/effective_tld_names.dat?raw=1</a> But you would be better of parsing this list into mysql and then select the row where the tld matches the left side of the domain string. Then you order by length and limit to 1, if this is found then you can do something like: <pre><code>$db_found_tld = 'co.uk'; $domain = 'a.b.c.domain.co.uk'; $domain_name = substr($domain,0 - strlen($db_found_tld)); </code></pre> This would leave <code>a.b.c.domain</code>, so you have removed the tld, now the domain name would be extracted like so: <pre><code>$parts = explode($domain_name); $base_domain = $parts[count($parts) - 1]; </code></pre> now you have <code>domain</code>. this seems very lengthy but I hope now you know that its not easy to get just the domain name without tld or sub domains.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POclean the url in php
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRobertPitt
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.