دادن مقدار به جی کوئری

[sadegh.te]

سلام اساتید محترم من یه سری داده به یه بخش از فایل جی کوئری دادم و با داده های دستی خوب کار میکنه حالا میخوام که اطلاعاتمو از بانک بخونم میشه راهنمایی کنید ؟؟؟ اینم کدی که اطلاعاتو دستی بهش دادم.


var products = [
{ "id": "1", "category": "Apple", "price": 2860, "image": "images/sample5.jpg", "title": "Apple iPhone 4" }
, { "id": "2", "category": "BlackBerry", "price": 450, "image": "images/BlackBerry-9780-Bold.gif", "title": "BlackBerry 9780 Bold" }
, { "id": "12", "category": "BlackBerry", "price": 520, "image": "images/BlackBerry-Torch-9800.gif", "title": "BlackBerry Torch 9800" }
, { "id": "26", "category": "HTC", "price": 1850, "image": "images/HTC-Desire-S.gif", "title": "HTC Desire S" }
, { "id": "50", "category": "HTC", "price": 600, "image": "images/HTC-HD7.gif", "title": "HTC HD7" }
, { "id": "21", "category": "HTC", "price": 2400, "image": "images/HTC-Incredible-S.gif", "title": "HTC Incredible S" }
, { "id": "11", "category": "HTC", "price": 2500, "image": "images/HTC-Sensation.gif", "title": "HTC Sensation" }
, { "id": "3", "category": "HTC", "price": 100, "image": "images/HTC-Wildfire.gif", "title": "HTC Wildfire" }
, { "id": "6", "category": "Motorola", "price": 2460, "image": "images/Motorola-Atrix-4G.gif", "title": "Motorola Atrix 4G" }
, { "id": "14", "category": "Motorola", "price": 100, "image": "images/Motorola-DEFY.gif", "title": "Motorola DEFY" }
, { "id": "15", "category": "Nokia", "price": 1200, "image": "images/Nokia-C7.gif", "title": "Nokia C7" }
, { "id": "60", "category": "Nokia", "price": 1700, "image": "images/Nokia-N8.gif", "title": "Nokia N8" }
, { "id": "70", "category": "Nokia", "price": 2000, "image": "images/Nokia-X6.gif", "title": "Nokia X6" }
, { "id": "45", "category": "Samsung", "price": 1800, "image": "images/Samsung-I9000-Galaxy-S.gif", "title": "Samsung I9000 Galaxy S" }
, { "id": "23", "category": "Samsung", "price": 2900, "image": "images/samsung-I9100-galaxy-S2.gif", "title": "samsung I9100 galaxy S2" }
, { "id": "17", "category": "Samsung", "price": 1300, "image": "images/Samsung-S5830-Galaxy-Ace.gif", "title": "Samsung S5830 Galaxy Ace" }
, { "id": "99", "category": "Sony-Ericsson", "price": 1400, "image": "images/Sony-Ericsson-XPERIA-X10.gif", "title": "Sony Ericsson XPERIA X10" }
];

[ashkufaraz]

خوب اطلاعات را باکوئری از بانک بخون و بعد به صورت json encode کن و بعد از اطلاعاتت استفاده کن؟
اصلا سوالت واضح نیست اصلا

[sadegh.te]

خوب اطلاعات را باکوئری از بانک بخون و بعد به صورت json encode کن و بعد از اطلاعاتت استفاده کن؟
اصلا سوالت واضح نیست اصلا
ممنون از پاسختون ولی من از آژاکس استفاده نکردم . کد کاملم به این شکل هستش :


var maxColumn = 4; // max cells in a row
var range = 3; // range of num links to show
// end user setings

var rowsPerPage = 0;
var currentpage = 0;
var maxPrice = 0;
var minPrice = 0;
var sortBy = '';
var sortOrder = 0;

