Skip to content

Instantly share code, notes, and snippets.

# Begin HTTP Server
server {
listen 80; # IPv4
server_name localhost;
## Parametrization using hostname of access and log filenames.
access_log logs/localhost_access.log;
error_log logs/localhost_error.log;
## Root and index files.
@To-mos
To-mos / fa-gallery.svg
Created December 3, 2016 03:25
Below are 2 font awesome styled gallery icons in svg format to use wherever.
@To-mos
To-mos / carousel.js
Last active August 29, 2015 13:56 — forked from ksolo/carousel.js
Image Carousel
@To-mos
To-mos / form-validator.js
Last active August 29, 2015 13:56 — forked from ksolo/form-validator.js
Form Validation
// shorthand for $(document).ready();
$(function() {
//Your code...
$('form[name="sign_up"]').submit(function(e) {
e.preventDefault();
var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
var email = $('input[name="email"]').val();
var password = $('input[name="password"]').val();
var errorsOut = ""; //concatenation baby
if (email.length == 0)
@To-mos
To-mos / form-validator.js
Created February 27, 2014 16:20 — forked from ksolo/form-validator.js
Form Validation
// shorthand for $(document).ready();
$(function(){
//Your code...
});
@To-mos
To-mos / zoo.js
Last active August 29, 2015 13:56 — forked from dbc-challenges/zoo.js
//------------------------------------------------------------------------------------------------------------------
// YOUR CODE: Create your Zoo "object literal" and Animal "constructor" and "prototypes" here.
//------------------------------------------------------------------------------------------------------------------
function Zoo() {};
//constructor
Zoo.init = function(animals) {
this.animals = animals;
};
//biped method
@To-mos
To-mos / index.html
Last active August 29, 2015 13:56 — forked from dbc-challenges/index.html
DBC Phase 2 Practice Assessment Part 3
<!doctype html>
<html>
<head>
<link rel="stylesheet" href="http://cdn.jsdelivr.net/normalize/2.1.0/normalize.css">
<link rel="stylesheet" href="main.css">
<link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800">
<link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Lato:100,900">
<link rel="stylesheet" href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/3.0.2/css/font-awesome.min.css">
</head>
/* Here is your chance to take over Socrates!
Spend 10 minutes on each of the following hacks to the Socrates website.
Enter them in the console to make sure it works and then save
your results here.
Choose a new pair for each. Add your names to the section you complete.
*/

Instructions:

  1. Download this application skeleton.
  2. Convert the app to use AJAX.
  3. Add any files you changed to your gist and submit your code.

Exercise #187: Give me a list of all invoices from Redmond, WA sorted from low-to-high by total

SELECT * FROM invoices WHERE billing_city = 'Redmond' ORDER BY total ASC;

Exercise #188: Give me a list of all invoices from Redmond, WA sorted from high-to-low by total

SELECT * FROM invoices WHERE billing_city = 'Redmond' ORDER BY total DESC;

Exercise #189: Give me a list of all invoices from Germany sorted from high-to-low by total