Skip to content

Instantly share code, notes, and snippets.

@foxy4096
foxy4096 / DatabaseWrapper.php
Last active March 27, 2024 11:07
✨ A simple database wrapper 📦
<?php
$GLOBALS['conn'] = $dbconn; // Replace it with your own `mysqli_connect` :)
function db_query($sql, $params = array(), $single = true)
{
$stmt = mysqli_prepare($GLOBALS['conn'], $sql);
if (!$stmt) {
// Handle SQL query preparation error
return null;
}
@foxy4096
foxy4096 / main.css
Last active December 12, 2023 11:40
Snippets
@import url("https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.1/font/bootstrap-icons.css");
.emojione {
width: 30px;
padding-left: 6px;
display: inline-flex;
vertical-align: text-top;
}
.tabbed-set {
@beginor
beginor / snowflake-id.sql
Last active September 14, 2025 10:03
Twitter Snowflake ID for PostgreSQL
CREATE SEQUENCE public.global_id_seq;
ALTER SEQUENCE public.global_id_seq OWNER TO postgres;
CREATE OR REPLACE FUNCTION public.id_generator()
RETURNS bigint
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
our_epoch bigint := 1314220021721;
seq_id bigint;