// the products information array
var products = [
{ "id": "1", "category": "Apple", "price": 2860, "image": "images/sample5.jpg", "title": "Apple iPhone 4" }
, { "id": "2", "category": "BlackBerry", "price": 450, "image": "images/BlackBerry-9780-Bold.gif", "title": "BlackBerry 9780 Bold" }
, { "id": "12", "category": "BlackBerry", "price": 520, "image": "images/BlackBerry-Torch-9800.gif", "title": "BlackBerry Torch 9800" }
, { "id": "26", "category": "HTC", "price": 1850, "image": "images/HTC-Desire-S.gif", "title": "HTC Desire S" }
, { "id": "50", "category": "HTC", "price": 600, "image": "images/HTC-HD7.gif", "title": "HTC HD7" }
, { "id": "21", "category": "HTC", "price": 2400, "image": "images/HTC-Incredible-S.gif", "title": "HTC Incredible S" }
, { "id": "11", "category": "HTC", "price": 2500, "image": "images/HTC-Sensation.gif", "title": "HTC Sensation" }
, { "id": "3", "category": "HTC", "price": 100, "image": "images/HTC-Wildfire.gif", "title": "HTC Wildfire" }
, { "id": "6", "category": "Motorola", "price": 2460, "image": "images/Motorola-Atrix-4G.gif", "title": "Motorola Atrix 4G" }
, { "id": "14", "category": "Motorola", "price": 100, "image": "images/Motorola-DEFY.gif", "title": "Motorola DEFY" }
, { "id": "15", "category": "Nokia", "price": 1200, "image": "images/Nokia-C7.gif", "title": "Nokia C7" }
, { "id": "60", "category": "Nokia", "price": 1700, "image": "images/Nokia-N8.gif", "title": "Nokia N8" }
, { "id": "70", "category": "Nokia", "price": 2000, "image": "images/Nokia-X6.gif", "title": "Nokia X6" }
, { "id": "45", "category": "Samsung", "price": 1800, "image": "images/Samsung-I9000-Galaxy-S.gif", "title": "Samsung I9000 Galaxy S" }
, { "id": "23", "category": "Samsung", "price": 2900, "image": "images/samsung-I9100-galaxy-S2.gif", "title": "samsung I9100 galaxy S2" }
, { "id": "17", "category": "Samsung", "price": 1300, "image": "images/Samsung-S5830-Galaxy-Ace.gif", "title": "Samsung S5830 Galaxy Ace" }
, { "id": "99", "category": "Sony-Ericsson", "price": 1400, "image": "images/Sony-Ericsson-XPERIA-X10.gif", "title": "Sony Ericsson XPERIA X10" }
];


function setProducts() {
sortBy = sortBy ? sortBy : $('#product_sort').val();
rowsPerPage = rowsPerPage ? rowsPerPage : $('.product_pages button:first').html();
desc = sortOrder > 0 ? true : false;
currentpage = currentpage > 0 ? currentpage : 1; // if current page is less than first page...
var totalLoop = rowsPerPage;
var loop = 0;
var countCellData = 0;
var offset = 0;

$('#product_show').html(' ');

$('#product_order').val(sortOrder);
$('#product_sort').val(sortBy);

var filterdProducts = []; // displayed products array
var key = 0;

if (!minPrice && !maxPrice) {
filterdProducts = products;
} else {
$.each(products, function (i, object) {
var curentPrice = parseFloat(object.price);
var priceMinOk = true;
var priceMaxOk = true;

if (maxPrice || minPrice) {
if (maxPrice && maxPrice < curentPrice) {
priceMaxOk = false;
}
if (minPrice && minPrice > curentPrice) {
priceMinOk = false;
}
}

if (priceMinOk && priceMaxOk) {
filterdProducts[key] = object;
key++;

}

});
}


var totalResults = filterdProducts.length;
if (totalResults > 0) {

filterdProducts.sort(function (a, b) {
var a1 = a[sortBy], b1 = b[sortBy];
if (a1 == b1) { return 0; }
if (desc) {
return (a1 > b1) ? -1 : (a1 < b1) ? 1 : 0;
} else {
return a1 > b1 ? 1 : -1;
}
});
}

$('.product_results').html(totalResults);
/****** start build pagination links ******/
var totalpages = Math.ceil(totalResults / rowsPerPage); // calculate the total pages

if (totalpages > 1) {

if (currentpage > totalpages) {

currentpage = totalpages;
}

offset = (currentpage - 1) * rowsPerPage;

var pagination = '';
var lastPage = 0;

var minPage = parseFloat(currentpage) - parseFloat(range);
minPage = minPage > 0 ? minPage : 1;

if (currentpage > 1) {

pagination += '<button type="button" name="' + (currentpage - 1) + '" class="product_button" title="◄Previous" >◄Previous<\/button>';
)
if (minPage > 1) {
pagination += '<button type="button" name="1" class="product_button" title="1" >1<\/button>';
}
}


for (var x = minPage; x <= (currentpage + range) ; x++) {

if (x <= totalpages) {
lastPage = x;

if (x == currentpage) {
pagination += '<button type="button" name="0" class="product_button_selected" title="' + x + '" >' + x + '<\/button>';
} else {
pagination += '<button type="button" name="' + x + '" class="product_button" title="' + x + '" >' + x + '<\/button>';
}
}
}


if (currentpage != totalpages) {

var nextPage = parseFloat(currentpage) + 1;
if (lastPage < totalpages) {
)
pagination += '<button type="button" name="' + totalpages + '" class="product_button" title="' + totalpages + '" >' + totalpages + '<\/button>';
}
pagination += '<button type="button" name="' + nextPage + '" class="product_button" title="Next►" >Next►<\/button>';
}

