1#@!#!123s

: / home / shubmkcj / urbane.createerp.com /
Filename : getitemCode.php
back

<?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);
?>