colonymech / docs / www / colonyscout / internal / updateThumbs.php @ f59acf11
History | View | Annotate | Download (1.1 KB)
1 | f59acf11 | Dan Shope | <?php
|
---|---|---|---|
2 | include('inventoryFunctions.php'); |
||
3 | include_once(getenv("DOCUMENT_ROOT")."/internal/do_login.php"); |
||
4 | doDB("colony_scout");
|
||
5 | |||
6 | $get_inventory_sql = "SELECT vendorPartNo, vendorID FROM inventory"; |
||
7 | $get_inventory_res = mysqli_query($mysqli, $get_inventory_sql) or die(mysqli_error($mysqli)); |
||
8 | |||
9 | if (mysqli_num_rows($get_inventory_res) < 1) { |
||
10 | //there are no inventory, so say so
|
||
11 | echo "No matches found"; |
||
12 | } else {
|
||
13 | |||
14 | echo "<ul>"; |
||
15 | while ($inv = mysqli_fetch_array($get_inventory_res)) { |
||
16 | //get thumbnail
|
||
17 | $src = 0; |
||
18 | switch ($inv["vendorID"]) { |
||
19 | case 1: //sparkfun |
||
20 | //echo "SparkFun ".$inv["vendorPartNo"];
|
||
21 | $src = getThumbSparkfun($inv["vendorPartNo"]); |
||
22 | break;
|
||
23 | case 2: //digikey |
||
24 | //echo "Digikey ".$inv["vendorPartNo"];
|
||
25 | $src = getThumbDigikey($inv["vendorPartNo"]); |
||
26 | break;
|
||
27 | } |
||
28 | |||
29 | if ($src) { |
||
30 | saveThumb($src, "thumbs/".urlencode($inv["vendorPartNo"]).".jpg"); |
||
31 | echo "<li>thumbnail retrieved for ".$inv["vendorID"]." P/N: ".$inv["vendorPartNo"]." from ".$src."</li>"; |
||
32 | } else {
|
||
33 | echo "<li>no thumbnail for ".$inv["vendorID"]." P/N: ".$inv["vendorPartNo"]."</li>"; |
||
34 | } |
||
35 | } |
||
36 | echo "</ul>"; |
||
37 | } |
||
38 | |||
39 | ?> |