Skip to content

Instantly share code, notes, and snippets.

View rbk's full-sized avatar

Richard Keller rbk

39 followers · 21 following
View GitHub Profile
@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",
@rbk
rbk / gist:25ad75179d0a76e45a0295bb4e537eb4
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",
@rbk
rbk / embed.js
Created September 21, 2016 16:14
Embed code snippet
<script type="text/javascript">
(function(){
var s = document.createElement('script');
s.type = 'text/javascript';
a.async = true;
s.src = '';
var x = document.getElementsByTagName('script')[0];
x.parentNode.insertBefore(s, x);
})();
</script>
@rbk
rbk / gist:2db1e18046359cdb1f4a75be21f2d230
Created July 27, 2016 18:38
Slugify
function slugify( $str ) {
$new_str = $str;
$new_str = preg_replace('/ /', '-', $new_str);
$new_str = preg_replace('/[^A-Za-z0-9\-]/', '', $new_str);
$new_str = strtolower($new_str);
return $new_str;
}
@rbk
rbk / mailchimp.php
Last active August 31, 2016 20:58
Subscript to Mailchimp list via php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>MC TEST</title>
</head>
<body>
<?php
define('CLIENT_ID', '');
@rbk
rbk / super-func.php
Created July 22, 2016 17:47
Get an excerpt if one doesn't exist
<?php
function generate_awesome_excerpt( $id, $character_limit, $ending ) {
if( gettype($character_limit) != 'integer' ) {
$character_limit = 100;
}
$post = get_post($id);
$content = $post->post_content;