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

www/includes/db_recipes.php@4d27a7fb1265 (annotated)

www/includes/db_recipes.php

Fri, 31 Aug 2018 15:18:20 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Fri, 31 Aug 2018 15:18:20 +0200

changeset 49

4d27a7fb1265

child 50

6d94167c2697

permissions

-rw-r--r--

Finisched recipe import. Added recipe retrieve script.

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
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	3	//require($_SERVER['DOCUMENT_ROOT']."/config.php");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	4	//require($_SERVER['DOCUMENT_ROOT']."/version.php");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	5	require("../config.php");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	6	require("../version.php");
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
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	15	// get data and store in a json array
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	16	$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	17	if (isset($_GET['insert'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	18	// // INSERT COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	19	// $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	20	// $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	21	// $sql .= "', steps='" . json_encode($_GET['steps']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	22	// $sql .= "';";
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	23	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	24	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	25	// 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	26	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	27	// 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	28	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	29	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	30
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	31	//} else if (isset($_GET['update'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	32	// // UPDATE COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	33	// $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	34	// $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	35	// $sql .= "', steps='" . json_encode($_GET['steps']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	36	// $sql .= "' WHERE record='" . $_GET['record'] . "';";
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	37	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	38	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	39	// 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	40	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	41	// 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	42	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	43	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	44
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	45	//} else if (isset($_GET['delete'])) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	46	// // DELETE COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	47	// $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	48	// $result = mysqli_query($connect, $sql);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	49	// if (! $result) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	50	// 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	51	// } else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	52	// 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	53	// }
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	54	// echo $result;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	55
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	56	} else {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	57	// SELECT COMMAND
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	58	$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	59	$recipes = '[';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	60	$comma = FALSE;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	61	while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	62	// Manual encode to JSON.
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	63	if ($comma) {
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	64	$recipes .= ',';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	65	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	66	$comma = TRUE;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	67	$recipes .= '{"record":' . $row['record'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	68	$recipes .= ',"style_guide":"' . $row['style_guide'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	69	$recipes .= '","style_letter":"' . $row['style_letter'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	70	$recipes .= '","style_name":"' . $row['style_name'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	71	$recipes .= '","name":"' . $row['name'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	72	$recipes .= '","notes":"' . $row['notes'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	73	$recipes .= '","type":"' . $row['type'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	74	$recipes .= '","batch_size":' . floatval($row['batch_size']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	75	$recipes .= ',"boil_time":' . floatval($row['boil_time']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	76	$recipes .= ',"efficiency":' . floatval($row['efficiency']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	77	$recipes .= ',"est_og":' . floatval($row['est_og']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	78	$recipes .= ',"est_fg":' . floatval($row['est_fg']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	79	$recipes .= ',"est_color":' . floatval($row['est_color']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	80	$recipes .= ',"color_method":"' . $row['color_method'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	81	$recipes .= '","est_ibu":' . floatval($row['est_ibu']);
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	82	$recipes .= ',"ibu_method":"' . $row['ibu_method'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	83	$recipes .= '","fermentables":' . $row['json_fermentables'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	84	$recipes .= ',"hops":' . $row['json_hops'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	85	$recipes .= ',"miscs":' . $row['json_miscs'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	86	$recipes .= ',"yeasts":' . $row['json_yeasts'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	87	$recipes .= ',"waters":' . $row['json_waters'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	88	$recipes .= ',"mash":' . $row['json_mash'];
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	89	$recipes .= '}';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	90	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	91	$recipes .= ']';
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	92	header("Content-type: application/json");
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	93	echo $recipes;
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	94	}
4d27a7fb1265 Finisched recipe import. Added recipe retrieve script. Michiel Broek <mbroek@mbse.eu> parents: diff changeset	95	?>