OTEL-EKLE.PHP
<?php
include 'header.php';
?>
<!-- page content -->
<div class="right_col" role="main">
<div class="">
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Otel Ekleme<small>,
</small></h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<br />
<!-- / => en kök dizine çık ... ../ bir üst dizine çık -->
<form action="../erting/islem.php" method="POST" id="demo-form2" data-parsley-validate class="form-horizontal form-label-left">
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Otel Adı <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_adi" placeholder="Otel Adı Giriniz" required="required" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Otel Türü<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select id="heard" class="form-control" name="otel_turu" required>
<!-- Kısa İf Kulllanımı
<?php echo $otelcek['tesis_turu'] == '1' ? 'selected=""' : ''; ?>
-->
<option value="0" >Seçiniz</option>
<option value="1" >1 Yıldızlı</option>
<option value="2" >2 Yıldızlı</option>
<option value="3" >3 Yıldızlı</option>
<option value="4" >4 Yıldızlı</option>
<option value="5" >5 Yıldızlı</option>
</select>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Ülke<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_ulke" placeholder="Otelin bulunduğu ülkeyi yazınız" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Şehir <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_sehir" placeholder="Otelin bulunduğu şehiri yazınız" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">İlçe <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_ilce" placeholder="Otelin bulunduğu ilçe yazınız" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Adresiniz<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_adres" placeholder="Otelinizin adresini giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Telefon(ülke kodu dahil) <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_tel" placeholder="Otelin Telefonunu giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Cep Telefonu <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_cep" placeholder="Cep Telefon Numarası Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Fax(ülke kodu dahil) <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_fax" placeholder="Otelinizin Faxını Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Yetkili Kişi <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_yetkili" placeholder="Yetkili Kişiyi Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">E-mail <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_emain" placeholder="E-Mail Adresinizi Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Web Siteniz <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_url" placeholder="Otelinizin Web Sitesini Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Vergi Dairesi <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_url" placeholder="Otelin Vergi Dairesini Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Vergi Numarası <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_url" placeholder="Otelin Vergi Numarasını Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Şirket Ünvanı<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_url" placeholder="Şirket Ünvanınızı Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Fatura Adresi<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<input type="text" id="first-name" name="otel_url" placeholder="Fatura Adresini Giriniz" class="form-control col-md-7 col-xs-12">
</div>
</div>
<!-- Ck Editör Başlangıç -->
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Otel Hakkında <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<textarea class="ckeditor" id="editor1" name="otel_hakkinda"></textarea>
</div>
</div>
<script type="text/javascript">
CKEDITOR.replace( 'editor1',
{
filebrowserBrowseUrl : 'ckfinder/ckfinder.html',
filebrowserImageBrowseUrl : 'ckfinder/ckfinder.html?type=Images',
filebrowserFlashBrowseUrl : 'ckfinder/ckfinder.html?type=Flash',
filebrowserUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
filebrowserImageUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
filebrowserFlashUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash',
forcePasteAsPlainText: true
}
);
</script>
<!-- Ck Editör Bitiş -->
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Otel Durumu<span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">
<select id="heard" class="form-control" name="otel_durum" required>
<!-- Kısa İf Kulllanımı
<?php echo $otelcek['otel_durum'] == '1' ? 'selected=""' : ''; ?>
-->
<option value="1" >Aktif</option>
<option value="0" >Pasif</option>
</select>
</div>
</div>
<div class="ln_solid"></div>
<div class="form-group">
<div align="right" class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
<button type="submit" name="otelkaydet" class="btn btn-success">Kaydet</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<hr>
<hr>
<hr>
</div>
</div>
<!-- /page content -->
<?php include 'footer.php'; ?>İSLEM.PHPif (isset($_POST['otelkaydet'])) {
//Tablo Veri Ekleme
$ekle=$db->prepare("INSERT INTO oteller SET
otel_adi=:otel_adi,
otel_turu=:otel_turu,
otel_ulke=:otel_ulke,
otel_sehir=:otel_sehir,
otel_ilce=:otel_ilce,
otel_adres=:otel_adres,
otel_tel=:otel_tel,
otel_cep=:otel_cep,
otel_fax=:otel_fax,
otel_yetkili=:otel_yetkili,
otel_email=:otel_email,
otel_url=:otel_url,
otel_vdairesi=:otel_vdairesi,
otel_vnumarasi=:otel_vnumarasi,
otel_unvani=:otel_unvani,
otel_fatura=:otel_fatura,
otel_hakkinda=:otel_hakkinda,
otel_durum=:otel_durum
");
$insert=$ekle->execute(array(
'otel_adi' => $_POST['otel_adi'],
'otel_turu' => $_POST['otel_turu'],
'otel_ulke' => $_POST['otel_ulke'],
'otel_sehir' => $_POST['otel_sehir'],
'otel_ilce' => $_POST['otel_ilce'],
'otel_adres' => $_POST['otel_adres'],
'otel_tel' => $_POST['otel_tel'],
'otel_cep' => $_POST['otel_cep'],
'otel_fax' => $_POST['otel_fax'],
'otel_yetkili' => $_POST['otel_yetkili'],
'otel_email' => $_POST['otel_email'],
'otel_url' => $_POST['otel_url'],
'otel_vdairesi' => $_POST['otel_vdairesi'],
'otel_vnumarasi' => $_POST['otel_vnumarasi'],
'otel_unvani' => $_POST['otel_unvani'],
'otel_fatura' => $_POST['otel_fatura'],
'otel_hakkinda' => $_POST['otel_hakkinda'],
'otel_durum' => $_POST['otel_durum']
));
if ($insert) {
header("Location:../production/otel-ekle.php?durum=ok");
} else {
header("Location:../production/otel-ekle.php?durum=no");
}
} 