root / docs / www / colonyscout / internal / updateThumbs.php @ f59acf11
History | View | Annotate | Download (1.1 KB)
1 |
<?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 |
?>
|