-- phpMyAdmin SQL Dump -- version 4.1.14 -- http://www.phpmyadmin.net -- -- Anamakine: 127.0.0.1 -- Üretim Zamanı: 24 Mar 2020, 13:56:04 -- Sunucu sürümü: 5.6.17 -- PHP Sürümü: 5.5.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Veritabanı: `panel` -- -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `anaokul` -- CREATE TABLE IF NOT EXISTS `anaokul` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `anaokulu` -- CREATE TABLE IF NOT EXISTS `anaokulu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `no` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `sinif` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `osekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `anne` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `tel1` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `tel2` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `mes1` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `nott` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `ob` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `om` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ss` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sg` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `veli` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `kytsonuc` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `vsonuc` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adsoyad2` varchar(100) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `idare` -- CREATE TABLE IF NOT EXISTS `idare` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kadi` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sifre` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=12 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ilkokul` -- CREATE TABLE IF NOT EXISTS `ilkokul` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `no` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `sinif` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `osekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `anne` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `tel1` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `tel2` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `mes1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `nott` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ob` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `om` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ss` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sg` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `veli` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `kytsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `vsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `kayit` -- CREATE TABLE IF NOT EXISTS `kayit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kadi` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sifre` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=2 ; -- -- Tablo döküm verisi `kayit` -- INSERT INTO `kayit` (`id`, `kadi`, `sifre`) VALUES (1, 'altınnesil', '1234'); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `lise` -- CREATE TABLE IF NOT EXISTS `lise` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `no` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sinif` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `osekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `anne` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `tel1` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `tel2` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `mes1` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `nott` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `ob` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `om` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ss` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sg` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `veli` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `kytsonuc` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `vsonuc` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `adsoyad2` varchar(100) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `muhasebe2` -- CREATE TABLE IF NOT EXISTS `muhasebe2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kadi` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sifre` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=10 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ogrenci` -- CREATE TABLE IF NOT EXISTS `ogrenci` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dtarih` int(11) NOT NULL, `okul` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `no` int(11) NOT NULL, `sinif` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `btarih` int(11) NOT NULL, `puan` int(11) NOT NULL, `anne` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `tel1` int(11) NOT NULL, `tel2` int(11) NOT NULL, `mes1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(1000) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `not` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(100) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=28 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ogrenci2` -- CREATE TABLE IF NOT EXISTS `ogrenci2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `no` int(11) NOT NULL, `sinif` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `anne` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `tel1` int(11) NOT NULL, `tel2` int(11) NOT NULL, `mes1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `not` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ksekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `bsekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=18 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ogrenciekle` -- CREATE TABLE IF NOT EXISTS `ogrenciekle` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `no` int(11) NOT NULL, `sinif` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `osekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `anne` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `tel1` int(11) NOT NULL, `tel2` int(11) NOT NULL, `mes1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `not` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(100) COLLATE utf8_turkish_ci NOT NULL, `ksekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `bsekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `kytsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `vsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `veli` varchar(20) COLLATE utf8_turkish_ci NOT NULL, `ob` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `om` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ss` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sg` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=100 ; -- -- Tablo döküm verisi `ogrenciekle` -- INSERT INTO `ogrenciekle` (`id`, `ad`, `dtarih`, `okul`, `no`, `sinif`, `btarih`, `puan`, `osekil`, `anne`, `baba`, `tel1`, `tel2`, `mes1`, `mes2`, `adres`, `sekil`, `dnsmn`, `not`, `idare`, `aciklama`, `ksekil`, `bsekil`, `adsoyad1`, `starih`, `syeri`, `kytsonuc`, `vsonuc`, `adsoyad2`, `veli`, `ob`, `om`, `ss`, `sg`, `sn`) VALUES (64, 'CEMİLE', '', 'dfsfs', 0, 'dfsf', '', 0, 'İlkokul', '', 'dfsfsf', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', 'Seviye sınıfı belirlendi', '', ''), (65, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (66, 'CEMİLE', '', 'dfsfs', 0, 'dfsf', '', 0, 'İlkokul', '', 'dfsfsf', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', 'Seviye sınıfı belirlendi', '', ''), (67, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (68, 'CEMİLEsdadas', '', 'ssss', 0, '', '', 0, 'Anaokulu', '', '', 0, 0, '', '', '', ' Sosyal Medya', '', '', '', '', ' ', '', '', '', '', '', '', '', 'Baba', '', '', 'Seviye sınıfı belirlendi', '', ''), (69, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (70, 'CEMİLEddssf', '', 'dsfsdfs', 0, 'dfsdfsd', '', 0, 'Anaokulu', 'dsfsdfs', '', 0, 0, '', '', '', ' Sosyal Medya', '', '', '', '', ' ', '', '', '2012/12/12', '', '', '', '', '', '', 'Öğrenci ile mülakat yapıldı', '', '', ''), (71, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (72, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (73, 'CEMİLE', '', 'dfsfs', 0, '', '', 0, 'İlkokul', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (74, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (75, 'fsdsf', '', '', 0, '', '', 0, 'Anaokulu', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (76, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (77, 'fsdsf', '', 'dfsfs', 0, 'dfsf', '', 0, 'İlkokul', '', 'dfsfsf', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (78, 'fsdsf', '', 'dfsfs', 0, '', '', 300, 'Anaokulu', 'dsfsfsf', '', 0, 0, '', '', '', ' Sosyal Medya', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (79, 'fsdsf', '', 'sfsdfsdf', 0, '4a', '', 0, 'Anaokulu', 'dsfsfsf', '', 0, 0, 'dffdsfs', '', 'dfsdfs', ' Sosyal Medya', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (80, 'CEMİLE', '', '', 0, '', '', 0, 'İlkokul', 'dsfsfsf', '', 0, 0, '', '', '', ' Okulumuz velileri', '', '', 'fjgkdfdj', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (81, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (82, 'asaas', '', 'dsdsds', 0, 'dsds', '', 0, 'İlkokul', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (83, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (84, 'sadasda', '', 'sdasda', 0, '', '', 0, 'Ortaokul', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (85, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (86, 'CEMİLE', '', 'sfsdfsdf', 0, 'dfsf', '', 0, 'Anaokulu', 'dsfsfsf', '', 15464646, 0, '', '', 'jdsjaksjdlask', ' Reklam', 'djjjfjfj', '', 'dsadada', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (87, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (88, 'CEMİLE', '', 'sfsdfsdf', 0, 'dfsf', '', 0, 'Ortaokul', 'dsfsfsf', '', 15464646, 0, '', '', 'jdsjaksjdlask', ' Reklam', 'djjjfjfj', '', 'dsadada', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (89, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (90, 'CEMİLE', '', 'sfsdfsdf', 0, 'dfsf', '', 0, 'Ortaokul', 'dsfsfsf', '', 15464646, 0, '', '', 'jdsjaksjdlask', ' Reklam', 'djjjfjfj', '', 'dsadada', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (91, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (92, 'CEMİLE', '', 'dfsfs', 0, 'dfsf', '', 0, 'Ortaokul', 'dsfsfsf', 'dfsfsf', 0, 0, '', '', 'sssdss', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (93, 'CEMİLE', '', 'dfsfs', 0, 'dfsf', '', 300, 'Anaokulu', '', '', 15464646, 0, '', '', '', ' Sosyal Medya Okulumuz velileri', 'dfsdfsdf', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (94, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (95, 'CEMİLEkkk', '', '', 0, 'dfsf', '', 0, 'Anaokulu', 'dsfsfsf', '', 0, 0, '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (96, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (97, '', '', '', 0, '', '', 0, '', '', '', 0, 0, '', '', '', ' ', '', '', '', '', ' ', '', '', '', '', '', '', '', '', '', '', '', '', ''), (98, 'CEMİLE', '12.12.2019', 'dfsfs', 1355153, 'dfsf', '21353543', 300, 'Anaokulu', 'dsfsfsf', 'dfsfsf', 15464646, 54684684, 'dffdsfs', 'fsdfsdf', 'dfsfsf', ' Reklam', 'dfsdfsdf', '', 'dfsfsf', 'sdadsasd', ' ', '', 'dddd', '2012/12/12', 'sdsdd', '', '', '', '', '', 'Öğrenci ile mülakat yapıldı', '', '', ''), (99, 'CEMİLE', '12.12.2019', 'dfsfs', 1355153, 'dfsf', '21353543', 0, 'İlkokul', 'dsfsfsf', '', 15464646, 0, 'dffdsfs', '', 'dfsfsf', ' Reklam', 'dfsdfsdf', '', 'fjgkdfdj', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `ortaokul` -- CREATE TABLE IF NOT EXISTS `ortaokul` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dtarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `okul` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `no` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `sinif` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `btarih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `puan` int(11) NOT NULL, `osekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `anne` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `baba` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `tel1` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `tel2` varchar(11) COLLATE utf8_turkish_ci NOT NULL, `mes1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `mes2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adres` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sekil` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `dnsmn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `nott` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `idare` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `aciklama` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ob` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `om` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ss` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sg` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sn` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `veli` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad1` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `starih` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `syeri` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `kytsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `vsonuc` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `adsoyad2` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Tablo için tablo yapısı `uye` -- CREATE TABLE IF NOT EXISTS `uye` ( `id` int(11) NOT NULL AUTO_INCREMENT, `kadi` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `sifre` varchar(50) COLLATE utf8_turkish_ci NOT NULL, `ad` varchar(50) COLLATE utf8_turkish_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=31 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;