Skip to content

Instantly share code, notes, and snippets.

View kamilklkn's full-sized avatar

Kamil Kalkan kamilklkn

View GitHub Profile
@kamilklkn
kamilklkn / js-turkish-to-english.js
Created November 28, 2020 06:51 — forked from enginkartal/js-turkish-to-english.js
Javascript Turkish character to english characters change
String.prototype.turkishtoEnglish = function () {
return this.replace('Ğ','g')
.replace('Ü','u')
.replace('Ş','s')
.replace('I','i')
.replace('İ','i')
.replace('Ö','o')
.replace('Ç','c')
.replace('ğ','g')
.replace('ü','u')
@kamilklkn
kamilklkn / postakodu.sql
Created May 19, 2016 10:02 — forked from ismailbaskin/postakodu.sql
İl - İlçe - semt - mahalle - posta kodu veritabanı
This file has been truncated, but you can view the full file.
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');
<?php
//mysql sunucuya bağlanma ve veritabanı seçme
//mysql
mysql_connect('localhost','root','parola');
mysql_select_db('deneme');
//pdo
$db = new PDO('mysql:host=localhost;dbname=deneme','root',parola);
//sorgu
$sqlUyeler = 'select * from uyeler where cins="2"';