Skip to content

Instantly share code, notes, and snippets.

@amar-bhatia
amar-bhatia / barchart.php
Created September 16, 2020 05:20 — forked from inf123/barchart.php
Bar chart in PHP using the GD library
<?php
/*
* Chart data
*/
$data = [
'Jan' => 103,
'Feb' => 24,
'Mar' => 44,
@amar-bhatia
amar-bhatia / mysql-levenshtein.sql
Created January 27, 2020 13:16 — forked from Kovah/mysql-levenshtein.sql
Levenshtein function for MySQL
-- Levenshtein function
-- Source: https://openquery.com.au/blog/levenshtein-mysql-stored-function
-- Levenshtein reference: http://en.wikipedia.org/wiki/Levenshtein_distance
-- Arjen note: because the levenshtein value is encoded in a byte array, distance cannot exceed 255;
-- thus the maximum string length this implementation can handle is also limited to 255 characters.
DELIMITER $$
DROP FUNCTION IF EXISTS LEVENSHTEIN $$
CREATE FUNCTION LEVENSHTEIN(s1 VARCHAR(255) CHARACTER SET utf8, s2 VARCHAR(255) CHARACTER SET utf8)