Loading...

Search jQuery

Search

jQuery Forum

Getting Started

how do I create an updating inventory?

in Getting Started • 12 years ago

currently I have an inventory system which allows me to have it showing, but if something changes it needs to be refreshed to show the changes, how do I make it update?

Currently I have :

<?php

$result2 = mysql_query("SELECT * FROM inventory WHERE username = '$login'");

$output2 = mysql_fetch_array($result2);

$poutput = $output2['space1'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'clear: right; border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space2'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space3'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space4'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'clear: right; border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space5'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space6'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space7'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'clear: right; border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space8'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space9'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space10'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'clear: right; border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space11'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space12'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space13'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'clear: right; border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space14'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

$poutput = $output2['space15'];

$result3 = mysql_query("SELECT * FROM items WHERE itemID = '$poutput'");

$output3 = mysql_fetch_array($result3);

echo "<div style = 'border: 1px white solid; width: 80px; height: 80px; float: right;'><img src = '" . $output3['directory'] . "' /></div>";

?>

sorry for the length but I couldn't get a loop to work on all this.

1

Replies(3)

jay.blanchard

Re: how do I create an updating inventory?

12 years ago

Unfortunately it appears that you have asked a PHP question in a jQuery / Javascript forum. Are you using AJAX of some form to get the information to the display?

Re: Re: how do I create an updating inventory?

12 years ago

not currently but I was wondering if there was a way javascript or jquery could reload the inventory system when called upon without refreshing the page. since i can't re call on a php task after it's been sent to the user.

jay.blanchard

Re: how do I create an updating inventory?

12 years ago

Yes you can have a jQuery AJAX event reload the inventory information. Have a look at the Ajax functions: http://api.jquery.com/category/ajax/