search

stefangabos / world_countries

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries
http://stefangabos.github.io/world_countries/
Other
1.34k stars 374 forks source link

How to add flags inside to database #45

Closed PetrosPoll closed 3 years ago

PetrosPoll commented 3 years ago

Hello!

Sorry about my question maybe it will be out of logic but how can i added the flags inside to database you privide ? Also flags i downloaded from your code.

Thank you very much!

stefangabos commented 3 years ago

See this for somebody who added them as URI encoded values to the JSON Or you could write a script to URI encode all the images then add that to the database Or, maybe you can add the images themselves in a blob-type column (I am only familiar with MySQL so I don't know the equivalent in other database engines)

PetrosPoll commented 3 years ago

Hello and thank you for your quick response,

I'm also using MySQL and i want to save flags of countries to make request in my database from a project. I will add table with all countries via SQL code you have inside your zip file but how match them with each flag ? But my question is, it is a correct way to save photos as blod-type ?

Thank you very much and sorry if my questions are really basic.

On Wed, 2 Dec 2020 at 15:26, Stefan Gabos notifications@github.com wrote:

See this https://github.com/stefangabos/world_countries/issues/41 for somebody who added them as URI encoded values to the JSON Or you could write a script to URI encode all the images then add that to the database Or, maybe you can add the images themselves in a blob-type column (I am only familiar with MySQL so I don't know the equivalent in other database engines)

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/stefangabos/world_countries/issues/45#issuecomment-737228902, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJXG3AD3BPVR6PGIGESG2SLSSY6AVANCNFSM4UKNFAXA .

stefangabos commented 3 years ago

The matching is done via the alpha-2 code - the flags are named using that. search stackoverflow on how to add images to database

PetrosPoll commented 3 years ago

Ok thank you very much!

And the different of word and countries data?

Thank you very much!

On Wed, 2 Dec 2020 at 22:08, Stefan Gabos notifications@github.com wrote:

The matching is done via the alpha-2 code - the flags are named using that. search stackoverflow https://stackoverflow.com/questions/14704559/how-to-insert-image-in-mysql-databasetable on how to add images to database

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/stefangabos/world_countries/issues/45#issuecomment-737466533, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJXG3AAZSDX2674XHUHZRPTSS2NEXANCNFSM4UKNFAXA .

stefangabos commented 3 years ago

It's right there

PetrosPoll commented 3 years ago

Hello,

sorry about many questions.

I'm trying to add all flags images to each image but i don't know the exactly mysql query. Do you have something for me please?

there is 249 countries so it will be so bad if enter each one manually.

Thank you very much!

On Thu, 3 Dec 2020 at 11:58, Stefan Gabos notifications@github.com wrote:

It's right there https://github.com/stefangabos/world_countries#world-countries-

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/stefangabos/world_countries/issues/45#issuecomment-737811615, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJXG3AAM72FQIHWMVM3ZUKDSS5OL3ANCNFSM4UKNFAXA .