27
Jul
0

US States Snippet and SQL Dump

by jestep

Here's some US states snippets. Included are php arrays, and a MySQL states dump...

PHP Snippets:

PLAIN TEXT
PHP:
  1. //states and abbreviations snippets
  2. $states = array('Alaska','Alabama','Arkansas','Arizona','California','Colorado','Connecticut','Delaware','Florida','Georgia','Hawaii','Iowa','Idaho','Illinois','Indiana','Kansas','Kentucky','Louisiana','Massachusetts','Maryland','Maine','Michigan','Minnesota','Missouri','Mississippi','Montana','North Carolina','North Dakota','Nebraska','New Hampshire','New Jersey','New Mexico','Nevada','New York','Ohio','Oklahoma','Oregon','Pennsylvania','Rhode Island','South Carolina','South Dakota','Tennessee','Texas','Utah','Virginia','Vermont','Washington','Wisconsin','West Virginia','Wyoming');
  3.  
  4. $abbreviations = array('AK','AL','AR','AZ','CA','CO','CT','DE','FL','GA','HI','IA','ID','IL','IN','KS','KY','LA','MA','MD','ME','MI','MN','MO','MS','MT','NC','ND','NE','NH','NJ','NM','NV','NY','OH','OK','OR','PA','RI','SC','SD','TN','TX','UT','VA','VT','WA','WI','WV','WY');
  5.  
  6. $states_assoc = array(
  7. 'AL'=>"Alabama", 
  8. 'AK'=>"Alaska", 
  9. 'AZ'=>"Arizona", 
  10. 'AR'=>"Arkansas", 
  11. 'CA'=>"California", 
  12. 'CO'=>"Colorado", 
  13. 'CT'=>"Connecticut", 
  14. 'DE'=>"Delaware", 
  15. 'DC'=>"District Of Columbia", 
  16. 'FL'=>"Florida", 
  17. 'GA'=>"Georgia", 
  18. 'HI'=>"Hawaii", 
  19. 'ID'=>"Idaho", 
  20. 'IL'=>"Illinois", 
  21. 'IN'=>"Indiana", 
  22. 'IA'=>"Iowa", 
  23. 'KS'=>"Kansas", 
  24. 'KY'=>"Kentucky", 
  25. 'LA'=>"Louisiana", 
  26. 'ME'=>"Maine", 
  27. 'MD'=>"Maryland", 
  28. 'MA'=>"Massachusetts", 
  29. 'MI'=>"Michigan", 
  30. 'MN'=>"Minnesota", 
  31. 'MS'=>"Mississippi", 
  32. 'MO'=>"Missouri", 
  33. 'MT'=>"Montana",
  34. 'NE'=>"Nebraska",
  35. 'NV'=>"Nevada",
  36. 'NH'=>"New Hampshire",
  37. 'NJ'=>"New Jersey",
  38. 'NM'=>"New Mexico",
  39. 'NY'=>"New York",
  40. 'NC'=>"North Carolina",
  41. 'ND'=>"North Dakota",
  42. 'OH'=>"Ohio", 
  43. 'OK'=>"Oklahoma", 
  44. 'OR'=>"Oregon", 
  45. 'PA'=>"Pennsylvania", 
  46. 'RI'=>"Rhode Island", 
  47. 'SC'=>"South Carolina", 
  48. 'SD'=>"South Dakota",
  49. 'TN'=>"Tennessee", 
  50. 'TX'=>"Texas", 
  51. 'UT'=>"Utah", 
  52. 'VT'=>"Vermont", 
  53. 'VA'=>"Virginia", 
  54. 'WA'=>"Washington", 
  55. 'WV'=>"West Virginia", 
  56. 'WI'=>"Wisconsin", 
  57. 'WY'=>"Wyoming");

MySQL Snippets:

