$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-->