www/includes/global.inc.php

changeset 100
08c92cb740b9
parent 99
f433193f7bb6
child 101
5b6bb99bc52a
equal deleted inserted replaced
99:f433193f7bb6 100:08c92cb740b9
37 if (isset($_GET['return'])) 37 if (isset($_GET['return']))
38 $my_return = $_GET['return']; 38 $my_return = $_GET['return'];
39 else 39 else
40 $my_return = ''; 40 $my_return = '';
41 41
42 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c");
43 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b");
44
45 /* Load setup record */
46 #Connect to the database
47 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
48 if (! $connect) {
49 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
50 }
51 mysqli_set_charset($connect, "utf8" );
52 $my_default_water = $my_brewery_name = $my_ibu_method = $my_color_method = '';
53 $my_factor_mashhop = $my_factor_fwh = $my_factor_pellet = $my_factor_plug = 0;
54 $my_brix_correction = $my_grain_absorbtion = 1.0;
55
56 $result = mysqli_query($connect, "SELECT * FROM profile_setup WHERE record='1'") or die("SQL Error 1: " . mysqli_error($connect));
57 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
58 /* search water name */
59 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';");
60 if ($wrow = mysqli_fetch_array($wresult, MYSQLI_ASSOC))
61 $my_default_water = str_replace($escapers, $replacements, $wrow['name']);
62 $my_brewery_name = str_replace($escapers, $replacements, $row['brewery_name']);
63 $my_factor_mashhop = floatval($row['factor_mashhop']);
64 $my_factor_fwh= floatval($row['factor_fwh']);
65 $my_factor_pellet= floatval($row['factor_pellet']);
66 $my_factor_plug= floatval($row['factor_plug']);
67 $my_ibu_method = str_replace($escapers, $replacements, $row['ibu_method']);
68 $my_color_method = str_replace($escapers, $replacements, $row['color_method']);
69 $my_brix_correction = floatval($row['brix_correction']);
70 $my_grain_absorbtion = floatval($row['grain_absorbtion']);
71 }
72 //mysqli_free_result($result);
73
74
42 function page_header($title, $loadjs) { 75 function page_header($title, $loadjs) {
43 global $my_style; 76 global $my_style;
44 global $my_version; 77 global $my_version;
45 global $my_record; 78 global $my_record;
46 global $my_return; 79 global $my_return;
80 global $my_brewery_name;
47 ?> 81 ?>
48 <!DOCTYPE html> 82 <!DOCTYPE html>
49 <html lang=nl-NL> 83 <html lang=nl-NL>
50 <head> 84 <head>
51 <meta http-equiv="content-type" content="text/html; charset=utf-8" /> 85 <meta http-equiv="content-type" content="text/html; charset=utf-8" />
56 <meta name="viewport" content="width=device-width, initial-scale=1 maximum-scale=1 minimum-scale=1" /> 90 <meta name="viewport" content="width=device-width, initial-scale=1 maximum-scale=1 minimum-scale=1" />
57 <script> 91 <script>
58 var theme = "<?php echo $my_style; ?>"; 92 var theme = "<?php echo $my_style; ?>";
59 var my_record = "<?php echo $my_record; ?>"; 93 var my_record = "<?php echo $my_record; ?>";
60 var my_return = "<?php echo $my_return; ?>"; 94 var my_return = "<?php echo $my_return; ?>";
95 var my_brewery_name = "<?php echo $my_brewery_name; ?>";
61 </script> 96 </script>
62 <script src="js/jquery-1.11.1.min.js"></script> 97 <script src="js/jquery-1.11.1.min.js"></script>
63 <script src="jqwidgets/jqxcore.js"></script> 98 <script src="jqwidgets/jqxcore.js"></script>
64 <script src="jqwidgets/jqxwindow.js"></script> 99 <script src="jqwidgets/jqxwindow.js"></script>
65 <script src="jqwidgets/jqxmenu.js"></script> 100 <script src="jqwidgets/jqxmenu.js"></script>

mercurial