Skip to content

Instantly share code, notes, and snippets.

View yahyaerturan's full-sized avatar

Yahya Erturan yahyaerturan

View GitHub Profile
@yahyaerturan
yahyaerturan / tr_countries.sql
Last active March 11, 2022 09:57
Türkçe Ülkeler MySQL Tablosu
CREATE TABLE IF NOT EXISTS `countries_list` (
`id_country` tinyint(3) unsigned NOT NULL auto_increment,
`country_name` varchar(30) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=207 ;
--
-- Dumping data for table `countries_list`
--
@yahyaerturan
yahyaerturan / js_cities_and_districts_tr.js
Created August 18, 2013 08:35
Javascript ile İl ve İlçeler
/*
* İl : 81
* İlçe : 957
*
* */
var city = new Array('Adana', 'Adıyaman', 'Afyonkarahisar', 'Ağrı', 'Amasya', 'Ankara', 'Antalya', 'Artvin', 'Aydın', 'Balıkesir', 'Bilecik', 'Bingöl', 'Bitlis', 'Bolu', 'Burdur', 'Bursa', 'Çanakkale', 'Çankırı', 'Çorum', 'Denizli', 'Diyarbakır', 'Edirne', 'Elazığ', 'Erzincan', 'Erzurum', 'Eskişehir', 'Gaziantep', 'Giresun', 'Gümüşhane', 'Hakkâri', 'Hatay', 'Isparta', 'Mersin', 'İstanbul', 'İzmir', 'Kars', 'Kastamonu', 'Kayseri', 'Kırklareli', 'Kırşehir', 'Kocaeli', 'Konya', 'Kütahya', 'Malatya', 'Manisa', 'Kahramanmaraş', 'Mardin', 'Muğla', 'Muş', 'Nevşehir', 'Niğde', 'Ordu', 'Rize', 'Sakarya', 'Samsun', 'Siirt', 'Sinop', 'Sivas', 'Tekirdağ', 'Tokat', 'Trabzon', 'Tunceli', 'Şanlıurfa', 'Uşak', 'Van', 'Yozgat', 'Zonguldak', 'Aksaray', 'Bayburt', 'Karaman', 'Kırıkkale', 'Batman', 'Şırnak', 'Bartın', 'Ardahan', 'Iğdır', 'Yalova', 'Karabük', 'Kilis', 'Osmaniye', 'Düzce');
var phone_code = new Array('0322', '0416', '0272', '0472', '0358', '0312', '0242', '0
@yahyaerturan
yahyaerturan / bootstrap-compiled.css
Last active August 29, 2015 14:08
Narrower Bootstrap 3.2.0
/*!
* Bootstrap v3.2.0 (http://getbootstrap.com)
* Compiled by Yahya ERTURAN @ 2014-10-28 09:45:00
* Copyright 2011-2014 Twitter, Inc.
* Licensed under MIT (https://github.com/twbs/bootstrap/blob/master/LICENSE)
*/
/*! normalize.css v3.0.1 | MIT License | git.io/normalize */html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}article,aside,details,figcaption,figure,footer,header,hgroup,main,nav,section,summary{display:block}audio,canvas,progress,video{display:inline-block;vertical-align:baseline}audio:not([controls]){display:none;height:0}[hidden],template{display:none}a{background:transparent}a:active,a:hover{outline:0}abbr[title]{border-bottom:1px dotted}b,strong{font-weight:bold}dfn{font-style:italic}h1{font-size:2em;margin:.67em 0}mark{background:#ff0;color:#000}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sup{top:-0.5em}sub{bottom:-0.25em}img{border:0}svg:not(:root){overflow:hidden}figure{margin:1em 40p
@yahyaerturan
yahyaerturan / ubuntu_terminal_style_debug_helper.php
Created March 20, 2015 14:53
Ubuntu Terminal Styled Debug Helper (CI)
if(!function_exists('terminal')) {
function terminal($var,$die=TRUE){
$CI = &get_instance();
$CI->load->library('unit_test');
$bt = debug_backtrace();
$src = file($bt[0]["file"]);
$line = $src[$bt[0]['line'] - 1];
# Match the function call and the last closing bracket
preg_match('#' . __FUNCTION__ . '\((.+)\)#', $line, $match);
@yahyaerturan
yahyaerturan / istoc_gold
Last active August 29, 2015 14:22
Ajansbu İSTOÇ Üyelik Yenileme
<?php
function reformat_datetime ($datetime=null , $target_format = 'Y-m-d H:i:s') {
if($datetime) {
$date = new DateTime($datetime, new DateTimeZone('Europe/Istanbul'));
if($target_format == 'datetime') return $date->format('Y-m-d H:i:s');
else if ($target_format == 'date_tr') return $date->format('d.m.Y');
else if ($target_format == 'time_tr') return $date->format('H:i:s');
else if ($target_format == 'datetime_tr') return $date->format('d.m.Y H:i:s');
else if ($target_format == 'timestamp') return $date->getTimestamp();
@yahyaerturan
yahyaerturan / index.html
Created November 12, 2016 19:35
Centered Vayes Logo for empty hosts
<!doctype html>
<html lang="tr">
<head>
<meta charset="utf-8">
<title>Vayes Web Yazılım</title>
<meta name="description" content="Vayes Web Yazılım - Web Tasarım">
<meta name="author" content="Vayes">
@yahyaerturan
yahyaerturan / sublime-settings
Created January 10, 2017 09:27
Sublime Settings
{
"auto_find_in_selection": true,
"color_scheme": "Packages/Theme - itg.flat/itg.dark.tmTheme",
"default_line_ending": "unix",
"ensure_newline_at_eof_on_save": true,
"font_face": "Monaco",
"font_size": 12,
"highlight_line": true,
"highlight_modified_tabs": true,
"ignored_packages":
@yahyaerturan
yahyaerturan / .bashrc
Created January 10, 2017 12:50
Ubuntu .bashrc
# Added by Yahya ERTURAN
export PATH=$PATH:$HOME/bin
# Added by Yahya ERTURAN for NodeJS & NPM
export PATH=$HOME/.npm-global/bin:$PATH
@yahyaerturan
yahyaerturan / seed.php
Last active March 13, 2017 20:29
CI3 Fake Date Dumper with Intervals
<?php
# Creates an array first with given numbers
# Dumps it to db with 250 records/insert intervals
# You may need to adjust your php settings:
# ini_set('memory_limit', '1024M');
# ini_set('max_execution_time', 300); //300 seconds = 5 minutes
/**
* Users Seeds