comparison: www/includes/db_inventory_yeasts.php
www/includes/db_inventory_yeasts.php
- changeset 33
- 2ee6ad5d6f14
- parent 20
- 22271f3598ac
- child 37
- 9362eb9e9e5b
equal
deleted
inserted
replaced
| 32:8bb369f32ef9 | 33:2ee6ad5d6f14 |
|---|---|
| 23 $sql .= "', flocculation='" . $_GET['flocculation']; | 23 $sql .= "', flocculation='" . $_GET['flocculation']; |
| 24 $sql .= "', attenuation='" . $_GET['attenuation']; | 24 $sql .= "', attenuation='" . $_GET['attenuation']; |
| 25 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 25 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 26 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']); | 26 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']); |
| 27 $sql .= "', max_reuse='" . $_GET['max_reuse']; | 27 $sql .= "', max_reuse='" . $_GET['max_reuse']; |
| 28 $sql .= "', inventory='" . $_GET['inventory']; | 28 $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0; |
| 29 $sql .= "', cost='" . $_GET['cost']; | 29 $sql .= "', cost='" . $_GET['cost']; |
| 30 $sql .= "', production_date='" . $_GET['production_date']; | 30 $sql .= "', production_date='" . $_GET['production_date']; |
| 31 $sql .= "', tht_date='" . $_GET['tht_date']; | 31 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 32 $sql .= "';"; | 32 $sql .= "';"; |
| 33 $result = mysqli_query($connect, $sql); | 33 $result = mysqli_query($connect, $sql); |
| 50 $sql .= "', flocculation='" . $_GET['flocculation']; | 50 $sql .= "', flocculation='" . $_GET['flocculation']; |
| 51 $sql .= "', attenuation='" . $_GET['attenuation']; | 51 $sql .= "', attenuation='" . $_GET['attenuation']; |
| 52 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 52 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 53 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']); | 53 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']); |
| 54 $sql .= "', max_reuse='" . $_GET['max_reuse']; | 54 $sql .= "', max_reuse='" . $_GET['max_reuse']; |
| 55 $sql .= "', inventory='" . $_GET['inventory']; | 55 $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0; |
| 56 $sql .= "', cost='" . $_GET['cost']; | 56 $sql .= "', cost='" . $_GET['cost']; |
| 57 $sql .= "', production_date='" . $_GET['production_date']; | 57 $sql .= "', production_date='" . $_GET['production_date']; |
| 58 $sql .= "', tht_date='" . $_GET['tht_date']; | 58 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 59 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 59 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 60 $result = mysqli_query($connect, $sql); | 60 $result = mysqli_query($connect, $sql); |
| 92 'flocculation' => $row['flocculation'], | 92 'flocculation' => $row['flocculation'], |
| 93 'attenuation' => $row['attenuation'], | 93 'attenuation' => $row['attenuation'], |
| 94 'notes' => $row['notes'], | 94 'notes' => $row['notes'], |
| 95 'best_for' => $row['best_for'], | 95 'best_for' => $row['best_for'], |
| 96 'max_reuse' => $row['max_reuse'], | 96 'max_reuse' => $row['max_reuse'], |
| 97 'inventory' => $row['inventory'], | 97 'inventory' => floatval($row['inventory']) * 1000.0, |
| 98 'cost' => $row['cost'], | 98 'cost' => $row['cost'], |
| 99 'production_date' => $row['production_date'], | 99 'production_date' => $row['production_date'], |
| 100 'tht_date' => $row['tht_date'] | 100 'tht_date' => $row['tht_date'] |
| 101 ); | 101 ); |
| 102 } | 102 } |
