D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
thread-self
/
root
/
home
/
shubmkcj
/
urbane.createerp.com
/
Filename :
getitemCode.php
back
Copy
<?php $q = $_POST['txtitemcode']; include 'config.php'; $sql = "SELECT * FROM inventory where `item_code` = '$q'"; // echo $sql; $result = mysqli_query($conn,$sql); //while($row = mysqli_fetch_array($result)) { $row = mysqli_fetch_assoc($result); echo json_encode($row); //echo "<div class='row col-md-12'><div class='form-group col-md-2'><label for='exampleInputEmail1'>Price</label><input class='form-control' id='edValue' onInput='edValueKeyPress()' name='price' type='text' value='".$abc = $row['selling_price']."' ></div><div class='form-group col-md-2'><label for='exampleInputEmail1'>Quantity</label><input type='text' class='form-control' value='".$qty = '1'."'></div><div class='form-group col-md-3'><label for='exampleInputEmail1'>Tax</label><input type='text' class='form-control' placeholder='Enter tax'></div>"; // $total = $abc * $qty ; //echo "<div class='col-md-3'><label for='exampleInputEmail1'>Total</label><input type='text' class='form-control' value='".$total."' readonly></div><div class='form-group col-md-2 py-4 change1'><a class='btn btn-success waves-effect waves-light add-more1'>Add <i class='mdi mdi-plus-circle-outline'></i></a></div></div>"; //} mysqli_close($conn); ?>