hasantayyar

CREATE TABLE `isimler` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ad` varchar(255) COLLATE utf8_bin NOT NULL,
  `cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ad` (`ad`),
  KEY `cinsiyet` (`cinsiyet`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

hasantayyar

history|awk '{print $2}'|awk 'BEGIN {FS="|"} {print $1}'|sort|uniq -c|sort -r

hasantayyar

Pub/sub with MongoDB and Node.js

Setup:

$ mongo
> use pubsub
> db.createCollection('messages', { capped: true, size: 100000 })
> db.messages.insert({})

hasantayyar

/* Simple Memcached in Javascript 
 * @Author: Sun, Junyi
 * @Email:  ccnusjy@gmail.com
 * @Date:   2012-8-3
*/
var net = require('net');
var store = {}

function handle_header(header,crlf_len){
	var tup = header.split(" ")

hasantayyar

CREATE TABLE `isimler` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ad` varchar(255) COLLATE utf8_bin NOT NULL,
  `cinsiyet` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ad` (`ad`),
  KEY `cinsiyet` (`cinsiyet`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

hasantayyar

Node.js Fullstack MVC / REST frameworks

• http://flatironjs.org/
• http://krakenjs.com/
• http://sailsjs.org
• http://tower.github.io/
• http://derbyjs.com/
• http://www.meteor.com/
• http://compoundjs.com/
• http://geddyjs.org/
• http://www.sleekjs.com/

hasantayyar

<!-- country codes (ISO 3166) and Dial codes. -->
<select name="countryCode" id="">
	<option data-countryCode="GB" value="44" Selected>UK (+44)</option>
	<option data-countryCode="US" value="1">USA (+1)</option>
	<optgroup label="Other countries">
		<option data-countryCode="DZ" value="213">Algeria (+213)</option>
		<option data-countryCode="AD" value="376">Andorra (+376)</option>
		<option data-countryCode="AO" value="244">Angola (+244)</option>
		<option data-countryCode="AI" value="1264">Anguilla (+1264)</option>
		<option data-countryCode="AG" value="1268">Antigua &amp; Barbuda (+1268)</option>

hasantayyar

<?php
function get_ip_address() {
    $ip_keys = array('HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'HTTP_X_FORWARDED', 'HTTP_X_CLUSTER_CLIENT_IP', 'HTTP_FORWARDED_FOR', 'HTTP_FORWARDED', 'REMOTE_ADDR');
    foreach ($ip_keys as $key) {
        if (array_key_exists($key, $_SERVER) === true) {
            foreach (explode(',', $_SERVER[$key]) as $ip) {
                // trim for safety measures
                $ip = trim($ip);
                // attempt to validate IP
                if (validate_ip($ip)) {

hasantayyar

Deploy your site with git

This gist assumes:

• you have a local git repo
• with an online remote repository (github / bitbucket etc)
• and a cloud server (Rackspace cloud / Amazon EC2 etc)
  • your (PHP) scripts are served from /var/www/html/
  • your webpages are executed by apache
• apache's home directory is /var/www/

hasantayyar

DROP TABLE IF EXISTS `pk_il`;
CREATE TABLE `pk_il` (
  `il_id` int(2) NOT NULL COMMENT 'plaka kodu',
  `il_adi` varchar(255) NOT NULL,
  PRIMARY KEY (`il_id`),
  KEY `il_adi` (`il_adi`) USING BTREE
) ENGINE=MyISAM;

-- ----------------------------
INSERT INTO `pk_il` VALUES ('1', 'ADANA');