Skip to content

Instantly share code, notes, and snippets.

@bohwaz
bohwaz / php_sqlite_rank.php
Created November 10, 2011 16:09
Pure PHP rank function for SQLite FTS4 (adapted from SQLite doc)
<?php
/*
Adapted from C function available at http://www.sqlite.org/fts3.html#appendix_a
Use like this:
$db = new SQLite3('database.db');
$db->createFunction('rank', 'sql_rank');
$db->query('CREATE VIRTUAL TABLE products USING fts4 (id INTEGER, title TEXT, description TEXT);');
$db->query('SELECT * FROM products WHERE products MATCH \'Computer\' ORDER BY rank(matchinfo(products), 0, 1.0, 0.5) DESC;');
@bohwaz
bohwaz / maths.php
Created February 4, 2012 22:53
Allow user to compute maths in PHP
<?php
function mathEval($q)
{
$q = preg_replace('/\s+/', '', $q);
$number = '(?:\d+(?:[,.]\d+)?|pi|π)';
$functions = '(?:sinh?|cosh?|tanh?|abs|acosh?|asinh?|atanh?|exp|log10|deg2rad|rad2deg|sqrt|ceil|floor|round)';
$operators = '[+\/*\^%-]';
$regexp = '/^(('.$number.'|'.$functions.'\s*\((?1)+\)|\((?1)+\))(?:'.$operators.'(?2))*)+$/';
@bohwaz
bohwaz / download.sh
Created December 25, 2015 06:53 — forked from mildred/download.sh
Download from archive.org Wayback Machine
#!/bin/bash
url=http://redefininggod.com
webarchive=https://web.archive.org
wget="wget -e robots=off -nv"
tab="$(printf '\t')"
additional_url=url.list
# Construct listing.txt from url.list
# The list of archived pages, including some wildcard url
@bohwaz
bohwaz / ngv-download.php
Last active May 16, 2016 01:36
Download large images of art from National Gallery of Victoria (NGV) website
#!/usr/bin/php
<?php
/**
* Download a large size art image from National Gallery of Victoria (NGV) website
* Copyleft (C) 2016 BohwaZ http://bohwaz.net/ (Public domain)
*/
if (empty($argv[1]))
{
@bohwaz
bohwaz / nvsprintf.php
Created June 28, 2016 04:39 — forked from onyxraven/nvsprintf.php
Named param vsprintf()
<?php
/**
* Named-Param vsprintf()
*
* positional-params based on key name, much the same as positional in sprintf()
*
* @link http://php.net/manual/en/function.sprintf.php
* @link http://www.php.net/manual/en/function.vsprintf.php
*
* @param string $str format string - replacements are in %KEY$x format
@bohwaz
bohwaz / gitlab-projects-json-to-csv.php
Created February 8, 2017 01:23
Extract Gitlab JSON project list and convert it to CSV
<?php
$projects = [];
$projects[] = [
'Project path',
'Owner',
'Name',
'Description',
'Created',
@bohwaz
bohwaz / setcookie_samesite_polyfill.php
Last active September 4, 2018 13:56
PHP setcookie function polyfill with support for SameSite attribute (compatible with PHP 5.0+)
<?php
/**
* Setcookie function with support for SameSite
* @param string|null $samesite 'Lax' or 'Strict'
*/
function setcookie_samesite($name, $value = '', $expire = 0, $path = null, $domain = null, $secure = false, $httponly = false, $samesite = null)
{
$params = array(
rawurlencode($name) . '=' . rawurlencode($value),
@bohwaz
bohwaz / download-slsa.php
Last active April 23, 2017 10:52
Download images from SLSA (State Library of South Australia) collections
<?php
/**
* Download large size images from SLSA Library
* (State Library of South Australia)
* Copyleft (C) 2015-2017 BohwaZ http://bohwaz.net/
* GNU AGPL license
*/
if (empty($argv[1]))
@bohwaz
bohwaz / csv2sqlite.php
Created April 23, 2017 10:52
Import CSV file in a SQLite table, including column headers
<?php
$fp = fopen($argv[1], 'r');
$db = new SQLite3($argv[1] . '.sqlite');
$db->exec('BEGIN;');
$header = null;
$i = 0;
@bohwaz
bohwaz / get_time_from_ntp.php
Created April 28, 2017 02:48
Fetches timestamp from a NTP server in PHP
<?php
/**
* Returns UNIX timestamp from a NTP server (RFC 5905)
*
* @param string $host Server host (default is pool.ntp.org)
* @param integer $timeout Timeout in seconds (default is 10 seconds)
* @return integer Number of seconds since January 1st 1970
*/
function getTimeFromNTP($host = 'pool.ntp.org', $timeout = 10)