Yardıma İhtiyacım var

19-10-2018, 17:53:10

Merhalar arkadaşlar 3 gündür hata nerede çözemedim artık deliricem projem tıkandı yardımcı olursanız cok sevinirim.
Sorunum formu kaydet dedikten sonra php tabloya yazdırmıyor size. Forum islem.php üzerinden çalışıyor php kodlarını ordan çekiyorum

islem.php kodları

if (isset($_POST['urunekle'])) {

$urun_seourl=seo($_POST['urun_ad']);

$kaydet=$db->prepare("INSERT INTO urun SET
    kategori_id=:kategori_id,
urun_ad=:urun_ad,
        urun_seourl=:seourl,
urun_detay=:urun_detay,
urun_fiyat=:urun_fiyat,
urun_video=:urun_video,
urun_keyword=:urun_keyword,
urun_marka=:urun_marka,
        urun_seri=:urun_seri,
        urun_model=:urun_model,
        urun_yil=:urun_yil,
        urun_yakit=:urun_yakit,
        urun_vites=:urun_vites ,
        urun_km=:urun_km,
        urun_kasa_tip=:urun_kasa_tip,
        urun_motor_gucu=:urun_motor_gucu,
        urun_motor_hacmi=:urun_motor_hacmi,
        urun_cekis_ozellik=:urun_cekis_ozellik,
        urun_kapi_tip=:urun_kapi_tip,
        urun_renk =:urun_renk,
        urun_garanti=:urun_garanti,
        urun_hasar_durum=:urun_hasar_durum,
        urun_plaka_uyruk=:urun_plaka_uyruk,
        urun_kimden=:urun_kimden,
        urun_takas=:urun_takas,
        urun_durum=:urun_durum,
        urun_onecikar      
");
$insert=$kaydet->execute(array(
'kategori_id'=>$_POST['kategori_id'],
'urun_ad'=>$_POST['urun_ad'],
'seourl'=>$urun_seourl,
'urun_detay'=>$_POST['urun_detay'],
'urun_fiyat'=>$_POST['urun_fiyat'],
'urun_video'=>$_POST['urun_video'],
'urun_keyword'=>$_POST['urun_keyword'],
'urun_marka'=>$_POST['urun_marka'],
        'urun_seri'=>$_POST['urun_seri'],
        'urun_model'=>$_POST['urun_model'],
        'urun_yil'=>$_POST['urun_yil'],
        'urun_yakit'=>$_POST['urun_yakit'],
        'urun_vites'=>$_POST['urun_vites'],
        'urun_km'=>$_POST['urun_km'],
        'urun_kasa_tip'=>$_POST['urun_kasa_tip'],
        'urun_motor_gucu'=>$_POST['urun_motor_gucu'],
        'urun_motor_hacmi'=>$_POST['urun_motor_hacmi'],
        'urun_cekis_ozellik'=>$_POST['urun_cekis_ozellik'],
        'urun_kapi_tip'=>$_POST['urun_kapi_tip'],
        'urun_renk'=>$_POST['urun_renk'],
        'urun_garanti'=>$_POST['urun_garanti'],
        'urun_hasar_durum'=>$_POST['urun_hasar_durum'],
        'urun_plaka_uyruk'=> $_POST['urun_plaka_uyruk'],
        'urun_kimden'=>$_POST['urun_kimden'],
        'urun_takas'=>$_POST['urun_takas'],
        'urun_durum'=>$_POST['urun_durum'],
        'urun_durum'=>$_POST['onecikar']
 

));

if ($insert) {

Header("Location:../production/urun.php?durum=ok");

} else {

Header("Location:../production/urun.php?durum=no");
}

}

Forum kodları

<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>Ürün Düzenleme <small>,

              <?php

              if ($_GET['durum']=="ok") {?>

              <b style="color:green;">İşlem Başarılı...</b>

              <?php } elseif ($_GET['durum']=="no") {?>

              <b style="color:red;">İşlem Başarısız...</b>

              <?php }

              ?>


            </small></h2>
       
            <div class="clearfix"></div>
          </div>
          <div class="x_content">
            <br />

            <!-- / => en kök dizine çık ... ../ bir üst dizine çık -->
            <form action="../netting/islem.php" method="POST" id="demo-form2" data-parsley-validate class="form-horizontal form-label-left">



              <!-- Kategori seçme başlangıç -->


              <div class="form-group">
              <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Kategori Seç<span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-6">

                  <?php  

                  $urun_id=$uruncek['kategori_id'];

                  $kategorisor=$db->prepare("select * from kategori where kategori_ust=:kategori_ust order by kategori_sira");
                  $kategorisor->execute(array(
                    'kategori_ust' => 0
                    ));

                    ?>
                    <select class="select2_multiple form-control" required="" name="kategori_id" >


                     <?php

                     while($kategoricek=$kategorisor->fetch(PDO::FETCH_ASSOC)) {

                       $kategori_id=$kategoricek['kategori_id'];

                       ?>

                       <option <?php if ($kategori_id==$urun_id) { echo "selected='select'"; } ?> value="<?php echo $kategoricek['kategori_id']; ?>"><?php echo $kategoricek['kategori_ad']; ?></option>

                       <?php } ?>

                     </select>
                   </div>
                 </div>


                 <!-- kategori seçme bitiş -->


                 <div class="form-group">
                  <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Ürün Ad <span class="required">*</span>
                  </label>
                  <div class="col-md-6 col-sm-6 col-xs-12">
                    <input type="text" id="first-name" name="urun_ad" placeholder="Urun Adını Giriniz" required="required" 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">Ürün Detay <span class="required">*</span>
                  </label>
                  <div class="col-md-6 col-sm-6 col-xs-12">

                    <textarea  class="ckeditor" id="editor1" name="urun_detay" placeholder="Detaylı Bilgi Giriniz.."> </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">Ürün marka <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_marka" placeholder="ürün marka 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"> seri <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_seri" placeholder="Seri Bilgisi 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"> model <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_model" placeholder="Model Bilgisi 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"> yakit <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_yakit" placeholder="Yakit Bilgisi 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"> vites <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_vites" placeholder="Vites Bilgisi 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"> km <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_km" placeholder="Km Bilgisi 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"> kasa_tip <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_kasa_tip" placeholder="Kasa Tipi 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"> motor_gucu <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_motor_gucu" placeholder="Motor Gucu Bilgisi"  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"> motor_hacmi <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_motor_hacmi" placeholder="Motor Hacmi"  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"> cekis_ozellik <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_cekis_ozellik" placeholder="Cekiş Özellik"  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"> kapi_tip <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_kapi_tip" placeholder="Kapi Tipi" 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"> renk <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_renk" placeholder="Renk Bilgisi" 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"> garanti <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_garanti" placeholder="Garanti Durumu"  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"> hasar_durum <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_hasar_durum" placeholder="Hasar Durumu"  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"> plaka_Uyruk <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_plaka_uyruk" placeholder="Plaka Durumu"  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"> kimden <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_kimden" placeholder="Kimden"  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"> takas <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_takas" placeholder="Takas" 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">Ürün Fiyat <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_fiyat" placeholder="Fiyat Bilgisi 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">Ürün Video <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_video" placeholder="Video 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">Ürün Keyword <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_keyword" placeholder="Keyword 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">KM <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <input type="text" id="first-name" name="urun_km" placeholder="Km Bilgisi 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">Ürün Öne Çıkar<span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                 <select id="heard" class="form-control" name="urun_onecikar" required>



                  <option value="1" >Evet</option>



                  <option value="0" >Hayır</option>
             

                 </select>
               </div>
             </div>



              <div class="form-group">
                <label class="control-label col-md-3 col-sm-3 col-xs-12" for="first-name">Ürün Durum<span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                 <select id="heard" class="form-control" name="urun_durum" required>


                  <option value="1">Aktif</option>



                  <option value="0">Pasif</option>
       

                 </select>
               </div>
             </div>


             <input type="hidden" name="urun_id" value="<?php echo $uruncek['urun_id'] ?>">


             <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="urunekle" class="btn btn-success">Kaydet</button>
              </div>
            </div>

          </form>



        </div>
      </div>
    </div>
  </div>



  <hr>
  <hr>
  <hr>



</div>
</div>

Tablo yapısı

urun_id
kategori_id
urun_zaman
urun_ad
urun_seourl
urun_detay
urun_fiyat
urun_video
urun_keyword
urun_marka
urun_seri
urun_model
urun_yil
urun_yakit
urun_vites
urun_km
urun_kasa_tip
urun_motor_gucu
urun_motor_hacmi
urun_cekis_ozellik
urun_kapi_tip
urun_renk
urun_garanti
urun_hasar_durum
urun_plaka_uyruk
urun_kimden
urun_takas
urun_durum
urun_onecikar

19-10-2018, 18:15:12

Scarecrow

PDO'da insert işlemini aşağıdaki gibi kullanın:

$query = $db->prepare("INSERT INTO uyeler SET uye_kadi = ?, uye_sifre = ?, uye_eposta = ?"); $insert = $query->execute(array("asd", "asd2", "asd3" ));

Edit:

Birde if($kaydet) deyin oradada hata var.

19-10-2018, 18:40:47

#3

bybb35
Scarecrow adlı üyeden alıntı: mesajı görüntüle
PDO'da insert işlemini aşağıdaki gibi kullanın:

$query = $db->prepare("INSERT INTO uyeler SET uye_kadi = ?, uye_sifre = ?, uye_eposta = ?"); $insert = $query->execute(array("asd", "asd2", "asd3" ));
Edit:

Birde if($kaydet) deyin oradada hata var.
hocam tam nerde hata hangi satırda biraz acemiyim çözemedim ayrıca PDO dediğiniz satır neresi oluyor,Biraz kopya çekerek yazıyorum ben ondan tam hakim değilim
19-10-2018, 21:56:00

#4

mikoc

bybb35 adlı üyeden alıntı: mesajı görüntüle

hocam tam nerde hata hangi satırda biraz acemiyim çözemedim ayrıca PDO dediğiniz satır neresi oluyor,Biraz kopya çekerek yazıyorum ben ondan tam hakim değilim

Güvenlik açığı hakkında bir bilgi eklemek istiyorum. Projelerinizde:
$_POST['kategori_id'],
bu şekilde formdan gelen verilerinizi
strip_tags($_POST['kategori_id']);
bu şekilde kullanın