INSERT Run in XAMPP but not online

Question

INSERT Run in XAMPP but not online

Navigation

#1 by (0 votes)

0

I have configured an online server ubuntu 18.04, php 5.6, mysql 5.7.23-0ubuntu0.18.04.1 in DigitalOcean

I have developed in xampp 5.6.37 .... in windondows environment ... but I can not make this insert me work

$query_tmp=mysqli_query($con,"select * from product_tmp where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'");
$count=mysqli_num_rows($query_tmp);
if ($count==0){
    $sql=mysqli_query($con,"INSERT into product_tmp
    ( product_id, qty, unit_price, user_id, discount, branch_id, cventa)
    values ('$product_id','$qty','$unit_price', '$user_id','$descuento','$id_sucursal','$cventa')");
} else {
    $rw=mysqli_fetch_array($query_tmp);
    $actual_qty=$rw['qty'];
    $new_qty=$actual_qty+$qty;
    $update=mysqli_query($con,"update product_tmp set qty='$new_qty' where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'");
}

php xampp lampp

asked by tato165 21.09.2018 в 18:57

source

1 answer

Routine that creates ordered ID JavaScript function does not refresh the data very well

score 0 · Answer 1

Try this DO NOT FORGET TO CONFIGURE THE PARAMETERS OF THE CONNECTION TO THE DATABASE

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "select * from product_tmp where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'";

$result = $conn->query($sql);

if ($result->num_rows > 0) 
{
   $sql = "INSERT into product_tmp
( product_id, qty, unit_price, user_id, discount, branch_id, cventa)
values ('$product_id','$qty','$unit_price', '$user_id','$descuento','$id_sucursal','$cventa')";

} else {

  $actual_qty = 0;

   while($row = $result->fetch_assoc()) 
  {
     $actual_qty += $row['qty'];
  }

  $sql = "update product_tmp set qty='$actual_qty' where product_id='$product_id' and user_id='$user_id' and branch_id='$id_sucursal'";
}
?>