<commit_before><?php 
	require_once 'includes/filter-wrapper.php';
require_once 'includes/db.php';

$results = $db->query('SELECT id, name, longitude, latitude, address 
				FROM gardens 
				ORDER BY name ASC');
?>

<!DOCTYPE HTML>
<html>
<head>
<!--	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
-->	<meta charset="utf-8">
	<title>Gardens</title>
	<link href="css/public.css" rel="stylesheet">
	<script type="text/javascript"
		src="http://maps.googleapis.com/maps/api/js?key=AIzaSyAN6BT9K7vBTXbTaGnTsqF3jQIy_Q7rpV0&sensor=false"><commit_msg>Suggested changes to help multiple loops of query results.<commit_after><?php 
	require_once 'includes/filter-wrapper.php';
require_once 'includes/db.php';

// When using ->query(), the results variable isn't a real array, its an iterable object
//  Therefore, after the first loop has completed, it isn't being reset to the start
// By calling the ->fetchAll() method on the variable, we get a real array, and can loop multiple times.
$stmt = $db->query('SELECT id, name, longitude, latitude, address 
				FROM gardens 
				ORDER BY name ASC');
$results = $stmt->fetchAll();
?>

<!DOCTYPE HTML>
<html>
<head>
<!--	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
-->	<meta charset="utf-8">
	<title>Gardens</title>
	<link href="css/public.css" rel="stylesheet">
	<script type="text/javascript"
		src="http://maps.googleapis.com/maps/api/js?key=AIzaSyAN6BT9K7vBTXbTaGnTsqF3jQIy_Q7rpV0&sensor=false">
{'fraction_non_alphanumeric': 0.15983881799865682, 'fraction_numerical': 0.01208865010073875, 'mean_word_length': 5.182572614107884, 'pattern_counts': {'":': 0, '<': 25, '<?xml version=': 0, '>': 30, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6133510', 'n_tokens_mistral': 551, 'n_tokens_neox': 513, 'n_words': 125}