Home‎ > ‎

blog

php mysql ajax

posted 17 Sept 2010, 06:19 by Andreas Jostel

xml into mysql (e.g. pubmed)

posted 17 Sept 2010, 05:55 by Andreas Jostel

EDICT sql

posted 16 Sept 2010, 16:06 by Andreas Jostel

Securing Apache

posted 16 Sept 2010, 11:18 by Andreas Jostel   [ updated 16 Sept 2010, 13:44 ]


Speed tie shoe laces etc.

posted 16 Sept 2010, 02:31 by Andreas Jostel

Simplify your life:

Ubuntu Backup to DVD

posted 12 Sept 2010, 04:17 by Andreas Jostel   [ updated 19 Sept 2010, 06:57 ]

Update: Burn DVD from command line

wodim -vv /dev/dvdrw blank=all // Write Optical DIsk Medium
growisofs -[Z|M] /dev/dvdrw [-R] [-J] /some/files 

Instructions

sudo apt-get install dvd+rw-tools
to find dvd burner:
less /etc/fstab
burning instructions (may omit character set):
growisofs -dvd-compat -input-charset=ISO-8859-1 -Z /dev/hdd -R -J -pad "/path/to/some/data"
-dvd-compat: max compatibility with DVD-ROM/-Video (i.e. close with lead out)
-Z /dev/hdd: burn initial session to selected device

Folder size

du ~ -h | grep Pictures$
= disk usage of '~' in '-h'umanly readable format, filtered for the 'Pictures' folder

LAMP server setup

posted 11 Sept 2010, 07:53 by Andreas Jostel   [ updated 11 Sept 2010, 11:00 ]

3D pavement drawings

posted 10 Sept 2010, 05:23 by Andreas Jostel

SQL TimeDiff Average

posted 7 Sept 2010, 12:59 by Andreas Jostel

select
col1,
avg(timestampdiff(SECOND, startTimestamp, endTimestamp)) as avgdiff
from
table
group by col1

Pure CSS tooltips

posted 6 Sept 2010, 15:16 by Andreas Jostel

a.info{ position:relative; /*this is the key*/}
a.info:hover{background-color:#ff0}
a.info span{display: none}
a.info:hover span{ /*the span will display just on :hover state*/
    display:block;
    z-index:999;
    position:absolute;
    top:20px; left:20px; width:150px;
    border:1px solid #0cf;
    background-color:#cff;
    color:#000;
    text-align: center}

1-10 of 29