My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Mar 12th, 2010 | Syntax: PHP | Size: 6.49 KB | Hits: 87 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. <?php
  2. include "header.php";
  3. include "conn.php";
  4. ?>
  5. <script language="javascript">
  6. <!--
  7. var state = 'none';
  8.  
  9. function showhide(layer_ref) {
  10.  
  11. if (state == 'block') {
  12. state = 'none';
  13. }
  14. else {
  15. state = 'block';
  16. }
  17. if (document.all) { //IS IE 4 or 5 (or 6 beta)
  18. eval( "document.all." + layer_ref + ".style.display = state");
  19. }
  20. if (document.layers) { //IS NETSCAPE 4 or below
  21. document.layers[layer_ref].display = state;
  22. }
  23. if (document.getElementById &&!document.all) {
  24. hza = document.getElementById(layer_ref);
  25. hza.style.display = state;
  26. }
  27. }
  28. //-->
  29. </script>
  30.  
  31. <table width="*" border="0" align="center" cellpadding="1" cellspacing="0">
  32.   <tr class="tableTitle">
  33.     <td width="135">Part #</td>
  34.     <td width="50">Rev</td>
  35.     <td width="152">Customer Name</td>
  36.   </tr>
  37.   <tr>
  38.     <td><form id="form1" name="form1" method="post" action=""><input name="partNum" type="text" /></td>
  39.     <td>&nbsp;<input name="partRev" type="text" size="1"  /></td>
  40.     <td><input name="customerName" type="text" /></td>
  41.   </tr>
  42.   <tr>
  43.     <td>&nbsp;</td>
  44.     <td>&nbsp;</td>
  45.     <td align="right"><input type="submit" name="Search" value="Search" /></form></td>
  46.   </tr>
  47. </table>
  48. <br />
  49. <br />
  50. <div align="center" class="title1" >Inventory Database</div>
  51. <br />
  52.  
  53.  
  54. <?php
  55. // Lets count how many parts we have in stock
  56. $invcnt = mysql_fetch_row(mysql_query("SELECT COUNT(*) AS count FROM invDB"));
  57.                 echo "<div align=\"center\">Total Parts:". $invcnt[0];
  58.  
  59. $result = mysql_query('SELECT quant FROM invDB');
  60. if (mysql_num_rows($result) > 0) {
  61.         while ($myrow = mysql_fetch_array($result)) {
  62.                 $sum[] = $myrow['quant']; // sum
  63.                 }
  64.                 $sum = array_sum($sum);
  65.                 print " &nbsp;&nbsp;&nbsp;Total Quantity: $sum</div>";
  66.                 }
  67.                
  68. ?>
  69.  
  70.  
  71. <div align="right" class="link2"><a href="#" onclick="showhide('addItem');">ADD NEW ITEM <img height="11" width="11" border="0" src="/images/plus-glow.png" /></a></div>
  72. <table width="800" border="1" cellspacing="0" cellpadding="0">
  73.   <tr class="tableTitle">
  74.     <td width="130">Part # <a href="index.php?id=SortPartDown"><img height="11" border="0" width="11" src="/images/arrow-down-glow.png" /></a>&nbsp;<a href="index.php?id=SortPartUp"><img height="11" border="0" width="11" src="/images/arrow-up-glow.png" /></a></td>
  75.     <td width="40">Rev</td>
  76.     <td width="100">Quantity <a href="index.php?id=SortQuantDown"><img height="11" border="0" width="11" src="/images/arrow-down-glow.png" /></a>&nbsp;<a href="index.php?id=SortQuantUp"><img height="11" border="0" width="11" src="/images/arrow-up-glow.png" /></a></td>
  77.     <td width="200">Customer Name <a href="index.php?id=SortCustDown"><img height="11" border="0" width="11" src="/images/arrow-down-glow.png" /></a>&nbsp;<a href="index.php?id=SortCustUp"><img height="11" border="0" width="11" src="/images/arrow-up-glow.png" /></a></td>
  78.     <td width="55">Bin</td>
  79.     <td width="55">Shelf</td>
  80.     <td width="220">Special Notes</td>
  81.   </tr>
  82.  
  83.  
  84.  
  85. <?php
  86. //lets fetch all the current Item's
  87. $query_1 = mysql_query("SELECT * FROM invDB");
  88.         while($row_1 = mysql_fetch_array($query_1)){  
  89.                         //Ok lets put it all together and put it in a nice little table :)
  90.                         echo "<tr>\n <td><a href=\"part.php?id=". $row_1['partNum']. "\">". $row_1['partNum']. "</a></td>";
  91.                         echo "\n <td>". $row_1['revNum']. "</td>";
  92.                         echo "\n <td>". $row_1['quant']. "</td>";
  93.                         echo "\n <td>". $row_1['customerName']. "</td>";
  94.                         echo "\n <td>". $row_1['bin']. "</td>";
  95.                         echo "\n <td>". $row_1['shelf']. "</td>";
  96.                         echo "\n <td>". $row_1['specialNotes']. "</td>";
  97.                         echo "</tr>\n";
  98.         }
  99.  
  100. // were done lets end the table.
  101. echo "</table>";
  102.  
  103. // Lets close out of php and build the popup window to add new items
  104. ?>
  105. <div id="addItem" style="display: none; position: absolute; left:245px; top:300px; background-color:#4D535D;">
  106. <table border="5" bordercolor="#CCCCCC" width="300" height="200"cellpadding="0" cellspacing="0"><tr><td>
  107. <table width="300" height="200" border="0" cellpadding="0" cellspacing="0">
  108. <tr><td width="289" height="22" align="center" class="title1">ADD NEW ITEM</td>
  109. <td><a href="#" onclick="showhide('addItem');"><img height="22" border="0" width="22" src="/images/cross-glow.png" /></a></td>
  110. </tr>
  111. <tr><td colspan="2" align="center">
  112. <form  method="post" action="additem.php">
  113. <table>
  114. <tr><td align="left">Part Number:</td><td><input name="partNum" type="text" /></td></tr>
  115. <tr><td align="left">Rev:</td><td><input name="rev" type="text" /></td></tr>
  116. <tr><td align="left">Quantity:</td><td><input name="quant" type="text" /></td></tr>
  117. <tr><td align="left">Customer Name:</td><td><input name="custName" type="text" /></td></tr>
  118. <tr><td align="left">Bin:</td><td><input name="bin" type="text" /></td></tr>
  119. <tr><td align="left">Shelf:</td><td><input name="shelf" type="text" /></td></tr>
  120. <tr><td colspan="2" align="left">Special Notes:</td></tr>
  121. <tr><td colspan="2"><textarea name="snotes" cols="31" rows="3"></textarea><br />
  122. <input type="submit" name="AddItem" value="Add Item" />
  123. </td></tr></table>
  124. </form>
  125. </td></tr></table>
  126. </td></tr></table>
  127. </div>
  128.  
  129.  
  130. <?php
  131. // Lets close out of php and build the popup window for items instock
  132. ?>
  133. <div id="partInf" style="display: none; position: absolute; left:245px; top:300px; background-color:#4D535D;">
  134. <table border="5" bordercolor="#CCCCCC" width="300" height="200"cellpadding="0" cellspacing="0"><tr><td>
  135. <table width="300" height="200" border="0" cellpadding="0" cellspacing="0">
  136. <tr><td width="289" height="22" align="center" class="title1">ADD NEW ITEM</td>
  137. <td><a href="#" onclick="showhide('addItem');"><img height="22" border="0" width="22" src="/images/cross-glow.png" /></a></td>
  138. </tr>
  139. <tr><td colspan="2" align="center">
  140. <form  method="post" action="additem.php">
  141. <table>
  142. <tr><td align="left">Part Number:</td><td><input name="partNum" type="text" /></td></tr>
  143. <tr><td align="left">Rev:</td><td><input name="rev" type="text" /></td></tr>
  144. <tr><td align="left">Quantity:</td><td><input name="quant" type="text" /></td></tr>
  145. <tr><td align="left">Customer Name:</td><td><input name="custName" type="text" /></td></tr>
  146. <tr><td align="left">Bin:</td><td><input name="bin" type="text" /></td></tr>
  147. <tr><td align="left">Shelf:</td><td><input name="shelf" type="text" /></td></tr>
  148. <tr><td colspan="2" align="left">Special Notes:</td></tr>
  149. <tr><td colspan="2"><textarea name="snotes" cols="31" rows="3"></textarea><br />
  150. <input type="submit" name="AddItem" value="Add Item" />
  151. </td></tr></table>
  152. </form>
  153. </td></tr></table>
  154. </td></tr></table>
  155. </div>
  156.  
  157.  
  158. <?php
  159. include "footer.php";
  160. ?>
create new paste | create new version of this paste RAW Paste Data