Skip to content

Instantly share code, notes, and snippets.

View phreakin's full-sized avatar

Phreakin phreakin

View GitHub Profile
@phreakin
phreakin / FontAwesome 5 all icons in list.txt
Created June 15, 2023 04:33 — forked from cristianstan/FontAwesome 5 all icons in list.txt
FontAwesome 5 cheatsheet all icons in PHP array.php
fab fa-500px
fab fa-accessible-icon
fab fa-accusoft
fab fa-acquisitions-incorporated
fas fa-ad
fas fa-address-book
fas fa-address-card
fas fa-adjust
fab fa-adn
fab fa-adobe
@phreakin
phreakin / db-setup.sql
Created February 5, 2023 10:11 — forked from gka/db-setup.sql
load geoip database into mysql
DROP TABLE IF EXISTS location;
CREATE TABLE IF NOT EXISTS `location` (
`locId` int(11) unsigned NOT NULL AUTO_INCREMENT,
`country` varchar(2) DEFAULT NULL,
`region` varchar(2) DEFAULT NULL,
`city` varchar(1000) DEFAULT NULL,
`postalCode` varchar(10) DEFAULT NULL,
`latitude` float DEFAULT NULL,
`longitude` float DEFAULT NULL,
@phreakin
phreakin / area-codes.sql
Last active February 28, 2023 19:40 — forked from yahelc/area-codes.sql
DROP TABLE IF EXISTS `areacodes`
CREATE TABLE IF NOT EXISTS `areacodes` (
`Area Code` int(3) NOT NULL,
`Region` tinytext NOT NULL,
`Description` varchar(256) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@phreakin
phreakin / eloquent-cheatsheet.php
Created December 16, 2022 02:32 — forked from hassansin/eloquent-cheatsheet.php
Laravel 5 Eloquent CheatSheet #laravel #eloquent
Model::
/*Select*/
select('col1','col2')
->select(array('col1','col2'))
->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))
->addSelect('col3','col4')
->distinct() // distinct select
/*From*/
@phreakin
phreakin / tailwind_cheatsheet.css
Created December 3, 2022 08:54 — forked from LeCoupa/tailwind_cheatsheet.css
Tailwind CSS CheatSheet --> UPDATED VERSION --> https://github.com/LeCoupa/awesome-cheatsheets
/* *******************************************************************************************
* TAILWIND.CSS
* DOCUMENTATION: https://tailwindcss.com/
* ******************************************************************************************* */
/*
* Available breakpoints
* --------------------
* sm: min-width: 640px;
* md: min-width: 768px;
@phreakin
phreakin / laravel-9-laravel-mix-6-font-awesome-6.md
Created September 6, 2022 18:12 — forked from karlhillx/laravel-9-laravel-mix-6-font-awesome-6.md
Want to use Laravel 9 and Font Awesome 6? (Regularly updated)

Laravel asset compilation for Laravel 9 + Laravel Mix 6 + Font Awesome 6

This document provides help to get your Laravel 9 instance running with the latest versions of Laravel Mix and Font Awesome.

Laravel Mix