9 mar 2010

Zmienne środowiskowe w PHP

[REDIRECT_nokeepalive] => 1
[REDIRECT_ssl-unclean-shutdown] => 1
[REDIRECT_downgrade-1_0] => 1
[REDIRECT_force-response-1_0] => 1
[REDIRECT_SCRIPT_URL] => /tag/gmap/
[REDIRECT_SCRIPT_URI] => http://kody.wig.pl/tag/gmap/
[REDIRECT_STATUS] => 200
[nokeepalive] => 1
[ssl-unclean-shutdown] => 1
[downgrade-1_0] => 1
[force-response-1_0] => 1
[SCRIPT_URL] => /tag/gmap/
[SCRIPT_URI] => http://kody.wig.pl/tag/gmap/
[HTTP_ACCEPT] => image/gif, ... */*
[HTTP_REFERER] => http://www.google.pl/search?hl=pl&q=kody+gmap
[HTTP_ACCEPT_LANGUAGE] => pl
[HTTP_UA_CPU] => x86
[HTTP_ACCEPT_ENCODING] => gzip, deflate
[HTTP_USER_AGENT] => Mozilla/4.0 (compatible; MSIE 7.0;)
[HTTP_HOST] => kody.wig.pl
[HTTP_CONNECTION] => Keep-Alive
[HTTP_COOKIE] => __utma=48955324.
[PATH] => /usr/local/bin:/usr/bin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache
[SERVER_NAME] => kody.wig.pl
[SERVER_ADDR] => 62.2.2.2
[SERVER_PORT] => 80
[REMOTE_ADDR] => 212.11.11.11
[DOCUMENT_ROOT] => /htdocs
[SERVER_ADMIN] => [no address given]
[SCRIPT_FILENAME] => /www/index.php
[REMOTE_PORT] => 53249
[REDIRECT_URL] => /tag/gmap/
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] => /tag/gmap/
[SCRIPT_NAME] => /index.php
[PHP_SELF] => /index.php
[REQUEST_TIME] => 1268126900
[argv] => Array
(
)
[argc] => 0
25 lut 2010

Użycie funkcji regexp_replace

select mapa_pl, regexp_replace(mapa_pl, '!([a-z_]+)!', E'<xsl:value-of select="\\1"/>', 'g') as test from mapy.mapa where mapa_pl like '%!%'

update mapy.mapa set mapa_pl = regexp_replace(mapa_pl, '!([a-z_]+)!', E'<xsl:value-of select="\\1"/>', 'g') where mapa_pl like '%!%'

zamiana
mapa!id!
na
mapa<xsl:value-of select="id"/>

24 lut 2010

Obliczanie różnicy ilości dni miedzy datami w JS

const D = document.getElementById('data_od_d');
const M = document.getElementById('data_od_m');
const Y = document.getElementById('data_od_y');
const doD = document.getElementById('data_do_d');
const doM = document.getElementById('data_do_m');
const doY = document.getElementById('data_do_y');

// dzień w milisekundach
const dzien_milisekundy = 1000 * 60 * 60 * 24;

const mDate_od = new Date(Y, M, D).getTime();
const mDate_do = new Date(doY, doM, doD).getTime();
const ilosc_dni = (mDate_do - mDate_od) / dzien_milisekundy;

inpD.innerHTML = `Razem: ${ilosc_dni}`;
inpD2.value = ilosc_dni;
24 lut 2010

Polecenie alias

alias a='alias'
alias l='ls -l'
alias d='cd /var/www/;l'
alias g='ps -aux |grep pawel'

wpisanie alias w CMD, powoduje wyświetlenie listy aliasów