PHP Archives - Kartolo's notes

GeoIP2 is not updated in Matomo

cron error update Maxmind GeoIP2 database

Over the new year I got a PHP error from my Matomo crontask regarding GeoIP2 database from Maxmind. The error message is:

GeoIP2AutoUpdater: failed to download 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz'
curl_exec: Could not resolve host: geolite.maxmind.com. Hostname requested was: geolite.maxmind.com

1 2	GeoIP2AutoUpdater: failed to download 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz' curl_exec: Could not resolve host: geolite.maxmind.com. Hostname requested was: geolite.maxmind.com

After short time googling, I found out that Maxmind doesn’t allow anonymous download of their free GeoIP2 databases because of a California Consumer Privacy Act (CCPA). See source

Search for string part per TypoScript

To search a string part (needle) in string (haystack), you can easily use the PHP strpos function. But this function doesn’t exist in TypoScript.

The following TypoScript return true if the needle is found in the haystack. This can be used in an if condition.

cObject = COA
cObject {
  1 = LOAD_REGISTER
  1 {
    # search for http (or https).
    needle = http

    # search in
    haystack.field = header_link

    # split haystack by the needle
    # result is a haystack without a needle, if found
    findNeedleInHaystack.cObject = TEXT
    findNeedleInHaystack.cObject {
      data = REGISTER:haystack
      split.token.data = REGISTER:needle
    }
  }

  # compare REGISTER:haystack and result of REGISTER:findNeedleInHaystack
  # if both are the same, nothing was found
  10 = TEXT
  10 {
    # true will be returned, if the needle was found inside haystack
    value = true

    if {
      value.data = REGISTER:haystack
      equals.data = REGISTER:findNeedleInHaystack

      # if the same, then negate the return value
      negate = 1
    }
  }
}

cObject = COA

cObject {

1 = LOAD_REGISTER

1 {

# search for http (or https).

needle = http

# search in

haystack.field = header_link

# split haystack by the needle

# result is a haystack without a needle, if found

findNeedleInHaystack.cObject = TEXT

findNeedleInHaystack.cObject {

data = REGISTER:haystack

split.token.data = REGISTER:needle

}

# compare REGISTER:haystack and result of REGISTER:findNeedleInHaystack

# if both are the same, nothing was found

10 = TEXT

10 {

# true will be returned, if the needle was found inside haystack

value = true

if {

value.data = REGISTER:haystack

equals.data = REGISTER:findNeedleInHaystack

# if the same, then negate the return value

negate = 1

}

The above COA will return true if http is found in the header_link field. I used this to add ATagParams for external link, in assumption that link with http(s) is an external link.

ATagParams = class="external"
ATagParams.if {
  cObject = COA
  cObject {
    // the strpos function
  }
}

ATagParams = class="external"

ATagParams.if {

cObject = COA

cObject {

// the strpos function

}

Automatically apply PSR-2 coding style

*UPDATE*

In version 2 of php_cs_fixer some parameters and rules are renamed. Upgrade guide can be see on their Github page. This how-to is accordingly updated.

Applying PSR-2 coding style manually is really no fun and wasting time. A short visit in Github and there’s a tool which detects and fixes the coding style. The tool is called php-cs-fixer.

I’ll show you how to get the tool and use it to easily reformat all PHP file in project.

Continue reading Automatically apply PSR-2 coding style

Fail downloading file on Android

How hard is it, to write a PHP script to allow user to download a file? really easy, one would say. Just send the appropriate HTTP header and echo the file content.

<?php
  header('Content-type: application/force-download');
  header('Content-Disposition: attachment; filename="test.txt"');
  echo(file_get_content('/path/to/file'));
?>

<?php

header('Content-type: application/force-download');

header('Content-Disposition: attachment; filename="test.txt"');

echo(file_get_content('/path/to/file'));

Basically that’s all I need to force download per PHP. But somehow Android stock browser (Chrome) only downloads and creates a 0 kB file. Other browser (tested with Firefox on Android) saves the file correctly.

What does happen here?

Continue reading Fail downloading file on Android

Standalone view in extbase

Usually a view in extbase is always called from a controller. but what if, an action in your controller is called as an eID and only parts of the template needs to be rendered? Partial is an option, but I have a code snippet, which uses the

TYPO3\\CMS\\Fluid\\View\\StandaloneView

1	TYPO3\\CMS\\Fluid\\View\\StandaloneView

class.

Continue reading Standalone view in extbase

[PHP] Removing duplicate in an array… really fast

Let’s imagine you have a huge array, with say couple ten thousands of elements and you want to remove any duplicates entries in this array. As PHP programmer you’ll be thinking of array_unique. For a “small” sized array and one dimensional array this one does the trick.

I have some nice snippets which cover multi dimensional and/or huge sized array.

First: you have a huge, one dimensional array.

array_flip(array_flip(array_reverse($input,true)))

1	array_flip(array_flip(array_reverse($input,true)))

This one works only on one dimensional array. The key of the last element will be preserved and the keys are not sorted

Second: for a huge, multi dimensional array

function super_unique($array) {
  $result = array_map("unserialize", array_unique(array_map("serialize", $array)));
  foreach ($result as $key =&gt; $value) {
    if ( is_array($value) ) {
      $result[$key] = super_unique($value);
    }
  }
  return $result;
}

function super_unique($array) {

$result = array_map("unserialize", array_unique(array_map("serialize", $array)));

foreach ($result as $key => $value) {

if ( is_array($value) ) {

$result[$key] = super_unique($value);

}

return $result;

}

sources:

http://dk.php.net/manual/en/function.array-unique.php#97285
http://www.puremango.co.uk/2010/06/fast-php-array_unique-for-removing-duplicates/