homepage Welcome to WebmasterWorld Guest from 54.226.136.179
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Jquery populate text box with Json return
upshire



 
Msg#: 4556097 posted 3:39 pm on Mar 18, 2013 (gmt 0)

I have a test form with two text boxes, the first text box allows me to type in a product id, and then the idea is that the second text box would be updated/display the item price, if I an get this working, I would add a few more text boxes to display a bit more info.When I use $('.results').html(data);as the success, I can display the data in a div named "result" what I am struggling with is to display one of the returned fields in a text box on the form.

This is a section of my form:

<script type="text/javascript">
$(function(){
$('#inp').keyup(function(){
var inpval = $('#inp').val();

$.ajax({
type: "POST",
data: ({p : inpval}),
dataType: '',
url:"ajax_product_list.php",
success: function(data){
//$("#item_cost").val(data[0].item_cost);
//alert(data);
//$('.results').html(data);
// $('#item_cost').html(new_data['product_id']);
//$("#item_cost").val(data[1].product_id);
$.each( data, function( key, value ) {
$( '#item_cost' + key ).val( 'item_cost' );
});
}
});
});
});

</head>

<body>
<form action="" method="post">
<label for="inp"></label>

<input type="text" name="inp" id="inp" />
<input name="item_cost" type="text" id="item_cost" />
</form>
<div class="results">Content for class "results" Goes Here

</div>

This is my query (no data cleansing shown for clarity):

<?php session_start();?>
<?php require_once('Connections/connpay.php'); ?>

<?php
$product_id = $_POST['p'];
$company_id = $_SESSION['sess_company_id'];



//* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}


$query = "SELECT * FROM acc_stock_items WHERE product_id = '$product_id' ";
if ($result = $conn->query($query)) {

/* fetch object array */
while ($row = $result->fetch_assoc()) {
$data = $row;
echo json_encode( $data );
}
}
$result->free();



$conn->close();
?>
and this is the Json being validated in jslint

{
"product_id": "1",
"product_ref": "",
"company_id": "5",
"product_name": "Plywood",
"category_id": "3",
"container_id": "2",
"product_description": "Plywood purchased in packs of 50 and sold individually.",
"purchase_cost": "1000",
"item_cost": "20",
"sales_price": "25.00",
"is_active": "1",
"stock_level": "56",
"min_stock_level": "0",
"date_added": "0000-00-00 00:00:00"
}
can anyone show me where it is I am going wrong in trying to display any one field in a text box on my form. David

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved