www/includes/db_product.php

changeset 602
10b61aacb1c1
parent 577
b4bfed3684d0
child 611
c583f446d6ca
equal deleted inserted replaced
601:112c278be803 602:10b61aacb1c1
38 $sql .= "', birth='" . $_POST['birth']; 38 $sql .= "', birth='" . $_POST['birth'];
39 $sql .= "', stage='" . $_POST['stage']; 39 $sql .= "', stage='" . $_POST['stage'];
40 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); 40 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
41 $sql .= "', log_brew='" . $_POST['log_brew']; 41 $sql .= "', log_brew='" . $_POST['log_brew'];
42 $sql .= "', log_fermentation='" . $_POST['log_fermentation']; 42 $sql .= "', log_fermentation='" . $_POST['log_fermentation'];
43 $sql .= "', log_ispindel='" . $_POST['log_ispindel'];
43 $sql .= "', inventory_reduced='" . $_POST['inventory_reduced']; 44 $sql .= "', inventory_reduced='" . $_POST['inventory_reduced'];
44 $sql .= "', locked='" . $_POST['locked']; 45 $sql .= "', locked='" . $_POST['locked'];
45 // Equipment 46 // Equipment
46 $sql .= "', eq_name='" . mysqli_real_escape_string($connect, $_POST['eq_name']); 47 $sql .= "', eq_name='" . mysqli_real_escape_string($connect, $_POST['eq_name']);
47 $sql .= "', eq_boil_size='" . $_POST['eq_boil_size']; 48 $sql .= "', eq_boil_size='" . $_POST['eq_boil_size'];
679 $brew .= '","birth":"' . str_replace($escapers, $replacements, $row['birth']); 680 $brew .= '","birth":"' . str_replace($escapers, $replacements, $row['birth']);
680 $brew .= '","stage":' . $row['stage']; 681 $brew .= '","stage":' . $row['stage'];
681 $brew .= ',"notes":"' . str_replace($escapers, $replacements, $row['notes']); 682 $brew .= ',"notes":"' . str_replace($escapers, $replacements, $row['notes']);
682 $brew .= '","log_brew":' . $row['log_brew']; 683 $brew .= '","log_brew":' . $row['log_brew'];
683 $brew .= ',"log_fermentation":' . $row['log_fermentation']; 684 $brew .= ',"log_fermentation":' . $row['log_fermentation'];
685 $brew .= ',"log_ispindel":' . $row['log_ispindel'];
684 $brew .= ',"inventory_reduced":' . $row['inventory_reduced']; 686 $brew .= ',"inventory_reduced":' . $row['inventory_reduced'];
685 $brew .= ',"locked":' . $row['locked']; 687 $brew .= ',"locked":' . $row['locked'];
686 $brew .= ',"eq_name":"' . str_replace($escapers, $replacements, $row['eq_name']); 688 $brew .= ',"eq_name":"' . str_replace($escapers, $replacements, $row['eq_name']);
687 $brew .= '","eq_notes":"' . str_replace($escapers, $replacements, $row['eq_notes']); 689 $brew .= '","eq_notes":"' . str_replace($escapers, $replacements, $row['eq_notes']);
688 $brew .= '","eq_boil_size":' . floatval($row['eq_boil_size']); 690 $brew .= '","eq_boil_size":' . floatval($row['eq_boil_size']);

mercurial