www/includes/db_inventory_yeasts.php

changeset 630
ffe0416614b3
parent 514
3c680d1dea35
child 708
60d28976286c
equal deleted inserted replaced
629:92afe6b59610 630:ffe0416614b3
24 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); 24 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']);
25 $sql .= "', type='" . array_search($_POST['type'], $yeasttype); 25 $sql .= "', type='" . array_search($_POST['type'], $yeasttype);
26 $sql .= "', form='" . array_search($_POST['form'], $yeastform); 26 $sql .= "', form='" . array_search($_POST['form'], $yeastform);
27 $sql .= "', laboratory='" . mysqli_real_escape_string($connect, $_POST['laboratory']); 27 $sql .= "', laboratory='" . mysqli_real_escape_string($connect, $_POST['laboratory']);
28 $sql .= "', product_id='" . mysqli_real_escape_string($connect, $_POST['product_id']); 28 $sql .= "', product_id='" . mysqli_real_escape_string($connect, $_POST['product_id']);
29 $sql .= "', short_desc='" . mysqli_real_escape_string($connect, $_POST['short_desc']);
29 $sql .= "', min_temperature='" . $_POST['min_temperature']; 30 $sql .= "', min_temperature='" . $_POST['min_temperature'];
30 $sql .= "', max_temperature='" . $_POST['max_temperature']; 31 $sql .= "', max_temperature='" . $_POST['max_temperature'];
31 $sql .= "', flocculation='" . $_POST['flocculation']; 32 $sql .= "', flocculation='" . $_POST['flocculation'];
32 $sql .= "', attenuation='" . $_POST['attenuation']; 33 $sql .= "', attenuation='" . $_POST['attenuation'];
33 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); 34 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
94 'name' => $row['name'], 95 'name' => $row['name'],
95 'type' => $yeasttype[$row['type']], 96 'type' => $yeasttype[$row['type']],
96 'form' => $yeastform[$row['form']], 97 'form' => $yeastform[$row['form']],
97 'laboratory' => $row['laboratory'], 98 'laboratory' => $row['laboratory'],
98 'product_id' => $row['product_id'], 99 'product_id' => $row['product_id'],
100 'short_desc' => $row['short_desc'],
99 'min_temperature' => $row['min_temperature'], 101 'min_temperature' => $row['min_temperature'],
100 'max_temperature' => $row['max_temperature'], 102 'max_temperature' => $row['max_temperature'],
101 'flocculation' => $row['flocculation'], 103 'flocculation' => $row['flocculation'],
102 'attenuation' => $row['attenuation'], 104 'attenuation' => $row['attenuation'],
103 'notes' => $row['notes'], 105 'notes' => $row['notes'],

mercurial