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

jQuery perdavima x-auth-token

$.ajax({
   url : myurl,
   headers: {
        'X-Auth-Token' : token
   });

PHP / ajax apsauga, su kintamu raktu ir laiko žyma

$time = time();
$hash = md5($key . $time);
$url =  "http://domain.com/iframe?hash=$hash&time=$time";

On the other side you should first check if the timestamp is in the limits (e.g. not older than five minutes) and than rehash with the key and the submitted timestamp. If you get the same hash the request is valid.