Autore: duns

Pubblicato il

center divs horizontally

In my website I have three (main) divs: the actually main one and two small laterals ads divs (at left and at right of the main one). I noticed that the lateral divs weren’t at the middle of the free (lateral) space, in big screens.

1. The solution was use the flexbox, with this code in the parent div: 

display:flex; justify-content: space-around;

2. But a problem was the fact that these divs have a position:fixed propriety, that is incompatible with flex.

Therfore I was suggested to use position:sticky instead of position:fixed, and it worked.

3.A last problem was that after this change, clicking anything in my page there was a sort od “dance” of all the element within the window. This was solved creating a parent div of my three (main) divs, so that not body, but this new div is the parent.

Pubblicato il

true phone: the best android phone app

True Phone in my opinion is the best phone app: indeed without unnecessary special effects, it offers a remarkable range of features, including choosing the address books.

As an example, you can set davx (/nextcloud) as the main address book, instead of the google one.
Or you can view groups of contacts – which almost no other app does.

Obviously, you can set customized ringtone and sounds. Or easily modify contacts.

But there a lots of interesting features. It is undoubtedly worth trying.

Pubblicato il

how split a mkv with subtitles

You can use mkvtoolnix, then go to -> output, and -> splitting -> by parts based on timestamps -> and there you can write the beginning and the end of the part you want extract (without spaces: like 1:02:07-1:04:40, for example).

Pubblicato il

show “alt” attribute after an image

You can use a javascript, like this

<script type="text/javascript">
// img[style]').each(function(){
       $el = $(this);
       var style = $el.attr('style');
       $el.attr('style','');
       $el.parent().attr('style',style);
    }); //Moves the inline styles

      $("img").each(function(){
          var title = this.alt;
          $(this).after(''+ title +'');
      }); //Adds the dynamic captions.
 });
 //]]>
</script>

Pubblicato il

mysql convert a column to utf-8

You can use this mysql query code:

ALTER TABLE yourtable MODIFY
    yourcol VARCHAR(255)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

There are more problems with ENUM and SET type fields.

For ENUM you have to specify all the field values, no matter how many they are

ALTER TABLE yourtable MODIFY
    yourcol ENUM('val1','val2',etc)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

For SET the problems rise from the name SET, so you have to do this command

ALTER TABLE yourtable MODIFY
    yourcol CHAR(255)
      CHARACTER SET utf8
      COLLATE utf8_general_ci;

You will be able afterwards to modify CHAR to SET (with your previous values) without losing your data.