Conditions | 2 |
Paths | 2 |
Total Lines | 262 |
Code Lines | 257 |
Lines | 0 |
Ratio | 0 % |
Changes | 0 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
1 | <?php |
||
22 | public function run() |
||
23 | { |
||
24 | $countries = [ |
||
25 | ['id' => '1', 'name' => 'Italy', 'continent_id' => '6', 'code' => 'IT'], |
||
26 | ['id' => '2', 'name' => 'United States', 'continent_id' => '3', 'code' => 'US'], |
||
27 | ['id' => '3', 'name' => 'Algeria', 'continent_id' => '1', 'code' => 'DZ'], |
||
28 | ['id' => '4', 'name' => 'Wallis and Futuna', 'continent_id' => '4', 'code' => 'WF'], |
||
29 | ['id' => '5', 'name' => 'Angola', 'continent_id' => '1', 'code' => 'AO'], |
||
30 | ['id' => '6', 'name' => 'Benin', 'continent_id' => '1', 'code' => 'BJ'], |
||
31 | ['id' => '7', 'name' => 'Botswana', 'continent_id' => '1', 'code' => 'BW'], |
||
32 | ['id' => '8', 'name' => 'Burkina Faso', 'continent_id' => '1', 'code' => 'BF'], |
||
33 | ['id' => '9', 'name' => 'Burundi', 'continent_id' => '1', 'code' => 'BI'], |
||
34 | ['id' => '10', 'name' => 'Cameroon', 'continent_id' => '1', 'code' => 'CM'], |
||
35 | ['id' => '11', 'name' => 'Cape Verde', 'continent_id' => '1', 'code' => 'CV'], |
||
36 | ['id' => '12', 'name' => 'Central African Republic', 'continent_id' => '1', 'code' => 'CF'], |
||
37 | ['id' => '13', 'name' => 'Chad', 'continent_id' => '1', 'code' => 'TD'], |
||
38 | ['id' => '14', 'name' => 'Comoros', 'continent_id' => '1', 'code' => 'KM'], |
||
39 | ['id' => '15', 'name' => 'Congo - Brazzaville', 'continent_id' => '1', 'code' => 'CG'], |
||
40 | ['id' => '16', 'name' => 'Congo - Kinshasa', 'continent_id' => '1', 'code' => 'CD'], |
||
41 | ['id' => '17', 'name' => 'Cote d\'Ivoire', 'continent_id' => '1', 'code' => 'CI'], |
||
42 | ['id' => '18', 'name' => 'Djibouti', 'continent_id' => '1', 'code' => 'DJ'], |
||
43 | ['id' => '19', 'name' => 'Egypt', 'continent_id' => '1', 'code' => 'EG'], |
||
44 | ['id' => '20', 'name' => 'Equatorial Guinea', 'continent_id' => '1', 'code' => 'GQ'], |
||
45 | ['id' => '21', 'name' => 'Eritrea', 'continent_id' => '1', 'code' => 'ER'], |
||
46 | ['id' => '22', 'name' => 'Ethiopia', 'continent_id' => '1', 'code' => 'ET'], |
||
47 | ['id' => '23', 'name' => 'Gabon', 'continent_id' => '1', 'code' => 'GA'], |
||
48 | ['id' => '24', 'name' => 'Gambia', 'continent_id' => '1', 'code' => 'GM'], |
||
49 | ['id' => '25', 'name' => 'Ghana', 'continent_id' => '1', 'code' => 'GH'], |
||
50 | ['id' => '26', 'name' => 'Guinea', 'continent_id' => '1', 'code' => 'GN'], |
||
51 | ['id' => '27', 'name' => 'Guinea Bissau', 'continent_id' => '1', 'code' => 'GW'], |
||
52 | ['id' => '28', 'name' => 'Kenya', 'continent_id' => '1', 'code' => 'KE'], |
||
53 | ['id' => '29', 'name' => 'Lesotho', 'continent_id' => '1', 'code' => 'LS'], |
||
54 | ['id' => '30', 'name' => 'Liberia', 'continent_id' => '1', 'code' => 'LR'], |
||
55 | ['id' => '31', 'name' => 'Libya', 'continent_id' => '1', 'code' => 'LY'], |
||
56 | ['id' => '32', 'name' => 'Madagascar', 'continent_id' => '1', 'code' => 'MG'], |
||
57 | ['id' => '33', 'name' => 'Malawi', 'continent_id' => '1', 'code' => 'MW'], |
||
58 | ['id' => '34', 'name' => 'Mali', 'continent_id' => '1', 'code' => 'ML'], |
||
59 | ['id' => '35', 'name' => 'Mauritania', 'continent_id' => '1', 'code' => 'MR'], |
||
60 | ['id' => '36', 'name' => 'Mauritius', 'continent_id' => '1', 'code' => 'MU'], |
||
61 | ['id' => '37', 'name' => 'Mayotte', 'continent_id' => '1', 'code' => 'YT'], |
||
62 | ['id' => '38', 'name' => 'Morocco', 'continent_id' => '1', 'code' => 'MA'], |
||
63 | ['id' => '39', 'name' => 'Mozambique', 'continent_id' => '1', 'code' => 'MZ'], |
||
64 | ['id' => '40', 'name' => 'Namibia', 'continent_id' => '1', 'code' => 'NA'], |
||
65 | ['id' => '41', 'name' => 'Niger', 'continent_id' => '1', 'code' => 'NE'], |
||
66 | ['id' => '42', 'name' => 'Vanuatu', 'continent_id' => '4', 'code' => 'VU'], |
||
67 | ['id' => '43', 'name' => 'Rwanda', 'continent_id' => '1', 'code' => 'RW'], |
||
68 | ['id' => '44', 'name' => 'Reunion', 'continent_id' => '1', 'code' => 'RE'], |
||
69 | ['id' => '45', 'name' => 'Saint Helena', 'continent_id' => '1', 'code' => 'SH'], |
||
70 | ['id' => '46', 'name' => 'Senegal', 'continent_id' => '1', 'code' => 'SN'], |
||
71 | ['id' => '47', 'name' => 'Seychelles', 'continent_id' => '1', 'code' => 'SC'], |
||
72 | ['id' => '48', 'name' => 'Sierra Leone', 'continent_id' => '1', 'code' => 'SL'], |
||
73 | ['id' => '49', 'name' => 'Somalia', 'continent_id' => '1', 'code' => 'SO'], |
||
74 | ['id' => '50', 'name' => 'South Africa', 'continent_id' => '1', 'code' => 'ZA'], |
||
75 | ['id' => '51', 'name' => 'Sudan', 'continent_id' => '1', 'code' => 'SD'], |
||
76 | ['id' => '52', 'name' => 'Swaziland', 'continent_id' => '1', 'code' => 'SZ'], |
||
77 | ['id' => '53', 'name' => 'Sao Tome and Príncipe', 'continent_id' => '1', 'code' => 'ST'], |
||
78 | ['id' => '54', 'name' => 'Tanzania', 'continent_id' => '1', 'code' => 'TZ'], |
||
79 | ['id' => '55', 'name' => 'Togo', 'continent_id' => '1', 'code' => 'TG'], |
||
80 | ['id' => '56', 'name' => 'Tunisia', 'continent_id' => '1', 'code' => 'TN'], |
||
81 | ['id' => '57', 'name' => 'Uganda', 'continent_id' => '1', 'code' => 'UG'], |
||
82 | ['id' => '58', 'name' => 'U.S. Minor Outlying Islands', 'continent_id' => '4', 'code' => 'UM'], |
||
83 | ['id' => '59', 'name' => 'Tuvalu', 'continent_id' => '4', 'code' => 'TV'], |
||
84 | ['id' => '60', 'name' => 'Western Sahara', 'continent_id' => '1', 'code' => 'EH'], |
||
85 | ['id' => '61', 'name' => 'Zambia', 'continent_id' => '1', 'code' => 'ZM'], |
||
86 | ['id' => '62', 'name' => 'Zimbabwe', 'continent_id' => '1', 'code' => 'ZW'], |
||
87 | ['id' => '63', 'name' => 'Anguilla', 'continent_id' => '3', 'code' => 'AI'], |
||
88 | ['id' => '64', 'name' => 'Antigua and Barbuda', 'continent_id' => '3', 'code' => 'AG'], |
||
89 | ['id' => '65', 'name' => 'Argentina', 'continent_id' => '7', 'code' => 'AR'], |
||
90 | ['id' => '66', 'name' => 'Aruba', 'continent_id' => '7', 'code' => 'AW'], |
||
91 | ['id' => '67', 'name' => 'Bahamas', 'continent_id' => '3', 'code' => 'BS'], |
||
92 | ['id' => '68', 'name' => 'Barbados', 'continent_id' => '7', 'code' => 'BB'], |
||
93 | ['id' => '69', 'name' => 'Belize', 'continent_id' => '3', 'code' => 'BZ'], |
||
94 | ['id' => '70', 'name' => 'Bermuda', 'continent_id' => '3', 'code' => 'BM'], |
||
95 | ['id' => '71', 'name' => 'Bolivia', 'continent_id' => '7', 'code' => 'BO'], |
||
96 | ['id' => '72', 'name' => 'Brazil', 'continent_id' => '7', 'code' => 'BR'], |
||
97 | ['id' => '73', 'name' => 'British Virgin Islands', 'continent_id' => '3', 'code' => 'VG'], |
||
98 | ['id' => '74', 'name' => 'Canada', 'continent_id' => '3', 'code' => 'CA'], |
||
99 | ['id' => '75', 'name' => 'Cayman Islands', 'continent_id' => '3', 'code' => 'KY'], |
||
100 | ['id' => '76', 'name' => 'Chile', 'continent_id' => '7', 'code' => 'CL'], |
||
101 | ['id' => '77', 'name' => 'Colombia', 'continent_id' => '7', 'code' => 'CO'], |
||
102 | ['id' => '78', 'name' => 'Costa Rica', 'continent_id' => '3', 'code' => 'CR'], |
||
103 | ['id' => '79', 'name' => 'Cuba', 'continent_id' => '3', 'code' => 'CU'], |
||
104 | ['id' => '80', 'name' => 'Dominica', 'continent_id' => '3', 'code' => 'DM'], |
||
105 | ['id' => '81', 'name' => 'Dominican Republic', 'continent_id' => '3', 'code' => 'DO'], |
||
106 | ['id' => '82', 'name' => 'Ecuador', 'continent_id' => '7', 'code' => 'EC'], |
||
107 | ['id' => '83', 'name' => 'El Salvador', 'continent_id' => '3', 'code' => 'SV'], |
||
108 | ['id' => '84', 'name' => 'Falkland Islands', 'continent_id' => '7', 'code' => 'FK'], |
||
109 | ['id' => '85', 'name' => 'French Guiana', 'continent_id' => '7', 'code' => 'GF'], |
||
110 | ['id' => '86', 'name' => 'Greenland', 'continent_id' => '3', 'code' => 'GL'], |
||
111 | ['id' => '87', 'name' => 'Grenada', 'continent_id' => '3', 'code' => 'GD'], |
||
112 | ['id' => '88', 'name' => 'Guadeloupe', 'continent_id' => '3', 'code' => 'GP'], |
||
113 | ['id' => '89', 'name' => 'Guatemala', 'continent_id' => '3', 'code' => 'GT'], |
||
114 | ['id' => '90', 'name' => 'Guyana', 'continent_id' => '7', 'code' => 'GY'], |
||
115 | ['id' => '91', 'name' => 'Haiti', 'continent_id' => '3', 'code' => 'HT'], |
||
116 | ['id' => '92', 'name' => 'Honduras', 'continent_id' => '3', 'code' => 'HN'], |
||
117 | ['id' => '93', 'name' => 'Jamaica', 'continent_id' => '3', 'code' => 'JM'], |
||
118 | ['id' => '94', 'name' => 'Martinique', 'continent_id' => '3', 'code' => 'MQ'], |
||
119 | ['id' => '95', 'name' => 'Mexico', 'continent_id' => '7', 'code' => 'MX'], |
||
120 | ['id' => '96', 'name' => 'Montserrat', 'continent_id' => '3', 'code' => 'MS'], |
||
121 | ['id' => '97', 'name' => 'Netherlands Antilles', 'continent_id' => '7', 'code' => 'AN'], |
||
122 | ['id' => '98', 'name' => 'Nicaragua', 'continent_id' => '3', 'code' => 'NI'], |
||
123 | ['id' => '99', 'name' => 'Panama', 'continent_id' => '3', 'code' => 'PA'], |
||
124 | ['id' => '100', 'name' => 'Paraguay', 'continent_id' => '7', 'code' => 'PY'], |
||
125 | ['id' => '101', 'name' => 'Peru', 'continent_id' => '7', 'code' => 'PE'], |
||
126 | ['id' => '102', 'name' => 'Puerto Rico', 'continent_id' => '3', 'code' => 'PR'], |
||
127 | ['id' => '103', 'name' => 'Saint Barthelemy', 'continent_id' => '3', 'code' => 'BL'], |
||
128 | ['id' => '104', 'name' => 'Saint Kitts and Nevis', 'continent_id' => '3', 'code' => 'KL'], |
||
129 | ['id' => '105', 'name' => 'Saint Lucia', 'continent_id' => '3', 'code' => 'LC'], |
||
130 | ['id' => '106', 'name' => 'Saint Martin', 'continent_id' => '3', 'code' => 'MF'], |
||
131 | ['id' => '107', 'name' => 'Saint Pierre and Miquelon', 'continent_id' => '3', 'code' => 'PM'], |
||
132 | ['id' => '108', 'name' => 'Saint Vincent and the Grenadines', 'continent_id' => '3', 'code' => 'VC'], |
||
133 | ['id' => '109', 'name' => 'Suriname', 'continent_id' => '7', 'code' => 'SR'], |
||
134 | ['id' => '110', 'name' => 'Trinidad and Tobago', 'continent_id' => '7', 'code' => 'TT'], |
||
135 | ['id' => '111', 'name' => 'Turks and Caicos Islands', 'continent_id' => '3', 'code' => 'TC'], |
||
136 | ['id' => '112', 'name' => 'U.S. Virgin Islands', 'continent_id' => '3', 'code' => 'VI'], |
||
137 | ['id' => '113', 'name' => 'Tonga', 'continent_id' => '4', 'code' => 'TO'], |
||
138 | ['id' => '114', 'name' => 'Uruguay', 'continent_id' => '7', 'code' => 'UY'], |
||
139 | ['id' => '115', 'name' => 'Venezuela', 'continent_id' => '7', 'code' => 'VE'], |
||
140 | ['id' => '116', 'name' => 'Tokelau', 'continent_id' => '4', 'code' => 'TK'], |
||
141 | ['id' => '117', 'name' => 'Afghanistan', 'continent_id' => '5', 'code' => 'AF'], |
||
142 | ['id' => '118', 'name' => 'Armenia', 'continent_id' => '5', 'code' => 'AM'], |
||
143 | ['id' => '119', 'name' => 'Azerbaijan', 'continent_id' => '5', 'code' => 'AZ'], |
||
144 | ['id' => '120', 'name' => 'Bahrain', 'continent_id' => '5', 'code' => 'BH'], |
||
145 | ['id' => '121', 'name' => 'Bangladesh', 'continent_id' => '5', 'code' => 'BD'], |
||
146 | ['id' => '122', 'name' => 'Bhutan', 'continent_id' => '5', 'code' => 'BT'], |
||
147 | ['id' => '123', 'name' => 'Brunei', 'continent_id' => '5', 'code' => 'BN'], |
||
148 | ['id' => '124', 'name' => 'Cambodia', 'continent_id' => '5', 'code' => 'KH'], |
||
149 | ['id' => '125', 'name' => 'China', 'continent_id' => '5', 'code' => 'CN'], |
||
150 | ['id' => '126', 'name' => 'Cyprus', 'continent_id' => '5', 'code' => 'CY'], |
||
151 | ['id' => '127', 'name' => 'Georgia', 'continent_id' => '5', 'code' => 'GE'], |
||
152 | ['id' => '129', 'name' => 'Hong Kong SAR China', 'continent_id' => '5', 'code' => 'HK'], |
||
153 | ['id' => '130', 'name' => 'India', 'continent_id' => '5', 'code' => 'IN'], |
||
154 | ['id' => '131', 'name' => 'Indonesia', 'continent_id' => '5', 'code' => 'ID'], |
||
155 | ['id' => '132', 'name' => 'Iran', 'continent_id' => '5', 'code' => 'IR'], |
||
156 | ['id' => '133', 'name' => 'Iraq', 'continent_id' => '5', 'code' => 'IQ'], |
||
157 | ['id' => '134', 'name' => 'Israel', 'continent_id' => '5', 'code' => 'IL'], |
||
158 | ['id' => '135', 'name' => 'Japan', 'continent_id' => '5', 'code' => 'JP'], |
||
159 | ['id' => '136', 'name' => 'Jordan', 'continent_id' => '5', 'code' => 'JO'], |
||
160 | ['id' => '137', 'name' => 'Kazakhstan', 'continent_id' => '5', 'code' => 'KZ'], |
||
161 | ['id' => '138', 'name' => 'Kuwait', 'continent_id' => '5', 'code' => 'KW'], |
||
162 | ['id' => '139', 'name' => 'Kyrgyzstan', 'continent_id' => '5', 'code' => 'KG'], |
||
163 | ['id' => '140', 'name' => 'Laos', 'continent_id' => '5', 'code' => 'LA'], |
||
164 | ['id' => '141', 'name' => 'Lebanon', 'continent_id' => '5', 'code' => 'LB'], |
||
165 | ['id' => '142', 'name' => 'Macau SAR China', 'continent_id' => '5', 'code' => 'MO'], |
||
166 | ['id' => '143', 'name' => 'Malaysia', 'continent_id' => '5', 'code' => 'MY'], |
||
167 | ['id' => '144', 'name' => 'Maldives', 'continent_id' => '5', 'code' => 'MV'], |
||
168 | ['id' => '145', 'name' => 'Mongolia', 'continent_id' => '5', 'code' => 'MN'], |
||
169 | ['id' => '146', 'name' => 'Myanmar Burma', 'continent_id' => '5', 'code' => 'MM'], |
||
170 | ['id' => '147', 'name' => 'Nepal', 'continent_id' => '5', 'code' => 'NP'], |
||
171 | ['id' => '148', 'name' => 'Neutral Zone', 'continent_id' => '5', 'code' => 'NT'], |
||
172 | ['id' => '149', 'name' => 'North Korea', 'continent_id' => '5', 'code' => 'KP'], |
||
173 | ['id' => '150', 'name' => 'Oman', 'continent_id' => '5', 'code' => 'OM'], |
||
174 | ['id' => '151', 'name' => 'Pakistan', 'continent_id' => '5', 'code' => 'PK'], |
||
175 | ['id' => '152', 'name' => 'Palestinian Territories', 'continent_id' => '5', 'code' => 'PS'], |
||
176 | ['id' => '153', 'name' => 'People s Democratic Republic of Yemen', 'continent_id' => '5', 'code' => 'YD'], |
||
177 | ['id' => '154', 'name' => 'Philippines', 'continent_id' => '5', 'code' => 'PH'], |
||
178 | ['id' => '155', 'name' => 'Qatar', 'continent_id' => '5', 'code' => 'QA'], |
||
179 | ['id' => '156', 'name' => 'Saudi Arabia', 'continent_id' => '5', 'code' => 'SA'], |
||
180 | ['id' => '157', 'name' => 'Singapore', 'continent_id' => '5', 'code' => 'SG'], |
||
181 | ['id' => '158', 'name' => 'South Korea', 'continent_id' => '5', 'code' => 'KR'], |
||
182 | ['id' => '159', 'name' => 'Sri Lanka', 'continent_id' => '5', 'code' => 'LK'], |
||
183 | ['id' => '160', 'name' => 'Syria', 'continent_id' => '5', 'code' => 'SY'], |
||
184 | ['id' => '161', 'name' => 'Taiwan', 'continent_id' => '5', 'code' => 'TW'], |
||
185 | ['id' => '162', 'name' => 'Tajikistan', 'continent_id' => '5', 'code' => 'TJ'], |
||
186 | ['id' => '163', 'name' => 'Thailand', 'continent_id' => '5', 'code' => 'TH'], |
||
187 | ['id' => '164', 'name' => 'Timor Leste', 'continent_id' => '5', 'code' => 'TL'], |
||
188 | ['id' => '165', 'name' => 'Turkey', 'continent_id' => '5', 'code' => 'TR'], |
||
189 | ['id' => '166', 'name' => 'Turkmenistan', 'continent_id' => '5', 'code' => 'TM'], |
||
190 | ['id' => '167', 'name' => 'United Arab Emirates', 'continent_id' => '5', 'code' => 'AE'], |
||
191 | ['id' => '168', 'name' => 'Uzbekistan', 'continent_id' => '5', 'code' => 'UZ'], |
||
192 | ['id' => '169', 'name' => 'Vietnam', 'continent_id' => '5', 'code' => 'VN'], |
||
193 | ['id' => '170', 'name' => 'Yemen', 'continent_id' => '5', 'code' => 'YE'], |
||
194 | ['id' => '171', 'name' => 'Albania', 'continent_id' => '6', 'code' => 'AL'], |
||
195 | ['id' => '172', 'name' => 'Andorra', 'continent_id' => '6', 'code' => 'AD'], |
||
196 | ['id' => '173', 'name' => 'Austria', 'continent_id' => '6', 'code' => 'AT'], |
||
197 | ['id' => '174', 'name' => 'Belarus', 'continent_id' => '6', 'code' => 'BY'], |
||
198 | ['id' => '175', 'name' => 'Belgium', 'continent_id' => '6', 'code' => 'BE'], |
||
199 | ['id' => '176', 'name' => 'Bosnia and Herzegovina', 'continent_id' => '6', 'code' => 'BA'], |
||
200 | ['id' => '177', 'name' => 'Bulgaria', 'continent_id' => '6', 'code' => 'BG'], |
||
201 | ['id' => '178', 'name' => 'Croatia', 'continent_id' => '6', 'code' => 'HR'], |
||
202 | ['id' => '179', 'name' => 'South Georgia and the South Sandwich Isl', 'continent_id' => '4', 'code' => 'GS'], |
||
203 | ['id' => '180', 'name' => 'Czech Republic', 'continent_id' => '6', 'code' => 'CZ'], |
||
204 | ['id' => '181', 'name' => 'Denmark', 'continent_id' => '6', 'code' => 'DK'], |
||
205 | ['id' => '182', 'name' => 'Estonia', 'continent_id' => '6', 'code' => 'EE'], |
||
206 | ['id' => '183', 'name' => 'Faroe Islands', 'continent_id' => '6', 'code' => 'FO'], |
||
207 | ['id' => '184', 'name' => 'Finland', 'continent_id' => '6', 'code' => 'FI'], |
||
208 | ['id' => '185', 'name' => 'France', 'continent_id' => '6', 'code' => 'FR'], |
||
209 | ['id' => '186', 'name' => 'Germany', 'continent_id' => '6', 'code' => 'DE'], |
||
210 | ['id' => '187', 'name' => 'Gibraltar', 'continent_id' => '6', 'code' => 'GI'], |
||
211 | ['id' => '188', 'name' => 'Greece', 'continent_id' => '6', 'code' => 'GR'], |
||
212 | ['id' => '189', 'name' => 'Guernsey', 'continent_id' => '6', 'code' => 'GG'], |
||
213 | ['id' => '190', 'name' => 'Hungary', 'continent_id' => '6', 'code' => 'HU'], |
||
214 | ['id' => '191', 'name' => 'Iceland', 'continent_id' => '6', 'code' => 'IS'], |
||
215 | ['id' => '192', 'name' => 'Ireland', 'continent_id' => '6', 'code' => 'IE'], |
||
216 | ['id' => '193', 'name' => 'Isle of Man', 'continent_id' => '6', 'code' => 'IM'], |
||
217 | ['id' => '195', 'name' => 'Jersey', 'continent_id' => '6', 'code' => 'JE'], |
||
218 | ['id' => '196', 'name' => 'Latvia', 'continent_id' => '6', 'code' => 'LV'], |
||
219 | ['id' => '197', 'name' => 'Liechtenstein', 'continent_id' => '6', 'code' => 'LI'], |
||
220 | ['id' => '198', 'name' => 'Lithuania', 'continent_id' => '6', 'code' => 'LT'], |
||
221 | ['id' => '199', 'name' => 'Luxembourg', 'continent_id' => '6', 'code' => 'LU'], |
||
222 | ['id' => '200', 'name' => 'Macedonia', 'continent_id' => '6', 'code' => 'MK'], |
||
223 | ['id' => '201', 'name' => 'Malta', 'continent_id' => '6', 'code' => 'MT'], |
||
224 | ['id' => '202', 'name' => 'Metropolitan France', 'continent_id' => '6', 'code' => 'FX'], |
||
225 | ['id' => '203', 'name' => 'Moldova', 'continent_id' => '6', 'code' => 'MD'], |
||
226 | ['id' => '204', 'name' => 'Monaco', 'continent_id' => '6', 'code' => 'MC'], |
||
227 | ['id' => '205', 'name' => 'Montenegro', 'continent_id' => '6', 'code' => 'ME'], |
||
228 | ['id' => '206', 'name' => 'Netherlands', 'continent_id' => '6', 'code' => 'NL'], |
||
229 | ['id' => '207', 'name' => 'Norway', 'continent_id' => '6', 'code' => 'NO'], |
||
230 | ['id' => '208', 'name' => 'Poland', 'continent_id' => '6', 'code' => 'PL'], |
||
231 | ['id' => '209', 'name' => 'Portugal', 'continent_id' => '6', 'code' => 'PT'], |
||
232 | ['id' => '210', 'name' => 'Romania', 'continent_id' => '6', 'code' => 'RO'], |
||
233 | ['id' => '211', 'name' => 'Russia', 'continent_id' => '6', 'code' => 'RU'], |
||
234 | ['id' => '212', 'name' => 'San Marino', 'continent_id' => '6', 'code' => 'SM'], |
||
235 | ['id' => '213', 'name' => 'Serbia', 'continent_id' => '6', 'code' => 'RS'], |
||
236 | ['id' => '214', 'name' => 'Serbia and Montenegro', 'continent_id' => '6', 'code' => 'CS'], |
||
237 | ['id' => '215', 'name' => 'Slovakia', 'continent_id' => '6', 'code' => 'SK'], |
||
238 | ['id' => '216', 'name' => 'Slovenia', 'continent_id' => '6', 'code' => 'SI'], |
||
239 | ['id' => '217', 'name' => 'Spain', 'continent_id' => '6', 'code' => 'ES'], |
||
240 | ['id' => '218', 'name' => 'Svalbard and Jan Mayen', 'continent_id' => '6', 'code' => 'SJ'], |
||
241 | ['id' => '219', 'name' => 'Sweden', 'continent_id' => '6', 'code' => 'SE'], |
||
242 | ['id' => '220', 'name' => 'Switzerland', 'continent_id' => '6', 'code' => 'CH'], |
||
243 | ['id' => '221', 'name' => 'Ukraine', 'continent_id' => '6', 'code' => 'UA'], |
||
244 | ['id' => '222', 'name' => 'Union of Soviet Socialist Republics', 'continent_id' => '6', 'code' => 'SU'], |
||
245 | ['id' => '223', 'name' => 'United Kingdom', 'continent_id' => '6', 'code' => 'GB'], |
||
246 | ['id' => '224', 'name' => 'Vatican City', 'continent_id' => '6', 'code' => 'VA'], |
||
247 | ['id' => '225', 'name' => 'Aland Islands', 'continent_id' => '6', 'code' => 'AX'], |
||
248 | ['id' => '226', 'name' => 'American Samoa', 'continent_id' => '4', 'code' => 'AS'], |
||
249 | ['id' => '227', 'name' => 'Antarctica', 'continent_id' => '4', 'code' => 'AQ'], |
||
250 | ['id' => '228', 'name' => 'Australia', 'continent_id' => '4', 'code' => 'AU'], |
||
251 | ['id' => '229', 'name' => 'Bouvet Island', 'continent_id' => '4', 'code' => 'BV'], |
||
252 | ['id' => '230', 'name' => 'British Indian Ocean Territory', 'continent_id' => '4', 'code' => 'IO'], |
||
253 | ['id' => '231', 'name' => 'Christmas Island', 'continent_id' => '4', 'code' => 'CX'], |
||
254 | ['id' => '232', 'name' => 'Cocos Keeling Islands', 'continent_id' => '4', 'code' => 'CC'], |
||
255 | ['id' => '234', 'name' => 'Cook Islands', 'continent_id' => '4', 'code' => 'CK'], |
||
256 | ['id' => '235', 'name' => 'Fiji', 'continent_id' => '4', 'code' => 'FJ'], |
||
257 | ['id' => '236', 'name' => 'French Polynesia', 'continent_id' => '4', 'code' => 'PF'], |
||
258 | ['id' => '237', 'name' => 'French Southern Territories', 'continent_id' => '4', 'code' => 'TF'], |
||
259 | ['id' => '238', 'name' => 'Guam', 'continent_id' => '4', 'code' => 'GU'], |
||
260 | ['id' => '239', 'name' => 'Heard Island and McDonald Islands', 'continent_id' => '4', 'code' => 'HM'], |
||
261 | ['id' => '240', 'name' => 'Kiribati', 'continent_id' => '4', 'code' => 'KI'], |
||
262 | ['id' => '241', 'name' => 'Marshall Islands', 'continent_id' => '4', 'code' => 'MH'], |
||
263 | ['id' => '242', 'name' => 'Micronesia', 'continent_id' => '4', 'code' => 'FM'], |
||
264 | ['id' => '243', 'name' => 'Nauru', 'continent_id' => '4', 'code' => 'NR'], |
||
265 | ['id' => '244', 'name' => 'New Caledonia', 'continent_id' => '4', 'code' => 'NC'], |
||
266 | ['id' => '245', 'name' => 'New Zealand', 'continent_id' => '4', 'code' => 'NZ'], |
||
267 | ['id' => '246', 'name' => 'Niue', 'continent_id' => '4', 'code' => 'NU'], |
||
268 | ['id' => '247', 'name' => 'Norfolk Island', 'continent_id' => '4', 'code' => 'NF'], |
||
269 | ['id' => '248', 'name' => 'Northern Mariana Islands', 'continent_id' => '4', 'code' => 'MP'], |
||
270 | ['id' => '249', 'name' => 'Palau', 'continent_id' => '4', 'code' => 'PW'], |
||
271 | ['id' => '250', 'name' => 'Papua New Guinea', 'continent_id' => '4', 'code' => 'PG'], |
||
272 | ['id' => '251', 'name' => 'Pitcairn Islands', 'continent_id' => '4', 'code' => 'PN'], |
||
273 | ['id' => '252', 'name' => 'Samoa', 'continent_id' => '4', 'code' => 'WS'], |
||
274 | ['id' => '253', 'name' => 'Solomon Islands', 'continent_id' => '4', 'code' => 'SB'], |
||
275 | ]; |
||
276 | |||
277 | //dump($countries); |
||
278 | foreach ($countries as $key => $country) { |
||
279 | DB::table('countries')->insert([ |
||
280 | 'id' => $country['id'], |
||
281 | 'name' => $country['name'], |
||
282 | 'continent_id' => $country['continent_id'], |
||
283 | 'code' => $country['code'], |
||
284 | ]); |
||
288 |