Wojtek - Strona 4 - Kody, triki, sztuczki

20 maj 2016

Formatowanie daty w mysql

SELECT
  e.name,
  DATE_FORMAT(FROM_UNIXTIME(start_time), '%Y-%d-%m') as start_date_format,
  DATE_FORMAT(FROM_UNIXTIME(start_time), '%H:%i:%S') as start_time_format,
  DATE_FORMAT(FROM_UNIXTIME(end_time), '%H:%i:%S') as end_time_format,
  TIMESTAMPDIFF(
    MINUTE,
    FROM_UNIXTIME(start_time),
    FROM_UNIXTIME(end_time)
  ) as diff_time_minutes_format,
  e.room_name,
  e.start_time,
  e.end_time,
WHERE
  e.room_id = r.id
  AND DATE_FORMAT(FROM_UNIXTIME(e.start_time), '%Y-%m-%d') <= '2016-05-23'
  AND DATE_FORMAT(FROM_UNIXTIME(e.end_time), '%Y-%m-%d') >= '2016-05-19'
  AND e.name in ('misiek')
ORDER BY
  e.start_time

6 maj 2016

Wykorzystanie funkcji array_map do trimowania elementów tabeli

if (!empty($users)) {
$users_tmp=explode(',',trim($users));
$users_tmp=array_map('trim',$users_tmp);
$sql .= " AND u.u_name in ('".implode("','", $users_tmp)."')";
}

5 maj 2016

Obsługa zadań w systemie Windows

SCHTASKS /Create /SC MINUTE /MO 30 /TN rachunek /TR calc.exe 
/ST 09:00 /ET 16:00 /SD 19/04/2016 /ED 06/06/2016 

SCHTASKS /Query /TN rachunek

SCHTASKS /Run /TN rachunek

SCHTASKS /End  /TN rachunek

SCHTASKS /Delete  /TN rachunek

27 kwi 2016

Wyśrodkowanie tabeli z danymi do rozmiaru okna

$(window).resize(function() {
var winW = $(window).width();
var conW = parseInt($('#container').css('width'));
var tabW = parseInt($('table.list').css('width'));

if(winW>conW) {
var margin_left = -((tabW - conW)/2)-10;
$('table.list').css({'margin-left':margin_left});
} else {
$('table.list').css({'margin-left':0});
}
});
$(window).resize();

Tabelka normalna:

Tabelka wyśrodkowana:

27 kwi 2016

Ustawienie prostego cookie w php

if(!isset($_COOKIE['uzytkownik'])) {
  echo 'Witaj!';
  setcookie('uzytkownik', 1, time()+60*60*24*30);
}
else {
  echo 'Witaj ponownie!';
}