Blog del sito MyDigitalia - Usare il Pc seriamente.
Non disdegnate di sbirciare anche la pagina di Facebook

giovedì 14 novembre 2019

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in

A possible reason is a lack of ' after SELECT from: i.g. "SELECT * from bibliografie__Taylor" could be wrong, try with SELECT * from `bibliografie__Taylor`.

msql order by several fields

You can separe the fields by a comma: .g. "ORDER by author, date"

symlinks on linux decoder

You need to have a relative (like "../../folder/file" or "folder/folder/file"), not an absolute one /(like "/mnt/your-path/file"): this latter indeed is effectual only in your computer, not on decoder.

mercoledì 13 novembre 2019

set links as not visited

You must clear not the cache or cookies, but the browser history.

sabato 26 ottobre 2019

whatsapp web e social: a capo senza inviare

se premete enter vi parte il messaggio. Per andare a capo continuando a scrivere un messaggio: shift+enter

venerdì 25 ottobre 2019

convert an ics file (exported from google calendar) as textual diary


  • sudo apt install python3-pip
  • pip3 install ics 
  • create the bash executable file, like this
#!/bin/bash
wget -O diario.ics https://calendar.google.com/calendar/ical/[remote path]/basic.ics
python3 convert-ics.py > /home/[local path]/local-file.md

See also here.


giovedì 24 ottobre 2019

embed database data in odt file

 the problem

In odt it is possible to insert some database data as fields in a odt file, but when you change data in phpmyadmin I get
1) a correct update in the data source view above the text,
2) not in the odt file (body: where are the fields): the fields texts remain unchanged, even after doing the command "update fields" (both from menu and from keyboard: F9, or shift+ctrl+F9).

a solution

A workaround is to use insert - section to insert a part of a php file via localhost.
  1. you will see in your odt file the content of the (section=div, of the) php file, as in the picture following:
    image description
  2. insert -> section -> link -> file name "http://localhost/[path]/[filename].php" -> section (the "id" name you have chosen in php file, i.g. inserting a <div id="biblio">[php/mysql code]</div> the section name will "biblio")
Of course, you must previously
  • activate a php/mysql server in local
  • and possibly have some knowledge of html/php source code.

Translate

Archivio blog