$search = $_POST['search_input'];
if ($search !== "") {
require 'pdo_db_connect.php';
$conn = func_connect_db("gamehoarder");
if ($conn) {
if (isset($_POST['search'])) {
$game_list = func_getGames($conn, $search);
} else {
$game_list = func_getGamesbyDev($conn, $search);
}
}
$numrows = count($game_list);
if ($numrows > 0) {
echo "<div class=\"container\">\r\n <div class=\"row\">";
for ($i = 0; $i < $numrows; $i++) {
echo "\r\n <div class=\"container thumbnail col-md-3\" >\r\n <img src=\"" . func_getGameImage($conn, $game_list[$i]['name']) . "\" width=\"300\" height=\"240\"/>\r\n <div class=\"caption\">\r\n <h5><strong>" . $game_list[$i]['name'] . "</strong></h5><p>Rating: " . $game_list[$i]['rating'] . "</p>\r\n <p>Year: " . $game_list[$i]['year'] . "</p>\r\n <p>Genre: " . $game_list[$i]['genre'] . "</p>\r\n <p id=\"mybutton1\" class=\"btn btn-primary\" onclick=\"insertGameUser('" . $game_list[$i]['name'] . "','" . $_SESSION['username'] . "')\">Add</p>\r\n </div>\r\n </div>";
}
echo "</div></div>";
}
}
}
?>
<script type="text/javascript">
function insertGameUser(game,user) {
// code for IE7+, Firefox, Chrome, Opera, Safari
var xmlhttp=new XMLHttpRequest();
var str = "insertuser="******"&insertgame=" + encodeURIComponent(game);
str = "pdo_db_connect.php?" + str;
alert(game+" added to collection");
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1><p>recommendations</p></h1>
<!-- commenet dynamically create the php page here -->
<!-- get user history-->
<?php
require 'pdo_db_connect.php';
$conn = func_connect_db("gamehoarder");
$username = $_SESSION['username'];
$game_list = func_getTopGamesByUsers($conn, $username, 20);
$numrows = count($game_list);
if ($numrows > 0) {
echo "<div class=\"container\">\n <div class=\"row\">";
for ($i = 0; $i < $numrows; $i++) {
echo "\n<div class=\"container thumbnail col-lg-3\" >\n <img src=\"" . func_getGameImage($conn, $game_list[$i]['name']) . "\" width=\"300\" height=\"240\"/>\n <div class=\"caption\">\n <h5><strong>" . $game_list[$i]['name'] . "</strong></h5> \n <h5><strong>users : " . $game_list[$i]['count'] . "</strong></h5> \n <p id=\"mybutton1\" class=\"btn btn-primary\" onclick=\"insertGameUser('" . $game_list[$i]['name'] . "','" . $_SESSION['username'] . "')\">Add</p>\n </div>\n</div>";
}
echo "</div></div>";
}
?>
</div>
</div>
</div>
</div>
</div><!--end col-->
</div><!--end row-->
