Hello All
I am trying to do something and may not be going about it the best way, either way I am stuck and am requesting help from you clever folks........
I am doing a small project for work, basically we have stock in the warehouse, there are locations where the item is picked and sent out to customers, and then there are backup locations for when the main picking location runs low/empty. Depending on how many units we stock of a certain item, it may have anything from 1 to even 10 backup locations. There is always only 1 picking location. Anyway, from time to time we find the numbers our system has are different to what is physically there, and have to generate a paperwork move, and then key it into the system to correct locations. The problem is, it's extremely difficult to get most staff to understand the stock moves to make things correct.
So I have been charged with the task of taking the thought (or lack of) out of the moves, and doing something semi-automated. Basically I think search box, linked to the stock database, queries database, returns result with all locations and their respective quantity's for that item number, then put's a text box next to each returned result so that the user can put the new qty in, submit it again and it will then generate a list of the moves that need doing by comparing the original database qty's with the new posted ones.
Using PHP and MySql I have managed to achieve the task of linking to the database, and producing a query that gives me all locations and quantity's of a specific item number. No problems so far.
Here is where it gets more complicated. I thought return the results in a new form, and then submit it and do the comparison. However, I just cant get my head around how to do this with different amounts of returned rows, then posting the data again. I am sure I will run into more probs once this is solved but for the time being thats where I am.
Below is the code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML
1.0 Transitional//EN"
"
http://www.w3.org/TR/xhtml1/DTD/
xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml"
xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>Item Number Search</title>
<link rel="stylesheet" href="display.css">
<?php
require_once ('./mysql_connect.php');
?>
</head>
<body>
<?php
//Check if form has been submitted.
if (isset($_POST['submitted'])) {
$errors = array();
if (empty($_POST['itemnumber'])) {
$errors[] = "You didn't enter an item number";
} else {
$in = trim($_POST['itemnumber']);
}
if (empty($errors)) {
$query = "SELECT location, qty FROM stock WHERE itemnumber = '".$_POST["itemnumber"]."' ORDER BY location ASC";
$result = @mysql_query ($query);
$num_rows = mysql_num_rows($result);
if ($result) {
echo '<div class="results"><form action="resultschange.php" method="post">
<tr>
<td><b>Location   ; </b></td><td><b>Qty & nbsp; </b></td><td><b>New Qty   ;</b></td>
<br /><br /></tr>';
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr><td>' .$row['location'] . '   ;</td><td>' .$row['qty'] . ' & nbsp;</td><td><input type="text" name="newqty"
id="newqty" size="5" maxlength="3" /></td><br /></tr>';
}
echo '<br /><br />' .$num_rows. '</div>';
mysql_free_result ($result);
echo '</form>';
}
mysql_close();
}
if (!empty($errors)) {
echo '<div class="results">
<p>';
foreach ($errors as $msg){
echo " - $msg</p></div>";}
}
}
?>
<div class="form">
<form action="locationsearch.php" method="post">
<p>Enter Item Number:<br />
<input type="text" name="itemnumber" id="itemnumber" size="30" maxlength="12" value="<?php if
(isset($_POST['itemnumber'])) echo $_POST['itemnumber']; ?>" />
<input type="submit" name="submit" id="submit" value="search" />
<input type="hidden" name="submitted" id="submitted" value="TRUE" />
</p>
</form>
</div>
</body>
I know some of the code needs tidying, at first it was all about seeing how far I could get, I will have a good tidy up before/if ever it goes live.
Sorry for the length of this post, if anyone can help much appreciated.
