query – case sensitive en mysql
SELECT * FROM `table` WHERE BINARY `COLUMN` = ‘value’ Note binary
Blog
Firefox tarayıcısı dışında bir tarayıcıda istediğini gösterme
<?php if ( !strpos($_SERVER[‘HTTP_USER_AGENT’], ‘Gecko’) ) { ?> <!– Firefox dışında ki tarayıcılarda göstermek istediğiniz kodları buraya yerleştirin –> <?php } ?> Note mesela adsense’nin… Read More »Firefox tarayıcısı dışında bir tarayıcıda istediğini gösterme
Récupérer l’adresse ip publique (vue depuis internet)
#L’appel à iconv n’est nécessaire que si votre système utilise utf8 comme jeu de caractères par défaut (ce qui devient de plus en plus courant)… Read More »Récupérer l’adresse ip publique (vue depuis internet)
Calculer le temps d’exécution d’un code PHP
$start = microtime(TRUE); // Code PHP à bencher for ($i = 0; $i < 10000; $i++) { isset($array[‘id’]); } echo number_format(microtime(TRUE) – $start,… Read More »Calculer le temps d’exécution d’un code PHP
Alert PHP
function alertPhp($texto){ echo “<script type=’text/javascript’>alert(‘”.$texto.“‘);</script>”; }
Firefox 3 CSS hack
.foo, x:-moz-any-link { } /* FireFox 2 */ .foo, x:-moz-any-link, x:default { } /* FireFox 3 */ html>/**/body .foo, x:-moz-any-link, x:default { } /* Only… Read More »Firefox 3 CSS hack
Liste des paquets installés classés par taille
dpkg-query -W —showformat=‘${Installed-Size} ${Package}\n‘ | sort -n
Optional parameter in Javascript function and default value
var myfunc = function(optional) { if (typeof optional == “undefined”) { optional = “default value”; } alert(optional); }
mysql – guardar los resultados en un fichero
SELECT id,title INTO OUTFILE “c:/result.text” FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY “n” FROM property;
Watch log file and send logs to syslog
#!/bin/sh append=“”; tail -F /opt/log/audit/audit.log | sed -u -e ‘s/^M//g’ -e ‘/^$/d’ -e ‘s/ *$//g’ -e ‘s/^ *//g’ -e ‘s/ +/ /g’ | while read… Read More »Watch log file and send logs to syslog