Script helpers

These are useful time saving tools for developers. If you have a script that would be appropriate here, let me know, and I will post it up here for you.

SQL DUMP FILES:

MySQL State to Abbreviation Dump File (Index on the abbreviation in addition to a numbered id column):
States SQL Dump

PHP CLIPS:

State to Abbreviation PHP Snips

PLAIN TEXT
PHP:
  1. //states and abbreviations snips
  2. $states = "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 = "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");