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

www/includes/db_recipes.php@6d94167c2697 (annotated)

www/includes/db_recipes.php

Sat, 01 Sep 2018 22:24:09 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Sat, 01 Sep 2018 22:24:09 +0200

changeset 50

6d94167c2697

parent 49

4d27a7fb1265

child 51

7224109adfe1

permissions

-rw-r--r--

Next steps to implement a recipe editor

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
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	19	$query = "SELECT * FROM recipes ORDER BY style_guide,style_letter,style_name,name";
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'];
50 6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	71	$recipes .= ',"style_guide":"' . str_replace($escapers, $replacements, $row['style_guide']);
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	72	$recipes .= '","style_letter":"' . str_replace($escapers, $replacements, $row['style_letter']);
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	73	$recipes .= '","style_name":"' . str_replace($escapers, $replacements, $row['style_name']);
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	74	$recipes .= '","name":"' . str_replace($escapers, $replacements, $row['name']);
6d94167c2697 Next steps to implement a recipe editor Michiel Broek <mbroek@mbse.eu> parents: 49 diff changeset	75	$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	76	$recipes .= '","type":"' . $row['type'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	77	$recipes .= '","batch_size":' . floatval($row['batch_size']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	78	$recipes .= ',"boil_time":' . floatval($row['boil_time']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	79	$recipes .= ',"efficiency":' . floatval($row['efficiency']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	80	$recipes .= ',"est_og":' . floatval($row['est_og']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	81	$recipes .= ',"est_fg":' . floatval($row['est_fg']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	82	$recipes .= ',"est_color":' . floatval($row['est_color']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	83	$recipes .= ',"color_method":"' . $row['color_method'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	84	$recipes .= '","est_ibu":' . floatval($row['est_ibu']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	85	$recipes .= ',"ibu_method":"' . $row['ibu_method'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	86	$recipes .= '","fermentables":' . $row['json_fermentables'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	87	$recipes .= ',"hops":' . $row['json_hops'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	88	$recipes .= ',"miscs":' . $row['json_miscs'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	89	$recipes .= ',"yeasts":' . $row['json_yeasts'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	90	$recipes .= ',"waters":' . $row['json_waters'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	91	$recipes .= ',"mash":' . $row['json_mash'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	92	$recipes .= '}';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	93	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	94	$recipes .= ']';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	95	header("Content-type: application/json");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	96	echo $recipes;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	97	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	98	?>