<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
            <script type="text/javascript" src="jscript.js">

            function rem(id,stock)
            {
              //first function
              window.alert("konichiwa");
                var myobject = {
                      id : id,
                      stock : stock - 1
                }
                request = $.ajax({
                      url: "reportFunction.php",
                      type: "post",
                      data:JSON.stringify(myobject),
                      success : location.reload()
                  });
            }
            //Add to daily report
            function add(id,name,descrip,date,active,stock){
              window.alert("Hello"+ id + name + descrip + date + active + stock);
              var Sobject = {
                stock : stock;
                name : name;
                descrip : descrip;
                date: date;
                active : active;
              }
              request = $.ajax({
                    url: "reportAdd.php",
                    type: "post",
                    data:JSON.stringify(Sobject),
                    success :location.reload()
                });
            }
            </script>

<?php
            //conection
            $user="------";
            $password="------";
            $database="----------";

            $conn = mysqli_connect("localhost",$user,$password);
            if(! $conn )
            {
              echo "Error counld not connect";
              die('Could not connect: ' . mysql_error());
            }

            //$sql = 'SELECT name,descrip FROM pstock';
            mysqli_select_db($conn,"bluehatm_minimart");
            $retval = mysqli_query( $conn, 'SELECT * FROM pstock');
            if(! $retval )
            {
              echo "Error1";
              die('Could not get data: ' . mysql_error());
            }

            $sqi = "SELECT id,name,descrip,mydate,active,stock FROM pstock";
            echo "<br>";
            //display result
            $result = $conn->query($sqi);
            if ($result->num_rows > 0) {

                echo "<table align= 'center'><tr><th>ID</th><th>Name</th><th>Description</th><th>Date</th><th>Active</th><th>Stock</th></tr>";
                // output data of each row
                while($row = $result->fetch_assoc()) {
                    $rownum = $row["id"];
                    $rowStock = $row["stock"];
                    $rowName = $row["name"];
                    $rowDescrip = $row["descrip"];
                    $rowDate = $row["mydate"];
                    $rowActive = $row["active"];
                    echo "<tr><td>".$row["id"]."</td><td><a style='color:black;' value = '$rownum' id = 'updateme' onclick='updatethis($rownum);return false;' href = 'index.php'/>".$row["name"]."</td><td>".$row["descrip"]."</td><td>".$row["mydate"]."</td><td>".$row["active"]."</td><td>".$row["stock"]."</td><td>
                    <input type= 'button' value = 'SOLD 1' onclick = 'rem($rownum,$rowStock)'>
                    <input type= 'button' value = 'Add to Daily Report' onclick = 'add($rownum,$rowName,$rowDescrip,$rowDate,$rowActive,$rowStock)'>
                    </td></tr>";
                }
                echo "</table>";
            } else {
                echo "0 results";
            }
            $conn->close();
            ?>
            </body>