Project

General

Profile

Statistics
| Branch: | Revision:

colonymech / 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
?>