find-snippets.php

<?php
	session_start();

	include 'database/connect.php';
	include 'functions.php';

	protect();

	$tag = $_POST['tag'];
	$query = $con->prepare("SELECT user_id FROM users WHERE username = ?");
	$query->bind_param("s", $_SESSION['user']);
	$query->execute();
	$query->bind_result($user_id);
	$query->fetch();
	$query->close();

	$snippetArray = array();
	$query = $con->prepare("SELECT snippets_id FROM tags_snippets WHERE tags = ? AND user_id = ? order by id desc");
	$query->bind_param("ss", $tag, $user_id);
	$query->execute();
	$query->bind_result($snippet_id);
	while($query->fetch()){
		$snippetArray[] = $snippet_id;
	}
	$query->close();

	$snippetData = array();
	$query = $con->prepare("SELECT id, title FROM snippets WHERE id = ? AND user_id = ?");
	foreach($snippetArray as $snippet){
		$query->bind_param("ss", $snippet, $user_id);
		$query->execute();
		$query->bind_result($snippetId, $title);
		$query->fetch();
		$snippetData['snippetId'][] = $snippetId;
		$snippetData['title'][] = $title;
	}
	$query->close();
	echo json_encode($snippetData);

?>