corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » PHP & Database guys


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author PHP & Database guys
Gary
Premium Member

Avatar

Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
6th Jul 11 at 14:03   View Garage View User's Profile U2U Member Reply With Quote

After a quote on something making up.

Will be a database of customers/venues details, entered via a web based front end.

Will need to have the function of searching for venues within 'x' miles raduis (Google maps API?) along with certian other basic criteria.

Needs a calender in there to veiw results of searches on as well as a list.

Will also need some sort of basic booking function, so a 'venue' can be free or booked.

Lot of work?
ed
Member

Registered: 10th Sep 03
User status: Offline
6th Jul 11 at 14:11   View User's Profile U2U Member Reply With Quote

Will it need integrating into another website or is it standalone?
Gary
Premium Member

Avatar

Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
6th Jul 11 at 14:11   View Garage View User's Profile U2U Member Reply With Quote

Standalone. No fancy font end, just basic really.
ed
Member

Registered: 10th Sep 03
User status: Offline
6th Jul 11 at 14:33   View User's Profile U2U Member Reply With Quote

That's something I could do for you. I'll u2u you in a little bit...
Dom
Member

Registered: 13th Sep 03
User status: Offline
6th Jul 11 at 15:27   View User's Profile U2U Member Reply With Quote

So basically you're after a booking system?
Having built a few booking systems for recruitment agencies, i wouldn't say it's piss easy. But if you want it as basic as you say you want it then i'd say it could be done in a few days (+ shakedown(s) etc).
How accurate do you need the distances to be? Only say as you're required to display the Google Map when using it's API (so it can start to look messy) and if you're happy with 'as the crow flies' (+/- a few miles) then you can use postcode data and haversine formula.

No doubt Ed will sort you out, but give us a shout otherwise.

Edit - There are a number of bookings systems about that might do what you're after. Can't remember any names but i've got a load bookmarked and will post them up when i get in....

[Edited on 06-07-2011 by Dom]
Sam
Moderator
Premium Member


Registered: 24th Dec 99
Location: West Midlands
User status: Offline
6th Jul 11 at 15:32   View User's Profile U2U Member Reply With Quote

I did something like this once many years ago with osC
Gary
Premium Member

Avatar

Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
6th Jul 11 at 15:39   View Garage View User's Profile U2U Member Reply With Quote

I'm writing a brief for Ed, so i'll fwd it onto you two also.

Cheers guys
ed
Member

Registered: 10th Sep 03
User status: Offline
6th Jul 11 at 15:39   View User's Profile U2U Member Reply With Quote

Gary
Premium Member

Avatar

Registered: 22nd Nov 06
Location: West Yorkshire
User status: Offline
6th Jul 11 at 16:24   View Garage View User's Profile U2U Member Reply With Quote

Email sent Ed.

U2U on its way dom and sam
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Jul 11 at 19:12   View Garage View User's Profile U2U Member Reply With Quote

Radius search is easy enough so long as you're happy with crow flies.

I've got data if you need it. Wouldn't bother with Google API unless you need proper directions to the place. Distances alone can just be done with database lookups if you have the list of postcodes.
ed
Member

Registered: 10th Sep 03
User status: Offline
6th Jul 11 at 19:15   View User's Profile U2U Member Reply With Quote

Did you buy the PAF thing from Royal Mail to do it, or has something happened recently to get hold of that data for free?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Jul 11 at 19:20   View Garage View User's Profile U2U Member Reply With Quote

Got a few sets,

L1
L1 1
L1 1AA

Only when you start getting a fairly high density of points that you need the higher res data sets.

Can also be downloaded from data.gov.uk but you need to register and faff, import, write queries etc.
ed
Member

Registered: 10th Sep 03
User status: Offline
6th Jul 11 at 19:26   View User's Profile U2U Member Reply With Quote

Noticed they even provide a web service for Geocoding postcodes: http://data.gov.uk/apps/geopostcode

Does your data have addresses too, or is it postcode and co-ordinates?
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
6th Jul 11 at 19:48   View Garage View User's Profile U2U Member Reply With Quote

No just co-ordinates.

The street name address stuff is not available currently.
Dom
Member

Registered: 13th Sep 03
User status: Offline
6th Jul 11 at 20:09   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by ed
Did you buy the PAF thing from Royal Mail to do it, or has something happened recently to get hold of that data for free?


I've ended up using Linuxbox.co.uk PAF data in the past, bit more accurate than RM's own (down to 14 decimal places) and it's a shed load cheaper!
http://data.gov.uk/apps/geopostcode is handy though, but i've never found their API to be that quick for handling large amounts of requests; although it's useful if you need free PAF data and can store/cache the results.
ed
Member

Registered: 10th Sep 03
User status: Offline
7th Jul 11 at 08:21   View User's Profile U2U Member Reply With Quote

That's pretty useful to know too. I've had a few ideas where this kind of stuff could be useful but I've been put off by the Google Geocoding API - it's a bit slow and clunky. Saying that, V3 is a lot better than what it previously was.
ed
Member

Registered: 10th Sep 03
User status: Offline
7th Jul 11 at 08:22   View User's Profile U2U Member Reply With Quote

Though I have noticed that Google can be a few miles out when geocoding a postcode, still...

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
PHP database connection help! Planty02 Geek Day 13 963
10th Sep 06 at 21:51
by Planty02
 
MYSQL Database liamC Geek Day 3 799
18th Dec 06 at 17:57
by aPk
 
Any vBulletin guys out there? Andrew Geek Day 9 1040
15th Feb 07 at 08:24
by Andrew
 
question about forums (phpbb) and SQL Bart Geek Day 4 369
5th Nov 07 at 00:12
by Ian
 
Website building... Dan Geek Day 17 405
31st Jan 11 at 12:36
by ed
 

Corsa Sport » Message Board » Off Day » Geek Day » PHP & Database guys 29 database queries in 0.0185630 seconds