Search DaniWeb - postcode

Postcode Validation 11 Years Ago by millsy007 …I am using some code to validate uk postcode. I was wondering how I could make…input type="postcode" /> Postcode<br /> </form> function IsPostcode($postcode) { $postcode = strtoupper(str_replace(' ','',$postcode)); if(preg_match(&…2}[0-9]{2,3}[A-Z]{2}$/",$postcode) || preg_match("/^[A-Z]{1,2}[0… Re: Postcode Validation 11 Years Ago by millsy007 …]){1}$" }, messages: { postcode: { required: "Please Enter Postcode", minlength: jQuery.format("… need to use at least {0} characters for your postcode.") } } }); }); </script> … SQL Group By Postcode Area 14 Years Ago by jammiedude …wondering if anyone has a solution for sorting by postcode area. I wanted to be able to pick… group by the first to characters of the postcode using Left(x,2) but i wanted to…string from the left fuction. i.e. if the postcode has "L1", i just want "…;L", or if postcode has "CH", i want "CH"… Canadian postcode map data for use on Google Maps 12 Years Ago by tom_benton I have searched everywhere and seems unable to find postcode map data (preferably in lat/long) of Canada. I would …need these data up to the LDU in the postcode. My idea is to create a map with the… postcode overlay similar to this: [URL="http://www.imapbuilder.com/… Re: Search using postcode 13 Years Ago by benjaminFowl87 … is viewing this topic for information. You can get UK postcode information from the Royal Mail although it does cost some… it, i am currently implementing a search for venues by postcode with a given distance. I'll let you know once… on this forum if i can't called search by postcode and distance. Search using postcode 16 Years Ago by searchacar … on my site it shows cars according to closest to postcode search. Is this easy to implement. Are there any charges… to get postcode list for UK. I am not a senior php developer… Restrict geocode execution on Postcode 10 Years Ago by TIM_M_91 … only execute the folowing code when the user enters a postcode to be within Greenwich according to the Latitude and Longitude… Greenwich how do I do this? As each time the postcode changes both the latitude and longitude changes? $val = getLnt($zip… Re: Search using postcode 16 Years Ago by searchacar can anyone suggest me from where i can get postcode list for UK. thanks Re: Restrict geocode execution on Postcode 10 Years Ago by diafol Why don't you just have a list of postcodes for Greenwich (array) and if the postcode matches one of the entries, then bingo. Job Search with postcode & location search 13 Years Ago by haribo83 … be able to search on keywords in one field and postcode/location in another similar to guardian jobs ([URL="http… Near Latitide&Longitide for given postcode 11 Years Ago by veledrom Hi, Let me explain with an example. I have a postcode `NW1 5LR` and its `LATITUDE:51.546069024064 LONGITUDE:-0.235949008191785` coming from user entry. I also have many other postcodes and their Latitide&Longitide values in database. What formula should I use to get only those postcodes which are in 1 mil away maximum? Thanks Help to build a dealership search based on location or postcode 8 Years Ago by Ritesh_4 … it, else the user has an option to enter a postcode on the webform as well, and from there locate the… Re: Postcode Validation 11 Years Ago by pritaeas Do you want to call your PHP script with an AJAX call, or do you want to do the check in Javascript? Re: Postcode Validation 11 Years Ago by millsy007 Sorry didn't make that clear. Do the check in PHP Re: Postcode Validation 11 Years Ago by Taywin What do you mean by "not working"? Does it mean that it doesn't correctly match or it doesn't display? I'm quite sure that your regex doesn't work in all cases because you are not utilizing regex advantages. If you are matching postal code that has multiple formats, you should attempt to match each format one-by-one, not try to match all… Postcode Validation 14 Years Ago by WackyZ Can someone please help me - I need to write a function that will validate UK postcodes written in a textbox but every tutorial and example source code I find for it is in other languages such as VB and Javascript. The VB code looks extremely small: 1. Public Function isValidPostCode(ByVal input As String) As Boolean 2.… Re: Postcode Validation 14 Years Ago by Ionelul I don't think that Delphi has any function to parse regular expressions, so I looked on this site [URL="http://www.ml-consult.co.uk/foxst-39.htm"]http://www.ml-consult.co.uk/foxst-39.htm[/URL] and found some informations from which i built the following function [CODE] function TForm1.CheckIfValid(anInput : String) : Boolean; var… Re: Postcode Validation 14 Years Ago by WackyZ Thank you so very much, you have really helped me a lot. Re: Postcode Validation 14 Years Ago by Ionelul You're welcome, but you have found your answer, please mark the thread as solved. Ionut Re: SQL Group By Postcode Area 14 Years Ago by sknake Aren't postal codes all numeric? Where do you live Re: SQL Group By Postcode Area 14 Years Ago by jammiedude Sorry, didnt take into account american readers. UK post codes have letters and number in them and range from 5 characters to 8, it usually takes the form 1 or 2 letters, plus 2 or 3 numbers plus 2 more letters. ie "xx00 0xx" or "x0 00xx" or "xx00x 0xx" I really just want to identify the first 1 or 2 letters … Re: SQL Group By Postcode Area 14 Years Ago by jammiedude Solved it!! But just for anyone else in the UK who is wanting the same solution without spending most of the day trying to trial and error their way through, use the following code: [code=SQL] GROUP BY CASE WHEN ISNUMERIC(right(Left(C.Pcode,2),1)) = '0' THEN left(C.pcode,2) ELSE left(C.pcode,1) END [/code] You must also use this … Re: SQL Group By Postcode Area 14 Years Ago by sknake Try something like [code=sql] (case when code like '[a-Z][a-Z]%' then substring 2 else substring one end) [/code] finish the substring part. I'm on my phone and non alpha chars are hard to use Re: Canadian postcode map data for use on Google Maps 12 Years Ago by Airshow You could try [url]www.geonames.org[/url] but I think it gives just a centrepoint for each post code area, not the whole locus. [B]Airshow[/B] Re: Job Search with postcode & location search 13 Years Ago by chrishea PHP is fine for what you are trying to do. Assuming that you are going to keep the jobs in a database (MySQL) then you can use some SQL statements to query the database based on your input fields. You aren't the first to want one of these and there are some open source php systems out there that may save you some work. They may not be exactly what… Re: Near Latitide&Longitide for given postcode 11 Years Ago by diafol So you want a 1 mile radius about the co-ordinate? http://www.zodiacal.com/tools/lat_table.php http://www.movable-type.co.uk/scripts/latlong.html Re: Near Latitide&Longitide for given postcode 11 Years Ago by veledrom Looks like I will use a SQL statement to calculate and return the places instead of doing same thing in PHP. Another question is: The code below is for 1 **MIL**, What is I want in 1 **KM**? SELECT ((ACOS(SIN($lat * PI() / 180) * SIN(lat * PI() / 180) + COS($lat * PI() / 180) * COS(lat * PI() / 180) * COS(($lon – lon) * PI() / 180… Re: Near Latitide&Longitide for given postcode 11 Years Ago by diafol That SQL doesn't look right to me. HAVING `distance` => '1' Should be HAVING `distance` >= '1' ? 1 mile = 1.609344 kilometres Re: Near Latitide&Longitide for given postcode 11 Years Ago by veledrom I don't understand how this query knows that value **1** represents MILE or KM? Re: Near Latitide&Longitide for given postcode 11 Years Ago by diafol Well, it's beyond me. I'd have to sit down and think, wipe the nosebleed, sit down and think, recover from an stroke, sit down and think... Seriously, there must be a script out there somewhere.