connect_error) { die("Connection failed: " . $conn->connect_error); }*/ //echo "Connected successfully"; if(is_array($_FILES)) { $ad=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-first-name"]))); $soyad=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-last-name"]))); $babaad=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-father"]))); $telefon=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-telephone"]))); $sinavyeri=mysqli_real_escape_string($conn, htmlspecialchars($_POST["sinavyeri"])); $whatsapp=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-telephone2"]))); $kurallar=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["sinavkurallari"]))); $mezunokul=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-mezun-okul"]))); $telefon=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-telephone"]))); $email=mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-email"])); $annebabatelefon=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-motherfather-phone"]))); $babasoyad=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-father-lname"]))); $annead=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-mother"]))); $annesoyad=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-mother-lname"]))); $dogumyerioblast=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-dogum-oblast"]))); $dogumyerirayon=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-dogum-rayon"]))); $dogumtarihi=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["form-dogum-tarihi"]))); $testdili=strtoupper(mysqli_real_escape_string($conn, htmlspecialchars($_POST["testdili"]))); //if ((preg_match("/[\-]{2,}|[;]|[']|[\\\*]/", $input)) //mysql_real_escape_string $hata=0; /* if((preg_match('/\s/', $ad)) or (preg_match('/\s/', $soyad)) or (preg_match('/\s/', $email)) or (preg_match('/\s/', $telefon)) or (preg_match('/\s/', $babaad)) or (preg_match('/\s/', $babasoyad)) or (preg_match('/\s/', $annead)) or (preg_match('/\s/', $annesoyad)) or (preg_match('/\s/', $dogumyerioblast)) or (preg_match('/\s/', $dogumyerirayon)) or (preg_match('/\s/', $dogumyerirayon)) or (preg_match('/\s/', $dogumtarihi)) or (preg_match('/\s/', $annebabatelefon)) or (preg_match('/\s/', $mezunokul))) {echo " "; $hata=1;} // no whitespaces */ $query = "SELECT ad FROM kayitlar WHERE ad=? and soyad=? and telefon=?"; if ($stmt = $conn->prepare($query)){ $stmt->bind_param("sss", $ad,$soyad,$telefon); if($stmt->execute()){ $stmt->store_result(); $email_check= ""; $stmt->bind_result($email_check); $stmt->fetch(); if ($stmt->num_rows>0){ // echo "That ad already exists."; echo " "; $hata=1; exit; } } } if((preg_match('/[\'"]/', $ad)) or (preg_match('/[\'"]/', $soyad)) or (preg_match('/[\'"]/', $email)) or (preg_match('/[\'"]/', $telefon)) or (preg_match('/[\'"]/', $babaad)) or (preg_match('/[\'"]/', $babasoyad)) or (preg_match('/[\'"]/', $annead)) or (preg_match('/[\'"]/', $annesoyad)) or (preg_match('/[\'"]/', $dogumyerioblast)) or (preg_match('/[\'"]/', $dogumyerirayon)) or (preg_match('/[\'"]/', $dogumyerirayon)) or (preg_match('/[\'"]/', $dogumtarihi)) or (preg_match('/[\'"]/', $annebabatelefon)) or (preg_match('/[\'"]/', $mezunokul))) {echo " "; $hata=1;} // no whitespaces else if((preg_match('/[\/\\\\]/', $ad)) or (preg_match('/[\/\\\\]/', $soyad)) or (preg_match('/[\/\\\\]/', $email)) or (preg_match('/[\/\\\\]/', $telefon)) or (preg_match('/[\/\\\\]/', $babaad)) or (preg_match('/[\/\\\\]/', $babasoyad)) or (preg_match('/[\/\\\\]/', $annead)) or (preg_match('/[\/\\\\]/', $annesoyad)) or (preg_match('/[\/\\\\]/', $dogumyerioblast)) or (preg_match('/[\/\\\\]/', $dogumyerirayon)) or (preg_match('/[\/\\\\]/', $dogumyerirayon)) or (preg_match('/[\/\\\\]/', $dogumtarihi)) or (preg_match('/[\/\\\\]/', $annebabatelefon)) or (preg_match('/[\/\\\\]/', $mezunokul))) {echo " "; $hata=1;} // no whitespaces /* else if((preg_match('/(and|or|null|not)/i', $ad)) or (preg_match('/(and|or|null|not)/i', $soyad)) or (preg_match('/(and|or|null|not)/i', $email)) or (preg_match('/(and|or|null|not)/i', $telefon)) or (preg_match('/(and|or|null|not)/i', $babaad)) or (preg_match('/(and|or|null|not)/i', $babasoyad)) or (preg_match('/(and|or|null|not)/i', $annead)) or (preg_match('/(and|or|null|not)/i', $annesoyad)) or (preg_match('/(and|or|null|not)/i', $dogumyerioblast)) or (preg_match('/(and|or|null|not)/i', $dogumyerirayon)) or (preg_match('/(and|or|null|not)/i', $dogumyerirayon)) or (preg_match('/(and|or|null|not)/i', $dogumtarihi)) or (preg_match('/(and|or|null|not)/i', $annebabatelefon)) or (preg_match('/(and|or|null|not)/i', $mezunokul))) {echo " "; $hata=1;} // no whitespaces */ else if((preg_match('/(union|select|from|where)/i', $ad)) or (preg_match('/(union|select|from|where)/i', $soyad)) or (preg_match('/(union|select|from|where)/i', $email)) or (preg_match('/(union|select|from|where)/i', $telefon)) or (preg_match('/(union|select|from|where)/i', $babaad)) or (preg_match('/(union|select|from|where)/i', $babasoyad)) or (preg_match('/(union|select|from|where)/i', $annead)) or (preg_match('/(union|select|from|where)/i', $annesoyad)) or (preg_match('/(union|select|from|where)/i', $dogumyerioblast)) or (preg_match('/(union|select|from|where)/i', $dogumyerirayon)) or (preg_match('/(union|select|from|where)/i', $dogumyerirayon)) or (preg_match('/(union|select|from|where)/i', $dogumtarihi)) or (preg_match('/(union|select|from|where)/i', $annebabatelefon)) or (preg_match('/(union|select|from|where)/i', $mezunokul))) {echo " "; $hata=1;} // no whitespaces else if((preg_match('/(group|order|having|limit)/i', $ad)) or (preg_match('/(group|order|having|limit)/i', $soyad)) or (preg_match('/(group|order|having|limit)/i', $email)) or (preg_match('/(group|order|having|limit)/i', $telefon)) or (preg_match('/(group|order|having|limit)/i', $babaad)) or (preg_match('/(group|order|having|limit)/i', $babasoyad)) or (preg_match('/(group|order|having|limit)/i', $annead)) or (preg_match('/(group|order|having|limit)/i', $annesoyad)) or (preg_match('/(group|order|having|limit)/i', $dogumyerioblast)) or (preg_match('/(group|order|having|limit)/i', $dogumyerirayon)) or (preg_match('/(group|order|having|limit)/i', $dogumyerirayon)) or (preg_match('/(group|order|having|limit)/i', $dogumtarihi)) or (preg_match('/(group|order|having|limit)/i', $annebabatelefon)) or (preg_match('/(group|order|having|limit)/i', $mezunokul))) {echo " "; $hata=1;} // no whitespaces else if((preg_match('/(into|file|case)/i', $ad)) or (preg_match('/(into|file|case)/i', $soyad)) or (preg_match('/(into|file|case)/i', $email)) or (preg_match('/(into|file|case)/i', $telefon)) or (preg_match('/(into|file|case)/i', $babaad)) or (preg_match('/(into|file|case)/i', $babasoyad)) or (preg_match('/(into|file|case)/i', $annead)) or (preg_match('/(into|file|case)/i', $annesoyad)) or (preg_match('/(into|file|case)/i', $dogumyerioblast)) or (preg_match('/(into|file|case)/i', $dogumyerirayon)) or (preg_match('/(into|file|case)/i', $dogumyerirayon)) or (preg_match('/(into|file|case)/i', $dogumtarihi)) or (preg_match('/(into|file|case)/i', $annebabatelefon)) or (preg_match('/(into|file|case)/i', $mezunokul))) {echo " "; $hata=1;} // no whitespaces else if((preg_match('/(--|#|\/\*)/', $ad)) or (preg_match('/(--|#|\/\*)/', $soyad)) or (preg_match('/(--|#|\/\*)/', $email)) or (preg_match('/(--|#|\/\*)/', $telefon)) or (preg_match('/(--|#|\/\*)/', $babaad)) or (preg_match('/(--|#|\/\*)/', $babasoyad)) or (preg_match('/(--|#|\/\*)/', $annead)) or (preg_match('/(--|#|\/\*)/', $annesoyad)) or (preg_match('/(--|#|\/\*)/', $dogumyerioblast)) or (preg_match('/(into|file|case)/i', $dogumyerirayon)) or (preg_match('/(into|file|case)/i', $dogumyerirayon)) or (preg_match('/(into|file|case)/i', $dogumtarihi)) or (preg_match('/(--|#|\/\*)/', $annebabatelefon)) or (preg_match('/(--|#|\/\*)/', $mezunokul))) {echo " "; $hata=1;} // no whitespaces else if((preg_match('/(=|&|\|)/', $ad)) or (preg_match('/(=|&|\|)/', $soyad)) or (preg_match('/(=|&|\|)/', $email)) or (preg_match('/(=|&|\|)/', $telefon)) or (preg_match('/(=|&|\|)/', $babaad)) or (preg_match('/(=|&|\|)/', $babasoyad)) or (preg_match('/(=|&|\|)/', $annead)) or (preg_match('/(=|&|\|)/', $annesoyad)) or (preg_match('/(=|&|\|)/', $dogumyerioblast)) or (preg_match('/(=|&|\|)/', $dogumyerirayon)) or (preg_match('/(=|&|\|)/', $dogumyerirayon)) or (preg_match('/(=|&|\|)/', $dogumtarihi)) or (preg_match('/(=|&|\|)/', $annebabatelefon)) or (preg_match('/(=|&|\|)/', $mezunokul))) {echo " "; $hata=1;} // no whitespaces $klasor=$ad."---".$telefon."---".$annebabatelefon; $file = $_FILES['image']['tmp_name'][0]; $sourceProperties = getimagesize($file); $fileNewName =$ad."---".$telefon."---".$annebabatelefon."---fotograf"; $folderPath = "belgeler/".$klasor; $ext = pathinfo($_FILES['image']['name'][0], PATHINFO_EXTENSION); $imageType = $sourceProperties[2]; $resim=$fileNewName.".".$ext; $file2 = $_FILES['image']['tmp_name'][1]; $sourceProperties2 = getimagesize($file2); $fileNewName2 =$ad."---".$telefon."---".$annebabatelefon."---kimlik"; $folderPath2 = "belgeler/".$klasor; $ext2 = pathinfo($_FILES['image']['name'][1], PATHINFO_EXTENSION); $imageType2 = $sourceProperties2[2]; $resim2=$fileNewName2.".".$ext2; $file3 = $_FILES['image']['tmp_name'][2]; $sourceProperties3 = getimagesize($file3); $fileNewName3 =$ad."---".$telefon."---".$annebabatelefon."---ogrenci"; $folderPath3 = "belgeler/".$klasor; $ext3 = pathinfo($_FILES['image']['name'][2], PATHINFO_EXTENSION); $imageType3 = $sourceProperties3[2]; $resim3=$fileNewName3.".".$ext2; if($hata==0){ $query = "INSERT INTO kayitlar (ad, soyad, email, telefon, whatsapp, babaad, babasoyad, annead, annesoyad, dogumyerioblast, dogumyerirayon, dogumtarihi, sinavdili, sinavyeri, resim, kimlikbelgesi, ogrencibelgesi,annebabatelefon,mezunokul,okudumu) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; $stmt = $conn->prepare($query); $stmt->bind_param("ssssssssssssssssssss", $ad, $soyad, $email, $telefon, $whatsapp, $babaad, $babasoyad, $annead, $annesoyad, $dogumyerioblast, $dogumyerirayon, $dogumtarihi, $testdili, $sinavyeri, $resim, $resim2, $resim3, $annebabatelefon, $mezunokul, $kurallar); $stmt->execute(); if($stmt) { $klasor=$ad."---".$telefon."---".$annebabatelefon; $location = "belgeler/".$klasor; if(!is_dir($location)){ mkdir($location, 0777); } $location .= "/".$fileNewName; $location2 = "belgeler/".$klasor; $location2 .= "/".$fileNewName2; $location3 = "belgeler/".$klasor; $location3 .= "/".$fileNewName3; /* if (!file_exists("belgeler/".$klasor)) { mkdir("belgeler/".$klasor, 0777, true); } */ //$klasor .= "/".$fileNewName; $file = $_FILES['image']['tmp_name'][0]; $sourceProperties = getimagesize($file); $fileNewName =$telefon; $folderPath = "belgeler/$klasor"; $ext = pathinfo($_FILES['image']['name'][0], PATHINFO_EXTENSION); $imageType = $sourceProperties[2]; $resim=$fileNewName.".".$ext; switch ($imageType) { case IMAGETYPE_PNG: $imageResourceId = imagecreatefrompng($file); $targetLayer = imageResize($imageResourceId,$sourceProperties[0],$sourceProperties[1]); //imagepng($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_GIF: $imageResourceId = imagecreatefromgif($file); $targetLayer = imageResize($imageResourceId,$sourceProperties[0],$sourceProperties[1]); //imagegif($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_JPEG: $imageResourceId = imagecreatefromjpeg($file); $targetLayer = imageResize($imageResourceId,$sourceProperties[0],$sourceProperties[1]); //imagejpeg($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; default: echo "Invalid Image type."; exit; break; } //move_uploaded_file($file, $folderPath. $fileNewName. ".". $ext); move_uploaded_file($file,$location.".".$ext); $file2 = $_FILES['image']['tmp_name'][1]; $sourceProperties2 = getimagesize($file2); $fileNewName2 =$ad."---".$telefon."---".$annebabatelefon."---kimlik"; $folderPath2 = "belgeler/".$klasor; $ext2 = pathinfo($_FILES['image']['name'][1], PATHINFO_EXTENSION); $imageType2 = $sourceProperties2[2]; $resim2=$fileNewName2.".".$ext2; switch ($imageType2) { case IMAGETYPE_PNG: $imageResourceId2 = imagecreatefrompng($file2); $targetLayer2 = imageResize($imageResourceId2,$sourceProperties2[0],$sourceProperties2[1]); //imagepng($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_GIF: $imageResourceId2 = imagecreatefromgif($file2); $targetLayer2 = imageResize($imageResourceId2,$sourceProperties2[0],$sourceProperties2[1]); //imagegif($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_JPEG: $imageResourceId2 = imagecreatefromjpeg($file2); $targetLayer2 = imageResize($imageResourceId2,$sourceProperties2[0],$sourceProperties2[1]); //imagejpeg($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; default: echo "Invalid Image type."; exit; break; } //move_uploaded_file($file, $folderPath. $fileNewName. ".". $ext); move_uploaded_file($file2,$location2.".".$ext2); $file3 = $_FILES['image']['tmp_name'][2]; $sourceProperties3 = getimagesize($file3); $fileNewName3 =$ad."---".$telefon."---".$annebabatelefon."---ogrenci"; $folderPath3 = "belgeler/".$klasor; $ext3 = pathinfo($_FILES['image']['name'][2], PATHINFO_EXTENSION); $imageType3 = $sourceProperties3[2]; $resim3=$fileNewName3.".".$ext3; switch ($imageType3) { case IMAGETYPE_PNG: $imageResourceId3 = imagecreatefrompng($file3); $targetLayer3 = imageResize($imageResourceId3,$sourceProperties3[0],$sourceProperties3[1]); //imagepng($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_GIF: $imageResourceId3 = imagecreatefromgif($file3); $targetLayer3 = imageResize($imageResourceId3,$sourceProperties3[0],$sourceProperties3[1]); //imagegif($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; case IMAGETYPE_JPEG: $imageResourceId3 = imagecreatefromjpeg($file3); $targetLayer3 = imageResize($imageResourceId3,$sourceProperties3[0],$sourceProperties3[1]); //imagejpeg($targetLayer,$folderPath. $fileNewName. "_thump.". $ext); break; default: echo "Invalid Image type."; exit; break; } //move_uploaded_file($file, $folderPath. $fileNewName. ".". $ext); move_uploaded_file($file3,$location3.".".$ext3); } /* $sql = "INSERT INTO kayitlar (ad, soyad, email, telefon, babaad, babasoyad, annead, annesoyad, dogumyerioblast, dogumyerirayon, dogumtarihi, sinavdili, resim,annebabatelefon,mezunokul,okudumu) VALUES ('$ad', '$soyad','$email','$telefon','$babaad','$babasoyad','$annead','$annesoyad','$dogumyerioblast','$dogumyerirayon','$dogumtarihi','$testdili','$resim','$annebabatelefon','$mezunokul','$kurallar')"; */ //echo "New record created successfully"; require 'mail/PHPMailerAutoload.php'; require 'mail/class.phpmailer.php'; require 'mail/class.smtp.php'; $mail = new PHPMailer; //$mail->SMTPDebug = 3; // Enable verbose debug output $mail->CharSet = 'UTF-8'; $mail->isSMTP(); // Set mailer to use SMTP $mail->Host = 'aerial.guzelhosting.com'; // Specify main and backup SMTP servers $mail->SMTPAuth = true; // Enable SMTP authentication $mail->Username = 'info@sinav.kirgizturkcesi.com'; // SMTP username $mail->Password = '5jU9rO0,KVA+'; // SMTP password $mail->SMTPSecure = 'ssl'; // Enable TLS encryption, `ssl` also accepted $mail->Port = 465; // TCP port to connect to $mail->From = 'info@sinav.kirgizturkcesi.com'; $mail->Sender = 'kirgizturkkizmesleklisesi@gmail.com'; $mail->setFrom('info@sinav.kirgizturkcesi.com', 'Анадолу Кыргыз-Түрк Кыздар Кесиптик Лицейи'); $mail->addAddress("$email", 'Анадолу Кыргыз-Түрк Кыздар Кесиптик Лицейи'); // Add a recipient // Name is optional $mail->addReplyTo('kirgizturkkizmesleklisesi@gmail.com', 'Анадолу Кыргыз-Түрк Кыздар Кесиптик Лицейи'); //$mail->addAttachment('/var/tmp/file.tar.gz'); // Add attachments //$mail->addAttachment('/tmp/image.jpg', 'new.jpg'); // Optional name $mail->isHTML(true); // Set email format to HTML $mail->Subject = '~Сынакка алдын-ала катталуу ийгиликтүү аткарылды~'; $mail->Body = " "; //$mail->AltBody = 'ALT İÇERİK'; if(!$mail->send()) { $mailgon=0; } else { //echo 'Message has been sent'; $mailgon=1; } if($mailgon==1) { echo " "; }//ikinci if else if($mailgon==0) { echo " "; } } else { echo " "; echo "Error: " . $sql . "
" . $conn->error; }$conn->close(); /* echo "$ad"; echo "
"; echo "$soyad"; echo "
"; echo "$email"; echo "
"; echo "$telefon"; echo "
"; echo "$babaad"; echo "
"; echo "$babasoyad"; echo "
"; echo "$annead"; echo "
"; echo "$annesoyad"; echo "
"; echo "$dogumyerioblast"; echo "
"; echo "$dogumyerirayon"; echo "
"; echo "$dogumtarihi"; echo "
"; echo "$testdili"; echo "
"; */ } } function imageResize($imageResourceId,$width,$height) { $targetWidth =200; $targetHeight =200; $targetLayer=imagecreatetruecolor($targetWidth,$targetHeight); imagecopyresampled($targetLayer,$imageResourceId,0,0,0,0,$targetWidth,$targetHeight, $width,$height); return $targetLayer; } ?>

