Skip to content

Instantly share code, notes, and snippets.

View vielhuber's full-sized avatar
🍐
❹❷

David Vielhuber vielhuber

🍐
❹❷
25 followers · 0 following
View GitHub Profile
@vielhuber
vielhuber / style.css
Last active September 22, 2017 23:12
clearfix #css
.clearfix:after {
content:"";
clear:both;
display:table;
}
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
mail() with umlauts #php
mail(
"vieldav@gmx.de", // recipient
"=?UTF-8?B?".base64_encode("ä ö ü ß")."?=", // subject
"ä ö ü ß", // content
"Content-type: text/plain; charset=utf-8\r\n"
."From: =?UTF-8?B?".base64_encode("ä ö ü ß")."?=<david@vielhuber.de>" // from
);
@vielhuber
vielhuber / .htaccess
Created April 6, 2015 18:09
Apache: htaccess Prevent doubled password request #server
RewriteEngine On
RewriteCond %{HTTPS} !=on
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
<If "%{HTTPS} == 'on'">
AuthUserFile /path/to/.htpasswd
AuthName "Interner Bereich"
AuthType Basic
require valid-user
</If>
@vielhuber
vielhuber / script.sql
Last active September 22, 2017 23:12
create ranking with equal positions #sql
CREATE TABLE
user(id INT, score INT);
INSERT INTO
user(id, score)
VALUES
(1, 10), (2, 40), (3, 55), (4, 10), (5, 5), (6, 20), (7, 30), (8, 70), (9, 30);
SET @score_prev = NULL;
SET @cur_rank = 0;
SELECT id, score, CASE
@vielhuber
vielhuber / script.sh
Created April 7, 2015 08:44
ffmpeg: Convert wav files in folder to mp3 and ogg (+ increasing the volume) #tools
rm -f ~/audio/files/*.mp3;
rm -f ~/audio/files/*.ogg;
cd ~/audio/files/;
for i in *.wav; do ~/ffmpeg/ffmpeg -y -i $i -af volume=2.5 -ab 192k ${i/%.wav/.mp3}; done;
for i in *.wav; do ~/ffmpeg/ffmpeg -y -i $i -af volume=2.5 -aq 10 ${i/%.wav/.ogg}; done;
@vielhuber
vielhuber / index.html
Last active September 22, 2017 23:12
Dropdown-Menu with delayed hover effect #js #css #html
<div class="menu">
<a href="#">Menüpunkt</a>
<ul>
<li>
<a href="#">Untermenüpunkt</a>
<ul>
<li>Unteruntermenüpunkt</li>
<li>Unteruntermenüpunkt</li>
<li>Unteruntermenüpunkt</li>
</ul>
@vielhuber
vielhuber / index.php
Last active May 17, 2023 14:10
PRG-Pattern post get redirect #php
// without any response
header("Location: " . $_SERVER['REQUEST_URI']);
die();
// with a response using GET
header("Location: " . parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH).'?response=foo');
die();
@vielhuber
vielhuber / index.php
Last active December 19, 2017 20:07
cookies #php
<?php
// unset
unset($_COOKIE['cookie']); setcookie('cookie', '', time() - 3600, '/');
// set
setcookie('cookie', $value, time()+60*60*24*1, '/');
$_COOKIE['cookie'] = $value; // immediately set it for current request
// get
$_COOKIE['cookie']
@vielhuber
vielhuber / 2x2.md
Last active November 15, 2020 17:10
Rubik's Cube Solution
@vielhuber
vielhuber / index.php
Last active September 22, 2017 23:12
DB load single row #joomla
$db->setQuery($db->getQuery(true)->select("*")->from($db->quoteName('#__js_table'))->where($db->quoteName('ID').' = '.$db->quote(1)))->loadObject();