• 02-09-2021, 22:14:43
    #1
    merhaba panelime tc kimlik eklettirdim doğrulama çalışıyor fakat veritabanına kayıt olmuyor yardımcı olurmusunuz kodlar bunlar :

    HTML :
    <!doctype html>
    <html>
    <head>
    <meta charset="utf-8">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title><?=$title?></title>
    <link rel="shortcut icon" type="image/x-icon" href="<?=$page->LoadTheme_File('img/favicon.png');?>">
    <link rel="stylesheet" href="<?=$page->LoadTheme_File('oyunkurucum_login/css/bootstrap.min.css');?>">
    <link rel="stylesheet" href="<?=$page->LoadTheme_File('oyunkurucum_login/css/fontawesome-all.min.css');?>">
    <link rel="stylesheet" href="<?=$page->LoadTheme_File('oyunkurucum_login/font/flaticon.css');?>">
    <link href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700&amp;display=swap " rel="stylesheet">
    <link rel="stylesheet" href="<?=$page->LoadTheme_File('oyunkurucum_login/style.css');?>">
    </head>
    <body style="background-image: url('img/bg.jpg');">
    <section class="fxt-template-animation fxt-template-layout16">
    <div class="container">
    <div class="alert alert-bg-danger">
    <?php if( strlen($message) > 0 ): ?>
    <div class="alert alert-info">
    <?php echo $message; ?>
    </div>
    <?php endif; ?>
    </div>
    <div class="row align-items-center justify-content-center">
    <div class="col-xl-6 col-lg-7 col-sm-12 col-12 fxt-bg-color">
    <div class="fxt-content">
    <div class="fxt-header">
    </div>
    <div class="fxt-form">
    <form action="" method="POST">

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Adınız" class="form-control" name="user_name" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Soyadınız" class="form-control" name="user_lastname" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Doğum Yılınız" maxlength="4" class="form-control" name="user_year" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="TC Kimlik No" maxlength="11" class="form-control" name="user_tc" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Kullanıcı Adı" class="form-control" name="user_email" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="email" placeholder="E-posta Adresi" class="form-control" name="user_email2" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="password" placeholder="Kullanıcı Şifre" class="form-control" name="user_pass" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Şehir" class="form-control" name="user_city" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="text" placeholder="Adres" class="form-control" name="user_address" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-1">
    <input type="number" placeholder="Telefon" class="form-control" name="user_telephone" maxlength="11" required>
    </div>
    </div>

    <div class="form-group">
    <div class="fxt-transformY-50 fxt-transition-delay-4">
    <button type="submit"name="ogcp_adduser" class="fxt-btn-fill">Hızlı Erişim</button>
    </div>
    </div>

    </form>
    </div>
    <div class="fxt-footer">
    <div class="fxt-transformY-50 fxt-transition-delay-9">
    <p>Zaten Bir Hesabınız Varmı?<a href="<?php echo $page->CreatePageLink('Giris'); ?>" class="switcher-text2 inline-text"> O Zaman Giriş Yapın</a></p>
    <p><a href="Sifremi_Unuttum.html" class="switcher-text2 inline-text"> Şifremi Yenile</a></p>
    </div>
    </div>
    </div>
    </div>
    </div>
    </div>
    </section>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/jquery-3.5.0.min.js');?>"></script>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/popper.min.js');?>"></script>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/bootstrap.min.js');?>"></script>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/imagesloaded.pkgd.min.js');?>"></script>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/validator.min.js');?>"></script>
    <script src="<?=$page->LoadTheme_File('oyunkurucum_login/js/main.js');?>"></script>
    </body>
    </html>

    PHP :

    <?php
    $title = $pages[$cur_page]["Name"]." - ".HCSGP_DEFTITLE;
    $durum = FALSE;
    $message = '';

    function karakterDuzelt($yazi){
    $ara=array("ç","i","ı","ğ","ö","ş","ü");
    $degistir=array("Ç","İ","I","Ğ","Ö","Ş","Ü") ;
    $yazi=str_replace($ara,$degistir,$yazi);
    $yazi=strtoupper($yazi);
    return $yazi;
    }

    if( isset($_POST["ogcp_adduser"]) ) {
    $_POST["user_group"] = 1;
    if(@$_POST["user_email"] != "" && @$_POST["user_year"] != "" && @$_POST["user_lastname"] != "" && @$_POST["user_tc"] != "" && @$_POST["user_pass"] != "" && @$_POST["user_name"] != "" && @$_POST["user_city"] != "" && @$_POST["user_address"] != "" && @$_POST["user_telephone"] != "" && (int)@$_POST["user_group"] > 0 && (int)@$_POST["user_group"] < 4) {

    $_POST["ShowMachine"] = 0;
    $_POST["ShowServers"] = 0;
    $_POST["ShowUsers"] = 0;
    $_POST["ShowAnnouncements"] = 0;
    $_POST["ShowTickets"] = 0;
    $_POST["ShowPlugins"] = 0;
    $_POST["ShowFiles"] = 0;

    if (!filter_var($_POST["user_email2"], FILTER_VALIDATE_EMAIL)) {
    $message = "Geçerli bir Email Adresi girin!";
    }
    else{
    $ad = karakterDuzelt(trim($_POST["user_name"]));
    $soyad = karakterDuzelt(trim($_POST["user_lastname"]));
    $tcKimlikNo = $_POST["user_tc"];
    $dogumYili = $_POST["user_year"];

    function tcno_dogrula($bilgiler){
    $gonder = '<?xml version="1.0" encoding="utf-8"?>
    <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Body>
    <TCKimlikNoDogrula xmlns="http://tckimlik.nvi.gov.tr/WS">
    <TCKimlikNo>'.$bilgiler["tcno"].'</TCKimlikNo>
    <Ad>'.$bilgiler["isim"].'</Ad>
    <Soyad>'.$bilgiler["soyisim"].'</Soyad>
    <DogumYili>'.$bilgiler["dogumyili"].'</DogumYili>
    </TCKimlikNoDogrula>
    </soap:Body>
    </soap:Envelope>';

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, "https://tckimlik.nvi.gov.tr/Service/KPSPublic.asmx" );
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true );
    curl_setopt($ch, CURLOPT_POST, true );
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_HEADER, FALSE);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $gonder);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array(
    'POST /Service/KPSPublic.asmx HTTP/1.1',
    'Host: tckimlik.nvi.gov.tr',
    'Content-Type: text/xml; charset=utf-8',
    'SOAPAction: "http://tckimlik.nvi.gov.tr/WS/TCKimlikNoDogrula"',
    'Content-Length: '.strlen($gonder)
    ));
    $gelen = curl_exec($ch);
    curl_close($ch);

    return strip_tags($gelen);
    }

    $bilgiler = array(
    "isim" => $ad,
    "soyisim" => $soyad,
    "dogumyili" => $dogumYili,
    "tcno" => $tcKimlikNo
    );
    $adsoyad = $_POST["user_name"]." ".$_POST["user_lastname"];

    $sonuc = tcno_dogrula($bilgiler);

    if($sonuc=="true"){
    $status = Adm_AddUser($_POST["user_email"],$_POST["user_email2"],$_POST["user_comment"],$_POST["user_pass"],$adsoyad,$_POST["user_city"],$_POST["user_address"],$_POST["user_telephone"],$_POST["user_group"],$_POST["ShowMachine"],$_POST["ShowServers"],$_POST["ShowUsers"],$_POST["ShowAnnouncements"],$_POST["ShowTickets"],$_POST["ShowPlugins"],$_POST["ShowFiles"]);

    if($status > 0) {
    $message = "Kayıt Başarılı! Yönlendiriliyorsunuz..";
    echo '<meta http-equiv="refresh" content="1;URL='.$page->CreatePageLink('Giris').'" />';
    } else if($status == -1){
    $message = "Böyle bir kullanıcı sistemde mevcut!!";
    } else {
    $message = "Hata Oluştu!";
    }
    }
    else{
    $message = "Girilen Kimlik Bilgileri Uyuşmuyor!";
    }

    }

    } else {
    $message = "Alanları Kontrol Edin!";
    }
    }
  • 02-09-2021, 22:25:10
    #2
    Merhaba, kimlik bilgisi gibi kişisel verileri işleme izniniz bulunmuyor ise bu bilgileri kayıt etmeniz sorun teşkil edebilir
  • 02-09-2021, 22:34:45
    #3
    Az önce bunun ile ilgili bir konu açtım fakat bu tarz saklama olayları yasak Tıkla ve ulaş!
  • 16-10-2021, 00:13:52
    #4
    veri tabanındaki tc kaydettiğin tablodaki sutunun degerini bigint yap duzelir