50 $myfermentables= simplexml_load_file($target_file); |
50 $myfermentables= simplexml_load_file($target_file); |
51 |
51 |
52 |
52 |
53 foreach ($myfermentables->FERMENTABLE as $fermentable) { |
53 foreach ($myfermentables->FERMENTABLE as $fermentable) { |
54 |
54 |
55 $sql = "INSERT INTO inventory_fermentables SET name='" . mysqli_real_escape_string($db, $fermentable->NAME); |
55 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
|
56 $sql = "INSERT INTO inventory_fermentables SET uuid='" . $uuid; |
|
57 |
|
58 $sql .= "', name='" . mysqli_real_escape_string($db, $fermentable->NAME); |
56 if ($fermentable->TYPE == 'Grain') |
59 if ($fermentable->TYPE == 'Grain') |
57 $sql .= "', type='0"; |
60 $sql .= "', type='0"; |
58 else if ($fermentable->TYPE == 'Sugar') |
61 else if ($fermentable->TYPE == 'Sugar') |
59 $sql .= "', type='1"; |
62 $sql .= "', type='1"; |
60 else if ($fermentable->TYPE == 'Extract') |
63 else if ($fermentable->TYPE == 'Extract') |