Kamil Kalkan kamilklkn

Product Designer, Product Manager | Stock Photographer

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');

kamilklkn / mysqltopdo.php

Last active August 29, 2015 14:06 — forked from sarpdorukaslan/mysqltopdo.php

	<?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"';