Skip to content

Instantly share code, notes, and snippets.

View rbk's full-sized avatar

Richard Keller rbk

49 followers · 27 following
View GitHub Profile
@rbk
rbk / setup_lamp.sh
Created December 14, 2018 14:16
Install Lamp on pi. https://www.raspberrypi.org/forums/viewtopic.php?t=218354
#Update system
sudo apt-get update
sudo apt-get upgrade -y
#Install Apache2
sudo apt-get install apache2 -y
sudo a2enmod rewrite
sudo service apache2 restart
#Install PHP
@rbk
rbk / rest-api-doc-example.md
Last active June 7, 2019 19:40
Example of REST API documentation (Based on Twitter, 2018)
@rbk
rbk / pymysql-connect.py
Created March 23, 2018 13:14
Connect to MySQL via PyMysql
import pymysql
connection = pymysql.connect(host='<ip-or-domain>',
user='<dbuser>',
password='<dbpass>',
db='<dbname>',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor,
autocommit=True)
@rbk
rbk / sizecheck.js
Created July 27, 2017 18:13
Find out if any elements are wider that the screen size.
function findElementsLargerThanScreen() {
var elements = document.querySelectorAll('*')
for (var i = 0; i < elements.length; i++) {
var elementWidthInt = 0;
var elementWidth = window.getComputedStyle(elements[i], null).width
if (elementWidth !== 'auto') {
elementWidthInt = parseFloat(elementWidth.replace('px', ''));
if (elementWidthInt > screen.width) {
console.log(elementWidthInt)
} else {
@rbk
rbk / gist:d516d5d96e2116a4a614ebb0ae8a306f
Created May 2, 2017 20:18
Setup a server from scratch for Drupal 8 - Ubuntu 16
1. install mysql, apache2, php-cli, php
- apt-get install php7.0-cli
- apt-get install php7.0 libapache2-mod-php7.0 php7.0-gd php7.0-xml php7.0-mysql
- apt-get install apache2 apache2-doc apache2-utils
- apt-get install mysql-server
- apt-get install zip unzip
- apt-get install mailutils # setup required
3. download d8
@rbk
rbk / db-sample.py
Created April 21, 2017 17:33
Python 3.5 Database interaction sample
# note: Must install pymysql: `pip3 install pymysql`
import pymysql
conn= pymysql.connect(host='localhost',user='root',password='password',db='s1',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
a=conn.cursor()
sql='CREATE TABLE `users` (`id` int(11) NOT NULL AUTO_INCREMENT,`email` varchar(255) NOT NULL,`password` varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;'
a.execute(sql)
@rbk
rbk / gist:24ddee1d4b631eeeb4779c88cc0d0892
Created March 10, 2017 19:49
Sample PHPCS config - http://edorian.github.io/php-coding-standard-generator/#phpcs
<?xml version="1.0" encoding="UTF-8"?>
<ruleset name="BAD GAZELLE">
<description>Created with the PHP Coding Standard Generator. http://edorian.github.com/php-coding-standard-generator/
</description>
<arg name="tab-width" value="2"/>
<rule ref="Generic.Classes.DuplicateClassName"/>
<rule ref="Generic.CodeAnalysis.EmptyStatement"/>
<rule ref="Generic.CodeAnalysis.JumbledIncrementer"/>
<rule ref="Generic.CodeAnalysis.UnconditionalIfStatement"/>
<rule ref="Generic.CodeAnalysis.UnnecessaryFinalModifier"/>
@rbk
rbk / movie-search.html
Created December 21, 2016 20:18
Movie Search
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<input type="text" id="input">
<pre id="output"></pre>
@rbk
rbk / drupal-query.php
Created November 23, 2016 13:09
Here is a simple example to load up some nodes of type event for the month of March, looking up information of a field type datetime called 'field_date':
<?php
<?php
$query = new EntityFieldQuery();
$entities = $query->entityCondition('entity_type', 'node')
->entityCondition('bundle', 'event')
->propertyCondition('status', 1)
->fieldCondition('field_date', 'value', array('2011-03-01', '2011-03-31'), 'BETWEEN')
->fieldOrderBy('field_date', 'value', 'ASC')
->execute();
@rbk
rbk / gist:af4f12f7ca0b0ef9df83bde75227a4f2
Created October 17, 2016 13:56
Sublime Text Settings
{
"always_show_minimap_viewport": true,
"bold_folder_labels": true,
"caret_extra_bottom": 1,
"caret_extra_top": 1,
"caret_extra_width": 1,
"caret_style": "blink",
"color_scheme": "Packages/Boxy Theme/schemes/Boxy Monokai.tmTheme",
"fade_fold_buttons": false,
"font_face": "hermit",