Анадолу Кыргыз-Түрк Кыздар Кесиптик Лицейи
Сынакка алдын-ала катталуу формасы

Абитуриенттерге кулактандыруу !!!

2021/2022- окуу жылы үчүн окуу жайга Кабыл алуу сынагы 2021-жылдын ********* өткөрүлөт. Окуу жайга кирүү сынагына онлайн регистрация ********* күнүнө чейин болот. Окуу жайдын өзүндө регистрация ********** чейин уланат. Сизге ден-соолуктуу күн каалайбыз!

Төмөндөгү форманы толтуруу менен, Сынакка алдын-ала онлайн катталасыз. Маалыматыңыз туура жана толук экендигин эске алыңыз. Форманы толтуруудан мурун, экзамен жана экзамендин эрежелери жөнүндө кеңири маалыматты камтыган баракчага кириңиз.

Сынакка регистрация учурунда кандайдыр проблема болсо, биз менен байланышыңыз

Кадам 1 / 3

Өздүк маалымат:

Сынактын эреже жана шарттарын окудуңузбу?
Атыңыз
Фамилияңыз
Телефон номериңиз (000)000-000
Whatapp номериңиз(000)000-000
Электрондук почта
Сүрөтүңүз
Туулгандыгы тууралуу күбөлүк
8-класста окугандыгы тууралуу тастыктама (справка)

Кадам 2 / 3

Ата-энеңиз жөнүндө маалымат:

Атаңыздын аты
Атаңыздын фамилиясы
Апаңыздын аты
Апаңыздын фамилиясы
Ата –энеңиздин телефон номери (000)000-000

кадам 3 / 3

Сынак жана башка маалыматтарыңыз:

Туулган жериңиз (облус)
Туулган жериңиз (район)
Туулган датасы (дд.мм.гггг)
Мектебиңиздин аты
Сынак тили
Сынак адреси