<?php
  session_start();

  if(isset($_POST['search-submit'])) {
    $currentFilter;
    if(isset($_POST['search-filter']) && $_POST['search-filter'] == "search-all") {
      $currentFilter = "All";
    } else if(isset($_POST['search-filter']) && $_POST['search-filter'] == "search-by-title") {
      $currentFilter = "Title";
    } else if(isset($_POST['search-filter']) && $_POST['search-filter'] == "search-by-language") {
      $currentFilter = "Language";
    } else {
      $currentFilter = "Username";
    }
  }

  if(isset($_POST['search-submit']) && $_POST['search'] !== "") {
    require_once 'includes/config.php';

    $searchQuery = '%' . htmlspecialchars($_POST['search']) . '%';
    $statement;

    if(htmlspecialchars($_POST['search-filter']) == "search-all") {
      $statement = $conn->prepare("SELECT * FROM user_posts WHERE privacy = 0 AND title LIKE ? OR username LIKE ?  OR language LIKE ?");
      $statement->bind_param("sss", $searchQuery, $searchQuery, $searchQuery);
    } else if(htmlspecialchars($_POST['search-filter']) == "search-by-title") {
      $statement = $conn->prepare("SELECT * FROM user_posts WHERE privacy = 0 AND title LIKE ?");
      $statement->bind_param("s", $searchQuery);
    } else if(htmlspecialchars($_POST['search-filter']) == "search-by-language") {
      $statement = $conn->prepare("SELECT * FROM user_posts WHERE privacy = 0 AND language LIKE ?");
      $statement->bind_param("s", $searchQuery);
    } else {
      $statement = $conn->prepare("SELECT * FROM user_posts WHERE privacy = 0 AND username LIKE ?");
      $statement->bind_param("s", $searchQuery);
    }

    $statement->execute();
    $result = $statement->get_result();
  }
?>



<?php
if(isset($_POST['search-submit']) && $_POST['search'] !== "") {
  if($result->num_rows > 0) {
    $i = 1;
    echo '<ul class="list-group mt-5">';
    while($row = $result->fetch_assoc()) {
      $linkName = "post.php?postID=" . $row['postID'];
      $privacy = ($row['privacy'] == 0) ? "Public" : "Private";
      if($privacy == "Public" || ($privacy == "Private" && (isset($_SESSION['username']) && ($row['username'] == $_SESSION["username"])))) {
        echo '
          <a class="post-box-link" href="' . $linkName . '">
            <li class="list-group-item mb-2 border rounded post-box">
              <h4><span style="color: #007bff;">' . $row['title'] . '</span> | ' . $row['language'] . '</h4>
              <h5>' . $row['username'] . ' - ' . '<small>' . $row['uploadDate'] . '</small></h5>
            </li>
          </a>
        ';
        $i++;
      }
    }
    echo '</ul>';
  }
}
?>

<?php
   $json ='{"id":1,"name":"foo","interest":["wordpress","php"]}';
   $obj=json_decode($json);
   echo $obj->interest[1]; //prints php
?>

<?php
//generate 239 rgba colors for codecatch's 239 supported programming languages!
//this was used to generate the colors that are used in the pie chart on https://codecatch.net/graphs.php
function rgbagenerator() {
  $count = 239;
  for ($i=0; $i < $count; $i++) {
    echo "'rgba(". mt_rand(0,255) . ",". mt_rand(0,255) . ",". mt_rand(0,255) . ",1)',";
    echo "<br>";
  }
}

rgbagenerator();
?>

<?php
$username = "Austin Leath -_#";
$username_err = "no error";
if(preg_match('/[^a-z_\-0-9]/i', $string)) {
  $username_err = "Username can only contain alphanumeric characters, dashes, and underscores.";
}

echo $username_err
?>

<?php
$listOfFiles = glob("*.{jpg,png,gif,tiff,jpeg}", GLOB_BRACE);

echo 'images = []; ';

for($x = 0; $x <= count($listOfFiles)-1; $x++) {
	echo "images[" . $x . "] =" . '"' . $listOfFiles[$x] . '"' . "; ";
}
?>

<?php
function getRandomId($min = NULL, $max = NULL) {
    if (is_numeric($min) && is_numeric($max)) {
        return mt_rand($min, $max);
    }
    else {
        return mt_rand();
    }
}
?>