{"id":47651,"date":"2020-01-11T03:01:45","date_gmt":"2020-01-10T17:01:45","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=47651"},"modified":"2020-01-10T13:35:52","modified_gmt":"2020-01-10T03:35:52","slug":"php-worldbank-growth-of-merchandise-trade-emoji-flags-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/php-worldbank-growth-of-merchandise-trade-emoji-flags-tutorial\/","title":{"rendered":"PHP Worldbank Growth of Merchandise Trade Emoji Flags Tutorial"},"content":{"rendered":"
\"PHP<\/a>

PHP Worldbank Growth of Merchandise Trade Emoji Flags Tutorial<\/p><\/div>\n

With Internationalization thoughts fresh in the mind, we decided to revisit PHP Worldbank Growth of Merchandise Trade Tutorial<\/a>‘s Country by Country “Growth of Merchandise Trade” Bubble Chart to see what we now know more about to improve this web application.<\/p>\n

And so we wondered whether we could enhance with Emoji Flags. Sounds reasonable, but when we’ve done this in the recent past (eg. Window LocalStorage Client Versus Server Map Tutorial<\/a>) it’s been with Javascript clientside logic, not PHP serverside code, as is the go with our Google Chart<\/a> Bubble Chart<\/a> interfacing. Well, here’s our approach (making global $flagentity variable filled in with Emoji Flag content as found) here …<\/p>\n

<?php
\n
\n$flagentity=\"\"; \/\/ global here and two below
\n$lri=[\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\",\"H\",\"I\",\"J\",\"K\",\"L\",\"M\",\"N\",\"O\",\"P\",\"Q\",\"R\",\"S\",\"T\",\"U\",\"V\",\"W\",\"X\",\"Y\",\"Z\"];
\n$dri=[\"U+1F1E6\",\"U+1F1E7\",\"U+1F1E8\",\"U+1F1E9\",\"U+1F1EA\",\"U+1F1EB\",\"U+1F1EC\",\"U+1F1ED\",\"U+1F1EE\",\"U+1F1EF\",\"U+1F1F0\",\"U+1F1F1\",\"U+1F1F2\",\"U+1F1F3\",\"U+1F1F4\",\"U+1F1F5\",\"U+1F1F6\",\"U+1F1F7\",\"U+1F1F8\",\"U+1F1F9\",\"U+1F1FA\",\"U+1F1FB\",\"U+1F1FC\",\"U+1F1FD\",\"U+1F1FE\",\"U+1F1FF\"];
\n$iso_country_codes=['AF','Afghanistan',
\n'AX','Aland Islands',
\n'AL','Albania',
\n'DZ','Algeria',
\n'AS','American Samoa',
\n'AD','Andorra', ... ]; \/\/ global ... not all shown
\n
\nfunction uvaltosfcp($string) { \/\/ thanks to https:\/\/stackoverflow.com\/questions\/1805802\/php-convert-unicode-codepoint-to-utf-8<\/a>
\n return html_entity_decode<\/a>(preg_replace(\"\/U\\+([0-9A-F]{5})\/\", \"&#x\\\\1;\", $string), ENT_NOQUOTES, 'UTF-8');
\n}
\n
\nfunction flagflag($inctryname) {
\n global $flagentity, $iso_country_codes, $lri, $dri;
\n $uretv=\"\";
\n $flagentity=\"\";
\n if ($inctryname != \"\") {
\n $matchfound=false;
\n for ($im=1; $im<sizeof($iso_country_codes); $im+=2) {
\n if (strpos(strtolower($iso_country_codes[$im]), strtolower($inctryname)) !== false) {
\n for ($jm=0; $jm<sizeof($lri); $jm++) {
\n if (strtoupper(substr($iso_country_codes[-1 + $im],0,1)) == $lri[$jm]) {
\n $uretv.=$dri[$jm]; \/\/uvaltosfcp($dri[$jm]);
\n $matchfound=true;
\n }
\n }
\n for ($jm=0; $jm<sizeof($lri); $jm++) {
\n if (strtoupper(substr($iso_country_codes[-1 + $im],1,1)) == $lri[$jm]) {
\n $uretv.=$dri[$jm]; \/\/uvaltosfcp($dri[$jm]);
\n }
\n }
\n $flagentity=uvaltosfcp($uretv); \/\/$uretv;
\n return $inctryname;
\n }
\n }
\n if ($uretv == \"\" && !$matchfound) {
\n for ($im=1; $im<sizeof($iso_country_codes); $im+=2) {
\n if (strpos(explode(\",\",strtolower($iso_country_codes[$im]))[0], explode(\",\",strtolower($inctryname))[0]) !== false) {
\n for ($jm=0; $jm<sizeof($lri); $jm++) {
\n if (strtoupper(substr($iso_country_codes[-1 + $im],0,1)) == $lri[$jm]) {
\n $uretv.=$dri[$jm]; \/\/uvaltosfcp($dri[$jm]);
\n $matchfound=true;
\n }
\n }
\n for ($jm=0; $jm<sizeof($lri); $jm++) {
\n if (strtoupper(substr($iso_country_codes[-1 + $im],1,1)) == $lri[$jm]) {
\n $uretv.=$dri[$jm]; \/\/uvaltosfcp($dri[$jm]);
\n }
\n }
\n $flagentity=uvaltosfcp($uretv); \/\/$uretv;
\n return $inctryname;
\n }
\n }
\n }
\n }
\n return $inctryname;
\n}
\n<\/code>
\n?><\/p>\n

Another “peer integration” issue today too. The resource we’d like to thank regarding today’s work, that being Growth of Merchandise Trade<\/a> has updated its data set for the year range 2006-2016 and we’d like to maintain this, and the previous 2003-2013 data set, for comparison purposes. The Bubble Chart report is the important thing though, and so a select (dropdown) element, probably “below the fold” for you, facilitates this expansion of functionality.<\/p>\n

To try the “how we got there”<\/a> growth_of_merchandise_trade_2006_2016.php<\/a> you can click\/touch this live run<\/a> link.<\/p>\n

\n

\n

Previous relevant PHP Worldbank Growth of Merchandise Trade Tutorial<\/a> is shown below.<\/p>\n

\"PHP<\/a>

PHP Worldbank Growth of Merchandise Trade Tutorial<\/p><\/div>\n

We’ve said it before, and (no doubt) we’ll say it again … there are great public data sources out there for you to explore.<\/p>\n

As far as international data goes the Worldbank<\/a> series of statistics is great, so, thanks.<\/p>\n

Today we combine the Worldbank data for Growth of Merchandise Trade 2003-2013<\/a> with the wonderful Google Chart<\/a> Bubble Chart to create (52 = (first letters of country name) 26 x 2 (concepts: Exports and Imports)) reporting charts of interest, we hope. Again, as with any reporting subject, it is a personal thing, whether the subject matter of a report is of interest, but you could say that about so many things in life.<\/p>\n

So, we offer some PHP source code you could call growth_of_merchandise_trade.php<\/a> and a live run<\/a> link as well, the full loading of which requires patience.<\/p>\n

Stop Press<\/i><\/b><\/p>\n

Tomorrow we go over what was needed to change PHP code above to be more mobile friendly …<\/p>\n

\n