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

php date interval

$dates = array_map(function($dt) { return $dt->format('Y-m');}, iterator_to_array(new DatePeriod(new DateTime(date('Y-m-01')), DateInterval::createFromDateString('-1 month'), 12)));

php facebook login

http://metah.ch/blog/2014/05/facebook-sdk-4-0-0-for-php-a-working-sample-to-get-started/

SQL join`inimas po vieną naujausią eulutę

SELECT c.*, p1.*
FROM customer c
JOIN purchase p1 ON (c.id = p1.customer_id)
LEFT OUTER JOIN purchase p2 ON (c.id = p2.customer_id AND 
    (p1.date < p2.date OR p1.date = p2.date AND p1.id < p2.id))
WHERE p2.id IS NULL;

source: http://stackoverflow.com/questions/2111384/sql-join-selecting-the-last-records-in-a-one-to-many-relationship