How to load data from Database with jquery?

Question

I have one Sales Form,

<div class="form-group">
  <input type="text" class="form-control" id="id_barang"  placeholder="Barcode" required>
</div>
<div class="form-group">
  <input type="text" class="form-control" id="nama"  placeholder="Product Name" readonly >
</div>
<div class="form-group">
  <input type="text" class="form-control" id="harga"  placeholder="Price" readonly >
</div>
<div class="form-group">
  <input type="text" size="2" class="form-control" id="stok"  placeholder="Qty" readonly>
</div>
<div class="form-group">
  <input  type="text" size="2" class="form-control" id="jumlah"  placeholder="Total" required>
</div>   

<button type="submit" class="btn btn-primary">Add</button>
<button type="submit" class="btn btn-warning">Cancel</button>
</div>

i don't know what have to do, i have tried "Google" about tutorial of my problem, if we input "barcode" or "ID", then automatically "product name, price, Qty" will show up in their field.

you can do it with ajax request of Jquery or $.get or $.post all will perform this task for you. — Naveed Yousaf
– Naveed Yousaf, Commented Mar 7, 2014 at 6:47
there is one </div> to much (at the end) - might be a copy/paste mistake — Mr. iC
– Mr. iC, Commented Mar 7, 2014 at 7:11

Denis Tsoi · Accepted Answer · 2014-03-07 06:49:41Z

2

Like @Arun P Johny mentioned, ajax is what you would be using with jQuery...

However, you need to understand the way that your backend code is accessing information from the database, (which would require communicating with your backend coders on how to access the information... i.e. constructing a sensible API).

If you look at how social media platforms release documentation on their API, you'll notice how they have certain patterns on retrieving data from their sources, and likewise, you should consider adopting similar practices.

Note

Apologies for not being able to answer fully without code, but without any context of how your backend is accessible, I severely doubt the SO community can assist further

answered Mar 7, 2014 at 6:49

Denis Tsoi

10.6k8 gold badges42 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sarath · Accepted Answer · 2014-03-07 06:49:47Z

0

By using jQuery.ajax() you can simply load the datas

https://api.jquery.com/jQuery.ajax/

answered Mar 7, 2014 at 6:49

Sarath

6085 silver badges12 bronze badges

Comments

Deepan Maheswaran · Accepted Answer · 2014-03-07 06:55:28Z

0

you can make via ajax calls using jquery, see the sample below.

$.ajax({
            type: "POST",
            url: 'xxxx.aspx/methodname',
            data: "{}",
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (data) {
                for (var i = 0; i < data.d.length; i++) {
                    $("#tbl").append("<tr><td>" + data.d[i].PONumber + "</td></tr>");
                }
            }
        });

You can make this call on document.ready() method or via function call on button click event

You can find more info on making ajax calls using jquery

answered Mar 7, 2014 at 6:55

Deepan Maheswaran

931 silver badge13 bronze badges

Comments

Kyo · Accepted Answer · 2014-03-07 07:00:43Z

0

In HTML, add another input box for the barcode of the product:

<input type="text" id="barcode"  placeholder="Barcode">

And, on the javascript, add an event handler for the barcode input:

$('#barcode').on('change', function(){
    var barcode = $(this).val();
    $.ajax({
        // Do the AJAX call here to retrieve the product information based on the barcode
        // , then update those 4 input elements accordingly
    });
});

answered Mar 7, 2014 at 7:00

Kyo

9645 silver badges10 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:02:36Z

0

if you want to access data from back-end by jquery you have to use ajax ,in html when clicked on button send an id it should be exist in database then you have write code for fetching data,then you have to display . $.jquery ajax returned data (json) displays as 'undefined'

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Mar 7, 2014 at 7:16

krishna_coolsofty

213 bronze badges

Collectives™ on Stack Overflow

How to load data from Database with jquery?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related