• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/includes/db_recipes.php@7224109adfe1 (annotated)

www/includes/db_recipes.php

Tue, 04 Sep 2018 13:44:02 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Tue, 04 Sep 2018 13:44:02 +0200

changeset 51

7224109adfe1

parent 50

6d94167c2697

child 52

b1f2a893572f

permissions

-rw-r--r--

More recipe editor changes

49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	1	<?php
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	2
50 6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	3	require($_SERVER['DOCUMENT_ROOT']."/config.php");
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	4	require($_SERVER['DOCUMENT_ROOT']."/version.php");
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	5	//require("../config.php");
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	6	//require("../version.php");
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	7
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	8
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	9	#Connect to the database
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	10	$connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	11	if (! $connect) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	12	die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	13	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	14
50 6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	15	$escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c");
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	16	$replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b");
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	17
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	18	// get data and store in a json array
51 7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	19	$query = "SELECT * FROM recipes ORDER BY st_guide,st_letter,st_name,name";
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	20	if (isset($_GET['insert'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	21	// // INSERT COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	22	// $sql = "INSERT INTO `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	23	// $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	24	// $sql .= "', steps='" . json_encode($_GET['steps']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	25	// $sql .= "';";
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	26	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	27	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	28	// syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect));
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	29	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	30	// syslog(LOG_NOTICE, "db_profile_mash: inserted ".$_GET['name']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	31	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	32	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	33
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	34	//} else if (isset($_GET['update'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	35	// // UPDATE COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	36	// $sql = "UPDATE `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	37	// $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	38	// $sql .= "', steps='" . json_encode($_GET['steps']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	39	// $sql .= "' WHERE record='" . $_GET['record'] . "';";
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	40	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	41	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	42	// syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect));
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	43	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	44	// syslog(LOG_NOTICE, "db_profile_mash: updated record ".$_GET['record']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	45	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	46	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	47
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	48	//} else if (isset($_GET['delete'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	49	// // DELETE COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	50	// $sql = "DELETE FROM `profile_mash` WHERE record='".$_GET['record']."';";
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	51	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	52	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	53	// syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect));
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	54	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	55	// syslog(LOG_NOTICE, "db_profile_mash: deleted record ".$_GET['record']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	56	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	57	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	58
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	59	} else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	60	// SELECT COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	61	$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	62	$recipes = '[';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	63	$comma = FALSE;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	64	while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	65	// Manual encode to JSON.
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	66	if ($comma) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	67	$recipes .= ',';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	68	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	69	$comma = TRUE;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	70	$recipes .= '{"record":' . $row['record'];
51 7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	71	$recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	72	$recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	73	$recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	74	$recipes .= '","st_og_min":' . floatval($row['st_og_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	75	$recipes .= ',"st_og_max":' . floatval($row['st_og_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	76	$recipes .= ',"st_fg_min":' . floatval($row['st_fg_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	77	$recipes .= ',"st_fg_max":' . floatval($row['st_fg_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	78	$recipes .= ',"st_ibu_min":' . floatval($row['st_ibu_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	79	$recipes .= ',"st_ibu_max":' . floatval($row['st_ibu_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	80	$recipes .= ',"st_color_min":' . floatval($row['st_color_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	81	$recipes .= ',"st_color_max":' . floatval($row['st_color_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	82	$recipes .= ',"st_carb_min":' . floatval($row['st_carb_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	83	$recipes .= ',"st_carb_max":' . floatval($row['st_carb_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	84	$recipes .= ',"st_abv_min":' . floatval($row['st_abv_min']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	85	$recipes .= ',"st_abv_max":' . floatval($row['st_abv_max']);
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	86	$recipes .= ',"name":"' . str_replace($escapers, $replacements, $row['name']);
50 6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	87	$recipes .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']);
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	88	$recipes .= '","type":"' . $row['type'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	89	$recipes .= '","batch_size":' . floatval($row['batch_size']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	90	$recipes .= ',"boil_time":' . floatval($row['boil_time']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	91	$recipes .= ',"efficiency":' . floatval($row['efficiency']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	92	$recipes .= ',"est_og":' . floatval($row['est_og']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	93	$recipes .= ',"est_fg":' . floatval($row['est_fg']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	94	$recipes .= ',"est_color":' . floatval($row['est_color']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	95	$recipes .= ',"color_method":"' . $row['color_method'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	96	$recipes .= '","est_ibu":' . floatval($row['est_ibu']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	97	$recipes .= ',"ibu_method":"' . $row['ibu_method'];
51 7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	98	$recipes .= '","mash_sparge_temp":' . $row['mash_sparge_temp'];
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	99	$recipes .= ',"mash_ph":' . $row['mash_ph'];
7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	100	$recipes .= ',"mash_name":"' . $row['mash_name'];
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	101	$recipes .= '","fermentables":' . $row['json_fermentables'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	102	$recipes .= ',"hops":' . $row['json_hops'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	103	$recipes .= ',"miscs":' . $row['json_miscs'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	104	$recipes .= ',"yeasts":' . $row['json_yeasts'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	105	$recipes .= ',"waters":' . $row['json_waters'];
51 7224109adfe1 More recipe editor changes Michiel Broek <mbroek@mbse.eu> parents: 50 diff changeset	106	$recipes .= ',"mashs":' . $row['json_mashs'];
49 4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	107	$recipes .= '}';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	108	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	109	$recipes .= ']';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	110	header("Content-type: application/json");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	111	echo $recipes;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	112	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	113	?>