Analytics detect adblock

https://marthijnhoiting.com/track-the-use-of-adblock-in-google-analytics/#

Analytics fiksavimas ajax veiksmu - mazinimas bounce rate

https://davidwalsh.name/analytics-bounce-rate

FULL ajax page seo

https://developers.google.com/webmasters/ajax-crawling/docs/specification

naudokite www.tavosaitas.lt/#!/paris   url strukturas, o google puslapi matys kaip
www.tavosaitas.lt?_escaped_fragment_=paris

Apache log analyzer

Puiki nemokama programa analizuoti WEB LOG'ams: http://www.apacheviewer.com/

Mysql Backup via CMD / cron

Visu failu backup i viena faila sugzipinta, su datos reiksme
mysqldump -u username -pPASWORDAS --opt --all-databases | gzip >   DailyDB_`date '+%Y-%m-%d_%T'`.sql.gz

Arba skriptas - backupu darymas i atskirus failus pagal duombazes

#!/bin/bash

USER="dfdsf"
PASSWORD="sdfdsf"
OUTPUT="/path/to/dir/"

databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump -u $USER -p$PASSWORD --databases $db  | gzip > $OUTPUT/$db._`date '+%Y-%m-%d_%T'`.sql.gz
    fi
done

 you save the code in file backup.sh $ chmod +x

PHP text spinner / thesaurus

Thesaurus (anglų k. leksikinis sinonimų žodynas) mysql duombazė: https://code.google.com/p/moby-thesaurus/

Vienas geresnių spinner API http://script4.prothemes.biz/

PDO Database Class

https://github.com/indieteq/PHP-MySQL-PDO-Database-Class/blob/master/README.md
PDO multi prepare (insert multiple rows with single query): https://www.daniweb.com/programming/web-development/code/495371/insert-multiple-records-with-pdo-prepared-statement

https://code.tutsplus.com/tutorials/php-database-access-are-you-doing-it-correctly--net-25338