DomainPrices.co.uk rework

[Admin]

I am reworking DomainPrices.co.uk to add more search features, the current version is here and the new version is here.

I am having to rework the data in a new DB and am now rationalising the categories assign to each domain to match what appears down the left hand side.

Any comments / suggestions welcome.

Try the "advanced search" option, thats my main reason for changing it, apart from now having an Admin backend to allow easier additions and maintenance.

Thanks

Admin

 

[crobbo]

....................

 

[bensd]

Great work Alan.

Is that a rework of domain sales script? I'm sure i have seen it before.

Couple of good features could be to categorise all ".co.uk", ".org.uk" and ".me.uk"

Also, what about "Top 10" sales of all time.

Great to see you keeping it up though - great resource when looking for comps.

Cheers

Ben

 

[Admin]

Great work Alan.

Is that a rework of domain sales script? I'm sure i have seen it before.

shhhh! lol

If you put the domain extension in the keyword box you'll just get those domains. To make it a definable search I'll have to add a new field and then store the domain extension for each sale, unless someone is a wizard with the "trim" feature to read the TLD from the domain itself.

 

[foz]

I prefer the original http://www.domainprices.co.uk/

The emphasis should be on price, not the genre or industry category.

 

[Admin]

I prefer the original http://www.domainprices.co.uk/

The emphasis should be on price, not the genre or industry category.

If you go to the advanced search, you get the same view as the current one but then have options to filter your view further. You can still sort by price

 

[foz]

If you go to the advanced search, you get the same view as the current one but then have options to filter your view further. You can still sort by price

Yes, but I think that isn't obvious to the user visiting the site. I'd prefer clicking on one button showing the highest amount to the lowest in a certain year (goes for the sold date to). Which is what is in place at the moment.

Comes across, as more of an attempt, to make the Domain Trader script fit something it wasn't intended for.

 

[stender]

I may be being a muppet but when i tried to sort by category you could select all but didnt appear to be able to deselect all in order to just search one category?

ignore me! new site has it sorted.

 

[Admin]

I see what you mean foz, maybe I'll keep the current version with the new one behind feeding off the same db so people have the option. How would that suit?

 

[Jeewhizz]

unless someone is a wizard with the "trim" feature to read the TLD from the domain itself.

Several ways to do it. Storing it as a separate column is going to be best, but as you've not done that.

SELECT field1,field2 FROM table WHERE SUBSTRING(domain_field,-5) = 'co.uk'

or

SELECT field1,field2 FROM table WHERE domain_field REGEXP 'co\.uk$'

The latter is probably slower...

 

[Admin]

Thanks!

As most are .co.uk I could add a column, fill that with .co.uk and then just edit the exceptions.

I have added updated sales for September, October and November. Now I need to have a look around to see what I missed.

The front page now has a search button that links to the new DB. So you have it as it was plus the categorised view with "keyword" and other search options.

I will improve on that in time.

Admin

 

[Jeewhizz]

Thanks!

As most are .co.uk I could add a column, fill that with .co.uk and then just edit the exceptions.

 UPDATE domains SET extension = IF( domain REGEXP "\.co\.uk$", 'co.uk', extension ) ,
extension = IF( domain REGEXP "\.org\.uk$", 'org.uk', extension ) ,
extension = IF( domain REGEXP "\.me\.uk$", 'me.uk', extension )

That will work for the following table:

table name: domains
domains column
extension column

Fiddle as needed, but it should work fine

There might be an easier way of doing it, but it's too late to think straight

 

[Admin]

Cool, I wish I had your knowledge on PHP/MySQL, I've spent 2 days doing the domain prices update!

I hope people find it useful.

Admin