This question already has an answer here:

PHP Error: Mysqli_real_escape_string() expects exactly 2 parameters, 1 given 5 answers
Reference: What is variable scope, which variables are accessible from where and what are “undefined variable” errors? 3 answers
Reference — What does this symbol mean in PHP? 18 answers
Reference - What does this error mean in PHP? 34 answers
mysqli_fetch_assoc() expects parameter / Call to a member function bind_param() errors. How to get the actual mysql error? 1 answer

my code is below. I have field all the form values and click save but couldn't enter inside first if which is if(isset($_POST['productNames']) & isset($_POST['productCode']) & isset($_POST['barcode']) & isset($_POST['starterAmount']) & isset($_POST['buyingFee']) & isset($_POST['sellingFee']) & isset($_POST['KDV'])) but I don't know why. Could anyone help me?

<?php
session_start();
  include_once("../connection.php");
/*...*/
function saveData() {
    $productNames   = mysqli_real_escape_string($_POST['productNames']);
    $productCode    = mysqli_real_escape_string($_POST['productCode']);
    $barcode        = mysqli_real_escape_string($_POST['barcode']);
    if(!empty($_POST('category'))) {
      $category     = mysqli_real_escape_string($_POST['category']);
    }
    else {
      $category     = "Kategori yok";
    }
    $starterAmount  = mysqli_real_escape_string($_POST['starterAmount']);
    $buyingFee      = mysqli_real_escape_string($_POST['buyingFee']);
    $sellingFee     = mysqli_real_escape_string($_POST['sellingFee']);
    $KDV            = mysqli_real_escape_string($_POST['KDV']);
    if(!empty($_POST('OIV'))) {
      $OIV          = mysqli_real_escape_string($_POST['OIV']);
    }
    else {
      $OIV          = "0,00";
    }
    if(!empty($_POST('sOTV'))) {
      $sOTV         = mysqli_real_escape_string($_POST['sOTV']);
    }
    else {
      $sOTV         = "0,00";
    }
    if(!empty($_POST('bOTV'))) {
      $bOTV         = mysqli_real_escape_string($_POST['bOTV']);
    }
    else {
      $bOTV         = "0,00";
    }
    if(!empty($_POST('discount'))) {
      $discount     = mysqli_real_escape_string($_POST['discount']);
    }
    else {
      $discount     = "0,00";
    }
    $tableName      = "stc_def_tab_4_c_" . $companyID;
    $addNew         = "INSERT INTO `$tableName` (`productNames`, `productCode`, `barcode`, `category`, `starterAmount`, `buyingFee`, `sellingFee`, `KDV`, `OIV`, `sOTV`, `bOTV`, `discount`, `firstAdded`) VALUES ('$productNames', '$productCode', '$barcode', '$category', $starterAmount, $buyingFee, $sellingFee, $KDV, $OIV, $sOTV, $bOTV, $discount, CURDATE())";
    if($connection->query($addNew)){
      header('location: services-and-products.php');
    } else{
      $emsg       = "ERROR: Could not able to execute $addNew. " . mysqli_error($connection);
    }
  }
  if(isset($_POST['productNames']) & isset($_POST['productCode']) & isset($_POST['barcode']) & isset($_POST['starterAmount']) & isset($_POST['buyingFee']) & isset($_POST['sellingFee']) & isset($_POST['KDV'])) {
    if(isset($_POST['Save'])) {
      saveData();
    }
    elseif(isset($_POST['SaveCont'])) {
      saveData();
    }
  }
  else {
    $emsg2          = "Fill required areas.";
  }
?>

<!-- ... -->
<form action="" method="post">
                  <?php if(isset($emsg)){ ?>
                    <div class="alert alert-danger" role="alert"> <?php echo $emsg; ?></div>
                  <?php } ?>
                  <?php if(isset($emsg2)){ ?>
                    <div class="alert alert-danger" role="alert"> <?php echo $emsg2; ?></div>
                  <?php } ?>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="glyphicon glyphicon-text-color" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Adı</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="productName" placeholder="Adı" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-code" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Kodu</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="productCode" placeholder="Kodu" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-barcode" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Barkod</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="barcode" placeholder="Barkod" />
                    </div>
                    <div class="col-md-3">
                      <button class="btn btn-warning">Barkodu Tarat</button>
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-object-group" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Kategori</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="category" placeholder="Kategori" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-cube" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Başlangıç Miktarı</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="number" name="starterAmount" placeholder="0" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-sign-in" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Alış Fiyatı (Vergisiz)</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="buyingFee" placeholder="0,00" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-external-link" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Satış Fiyatı (Vergisiz)</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="sellingFee" placeholder="0,00" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-gavel" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">Vergiler</h6>
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1">
                      <h6 style="padding-top: 10%; color:gray;">KDV</h6>
                    </div>
                    <div class="col-md-2">
                      <input type="text" name="KDV" placeholder="0,00" />
                    </div>
                    <div class="col-md-1">
                      <h6 style="padding-top: 10%; color:gray;">ÖİV</h6>
                    </div>
                    <div class="col-md-2">
                      <input type="text" name="OIV" placeholder="0,00" />
                    </div>
                    <div class="col-md-1">
                      <h6 style="padding-top: 10%; color:gray;">Satış ÖTV</h6>
                    </div>
                    <div class="col-md-2">
                      <input type="text" name="sOTV" placeholder="0,00" />
                    </div>
                    <div class="col-md-1">
                      <h6 style="padding-top: 10%; color:gray;">Alış ÖTV</h6>
                    </div>
                    <div class="col-md-2">
                      <input type="text" name="bOTV" placeholder="0,00" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-1" style="vertical-align: middle;">
                      <i class="fa fa-percent" style="font-size:36px; padding-top: 10%; color:gray;"></i>
                    </div>
                    <div class="col-md-2">
                      <h6 style="padding-top: 10%; color:gray;">İndirim</h6>
                    </div>
                    <div class="col-md-6">
                      <input type="text" name="discount" placeholder="İndirim" />
                    </div>
                  </div>
                  <div class="row">
                    <div class="col-md-2">
                      <br>&nbsp;
                    </div>
                    <div class="col-md-3">
                      <center><input type="submit" id="Save" name="Save" value="Kaydet" /></center>
                      <br>
                    </div>
                    <div class="col-md-2">
                      <br>
                    </div>
                    <div class="col-md-3">
                      <center><input type="submit" id="SaveCont" name="SaveCont" value="Kaydet ve Yeni Ekle" /></center>
                      <br>
                    </div>
                    <div class="col-md-2">
                      <br>
                    </div>
                  </div>
                  <div class="row">
                    <br>&nbsp;
                  </div>
                </form>

thank you for your help.

</div>

自己下载的STC烧录软件烧不进去程序 ，一直都是正在检测单片机？

août 5

4个回复

自己下载的STC烧录软件烧不进去程序，一直都是正在检测单片机？