<?php
// PHP script to read from MySQL database
// uses test file testfile3.txt
// required: either (email) or (missing and breed)
// returns rows as JSON
// Called From: MyDogsActivity and DisplayActivity

$myfile = fopen("testfile3.txt", "w"); // for testing

// detect what field is set so field & field_value can be used in query
if(isset($_POST['email'])){
	$field = "email";
	$field_value = $_POST['email'];
}
else if (isset($_POST['missing'])){
	$field = "missing";
	$missing = $_POST['missing'];
	$breed = $_POST['breed'];
	if($missing) // switch so opposite are returned
		$field_value = 0;
	else
		$field_value = 1;
}
fwrite($myfile, $field."\n"); // testing
fwrite($myfile, $breed."\n"); // testing
fwrite($myfile, $field_value." missing\n"); // testing

// Mysql -> make query ->execute query
$con=mysqli_connect("csmysql.snc.edu","mohrjv","LostDogs2019","LostDogs2019");
//Query to insert a dog
if($field == "email") // double quote for string
	$query = "SELECT * FROM dogs WHERE email = ".'"'.$field_value.'"';
else // single quote for number
	$query = "SELECT * FROM dogs WHERE missing = "."'".$field_value."' AND breed = ".'"'.$breed.'"';

$result = mysqli_query($con,$query); // get rows from db
fwrite($myfile, mysqli_num_rows($result)." num rows\n"); // test
// now do something with result...

// array with int index - for loop from link
// https://www.php.net/manual/en/mysqli-result.fetch-assoc.php
for ($set = array (); $row = $result->fetch_assoc(); $set[] = $row);

echo json_encode($set); // send it back to Java as JSON

fwrite($myfile, var_export(json_encode($set), true)); // test
fclose($myfile); // test
?>