$('.product_pagination').html(pagination);
} else {

$('.product_pagination').html('<button type="button" name="0" class="product_button_selected" title="1" >1<\/button>');
}
var offsetEnd = parseFloat(rowsPerPage) + parseFloat(offset);



var cell = '<table border="0" cellpadding="2" cellspacing="0" width="100%" id="product_table">';
cell = '<section class="main-content col-lg-9 col-md-9 col-sm-9">';
cell = '<div class="row">';
cell += '<tr>';


var pageProducts = filterdProducts.slice(offset, offsetEnd);

$.each(pageProducts, function (i, object) {

setPriceRange(parseFloat(object.price));
countCellData++; // flug to know if there is content



cell += '<div class="col-lg-4-right col-md-4-right col-sm-4 product">';
cell += '<div class="product-image"><img src="' + object.image + '" alt="' + object.title + '" title="' + object.title + '" longdesc="' + object.id + '" border="0" ><\/div>';
cell += '<div class="product-info"><h5>' + object.title + '<\/h5><span class="price">' + object.price + '<\/span><\/div>';
cell += '<div class="product-actions">';
cell += '<span class="add-to-compare">';
cell += '<span class="action-wrapper">';
cell += '<i class="icons icon-docs">';
cell += '<\/i>';
cell += '<span class="action-name">مقایسه<\/span>';
cell += '<\/span>';
cell += '<\/span>';
cell += '<\/div>';
cell += '<\/div>';


//cell += '<div><img src="'+object.image+'" alt="'+object.title+'" title="'+object.title+'" longdesc="'+object.id+'" border="0" ><\/div>';
//cell += '<div>'+object.title+'<\/div>';
//cell += '<div>'+object.price+'<\/div>';
//cell += '<div>'+object.category+'<\/div>';


totalLoop--;
loop++;


if (!totalLoop && loop) {
for (var i = 0; i < (maxColumn - loop) ; i++) {

cell += '<td>&nbsp;<\/td>';
}
}


if (loop == maxColumn) {
cell += '<\/tr>';
loop = 0;
if (totalLoop) {
cell += '<tr>';
}
}
});
cell += '<\/tr>';
cell += '<\/div>';
cell += '<\/section>';
cell += '<\/table>';
if (countCellData > 0) {
// if exist content
$('#product_show').html(cell);
// set image onclick event
$('#product_show img').click(function () {
alert('Product ID = ' + $(this).attr('longdesc'));
});

}
setPagination();
}

[sadegh.te]

اگه میشه کمک کنید