John Davidson

Message:

I own a property preservation company. I'm rolling out an update to our current system. This update will allow our contractors to enter zip codes of areas they cover.. What would be the proper way to store this data in MYSQL?

Each user can cover multiple zip codes. So, I need to collect these zip codes and store it in the database for this user. Also, what would be the best way of collecting this list of zip code (HTML wise)? an input text, textarea or what ?

I appreciate all the help!

---

My Answer:
One way to store a list of zip codes in MySQL would be to create a separate table specifically for storing zip codes. This table could have columns for the user ID (to link the zip codes to a specific user), and the zip code itself. Each row in this table would represent a single zip code associated with a user.

To collect the list of zip codes from the user, you could use a text input field where the user can enter each zip code separated by a comma or space. You could also use a textarea if you anticipate the user entering a large number of zip codes. Another option could be to use a multi-select dropdown menu if you have a predefined list of zip codes that the user can choose from.

Once the user submits the form with the list of zip codes, you can then parse the input and store each zip code in the database table mentioned above. Make sure to validate the input to ensure that only valid zip codes are being stored.