PLAIN TEXT
SQL:
  1. -- ----------------------------
  2. -- Table structure for states
  3. -- ----------------------------
  4. CREATE TABLE `states` (
  5.   `state_id` tinyint(3) UNSIGNED NOT NULL,
  6.   `state_name` varchar(22) NOT NULL,
  7.   `state_abbreviation` char(2) NOT NULL,
  8.   PRIMARY KEY  (`state_id`),
  9.   UNIQUE KEY `state_abbreviation` (`state_abbreviation`)
  10. ) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
  11.  
  12. -- ----------------------------
  13. -- Records
  14. -- ----------------------------
  15. INSERT INTO `states` VALUES ('1', 'Alabama', 'AL');
  16. INSERT INTO `states` VALUES ('2', 'Alaska', 'AK');
  17. INSERT INTO `states` VALUES ('3', 'Arizona', 'AZ');
  18. INSERT INTO `states` VALUES ('4', 'Arkansas', 'AR');
  19. INSERT INTO `states` VALUES ('5', 'California', 'CA');
  20. INSERT INTO `states` VALUES ('6', 'Colorado', 'CO');
  21. INSERT INTO `states` VALUES ('7', 'Connecticut', 'CT');
  22. INSERT INTO `states` VALUES ('8', 'Delaware', 'DE');
  23. INSERT INTO `states` VALUES ('9', 'District of Columbia', 'DC');
  24. INSERT INTO `states` VALUES ('10', 'Florida', 'FL');
  25. INSERT INTO `states` VALUES ('11', 'Georgia', 'GA');
  26. INSERT INTO `states` VALUES ('12', 'Hawaii', 'HI');
  27. INSERT INTO `states` VALUES ('13', 'Idaho', 'ID');
  28. INSERT INTO `states` VALUES ('14', 'Illinois', 'IL');
  29. INSERT INTO `states` VALUES ('15', 'Indiana', 'IN');
  30. INSERT INTO `states` VALUES ('16', 'Iowa', 'IA');
  31. INSERT INTO `states` VALUES ('17', 'Kansas', 'KS');
  32. INSERT INTO `states` VALUES ('18', 'Kentucky', 'KY');
  33. INSERT INTO `states` VALUES ('19', 'Louisiana', 'LA');
  34. INSERT INTO `states` VALUES ('20', 'Maine', 'ME');
  35. INSERT INTO `states` VALUES ('21', 'Maryland', 'MD');
  36. INSERT INTO `states` VALUES ('22', 'Massachusetts', 'MA');
  37. INSERT INTO `states` VALUES ('23', 'Michigan', 'MI');
  38. INSERT INTO `states` VALUES ('24', 'Minnesota', 'MN');
  39. INSERT INTO `states` VALUES ('25', 'Mississippi', 'MS');
  40. INSERT INTO `states` VALUES ('26', 'Missouri', 'MO');
  41. INSERT INTO `states` VALUES ('27', 'Montana', 'MT');
  42. INSERT INTO `states` VALUES ('28', 'Nebraska', 'NE');
  43. INSERT INTO `states` VALUES ('29', 'Nevada', 'NV');
  44. INSERT INTO `states` VALUES ('30', 'New Hampshire', 'NH');
  45. INSERT INTO `states` VALUES ('31', 'New Jersey', 'NJ');
  46. INSERT INTO `states` VALUES ('32', 'New Mexico', 'NM');
  47. INSERT INTO `states` VALUES ('33', 'New York', 'NY');
  48. INSERT INTO `states` VALUES ('34', 'North Carolina', 'NC');
  49. INSERT INTO `states` VALUES ('35', 'North Dakota', 'ND');
  50. INSERT INTO `states` VALUES ('36', 'Ohio', 'OH');
  51. INSERT INTO `states` VALUES ('37', 'Oklahoma', 'OK');
  52. INSERT INTO `states` VALUES ('38', 'Oregon', 'OR');
  53. INSERT INTO `states` VALUES ('39', 'Pennsylvania', 'PA');
  54. INSERT INTO `states` VALUES ('40', 'Rhode Island', 'RI');
  55. INSERT INTO `states` VALUES ('41', 'South Carolina', 'SC');
  56. INSERT INTO `states` VALUES ('42', 'South Dakota', 'SD');
  57. INSERT INTO `states` VALUES ('43', 'Tennessee', 'TN');
  58. INSERT INTO `states` VALUES ('44', 'Texas', 'TX');
  59. INSERT INTO `states` VALUES ('45', 'Utah', 'UT');
  60. INSERT INTO `states` VALUES ('46', 'Vermont', 'VT');
  61. INSERT INTO `states` VALUES ('47', 'Virginia', 'VA');
  62. INSERT INTO `states` VALUES ('48', 'Washington', 'WA');
  63. INSERT INTO `states` VALUES ('49', 'West Virginia', 'WV');
  64. INSERT INTO `states` VALUES ('50', 'Wisconsin', 'WI');
  65. INSERT INTO `states` VALUES ('51', 'Wyoming', 'WY');

Enjoyed reading this post?
Subscribe to the RSS feed and have all new posts delivered straight to you.
Post your comment


Copyright © 2010 SayNoToFlash, Jamie Estep, All Rights Reserved · Theme design by Themes Boutique