Author Archives: gherardobertini

GooglePlay – ExpManager – Trick to transfer backup

Unfortunately the develore of this app ExpManager has quit to support it. I was in trouble when I wanted to tranfer my data to new my smartphone. I found a trick. I suppose you have the APP in both smartphones … Continue reading

Posted in Uncategorized | Leave a comment

Symfony Doctrine Concurrency

I used Optimistic-Locking here you can find the documentation: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/transactions-and-concurrency.html You can add in your entity the field version. Automatically doctrine will manage concurrency throwing an Exceprion. use Doctrine\ORM\Mapping as ORM; … /** * @var int * * @ORM\Column(name=”version”, type=”integer”, … Continue reading

Posted in Symfony | Tagged , , | Leave a comment

This is my solution to avoid constraint violation when you use Soft Delete Here is an interesting article that explain how unique index are treated by DB https://mariadb.com/kb/en/mariadb/getting-started-with-indexes/ The field deletedAt as Datetime with NULL value can’t be part of … Continue reading

Posted on by gherardobertini | Leave a comment

SQL Access Equivalent MySQL Limit X, Y

In MySQL for paging a query we use SELECT * FROM {table} LIMIT X, Y In Access there is only SELECT TOP Y * FROM {table} to select first Y records of a query We can use this trick: First … Continue reading

Posted in Access, PHP, SQL | Tagged , , , , | Leave a comment

HTML JQuery – transform Inputbox into dropdown list (combobox)

Transform input textbox in combobox using JQuery and hide click out Demo

Posted in JQuery | Tagged , , | Leave a comment