<div class="navbar-inner"> <a class="brand" href='?'><?php echo $project_title; ?> </a> <!-- --> <ul class="nav"> <li class='tab-header active algo-header' id='tab-movies'><a href="#" onclick='show_tabs("movies")'>Movies</a></li> <li class='dropdown tab-header' id='header-recommendationalgos'> <a class='dropdown-toggle' href="#" data-toggle="dropdown" id='tab-recommendationalgos' >Recommendation Algos <b class="caret"></b></a> <ul class="dropdown-menu" aria-labelledby="tab-recommendationalgos"> <?php $sql = "SELECT DISTINCT algorithm FROM recommendations"; $stat = prepareStatement($sql); $stat->execute(); $rows = $stat->fetchAll(); foreach ($rows as $row) { $algo = $row['algorithm']; print "<li id='tab-" . $algo . "' class='algo-header'><a href='#' onclick='show_rec_tabs(\"{$algo}\")'>{$algo}</a></li>"; } ?> </ul> </li> <li class='tab-header algo-header' id='tab-hybrid'><a href="#" onclick='show_tabs("hybrid")'>Hybrid</a></li> <li class='tab-header algo-header' id='tab-stats'><a href="#" onclick='show_tabs("stats")'>Stats</a></li> <li class="divider-vertical"></li> <li class='dropdown'>
public function saveAlgorithmWeights($algos, $user) { //clear old weights $sql = "DELETE FROM algorithmweights WHERE userid=?"; $stat = prepareStatement($sql); $stat->bindParam(1, $user); $stat->execute(); //insert new ones foreach ($algos as $algo => $score) { $sql = "INSERT INTO algorithmweights (algorithm, weight, userid) VALUES (?,?,?)"; $stat = prepareStatement($sql); $stat->bindParam(1, $algo); $stat->bindParam(2, $score); $stat->bindParam(3, $user); $stat->execute(); } }
function get_number_of_hybridrecommendations($user) { $sql = "SELECT COUNT(*) FROM h_recommendations WHERE userid=?"; $stat = prepareStatement($sql); $stat->bindParam(1, $user); $stat->execute(); $res = $stat->fetchAll(); return $res[0][0]; }
function sync_ratings() { $sql = "SELECT ratings.userid, ratings.movieid, ratings.rating, UNIX_TIMESTAMP(ratings.time) as time, movies.title, movies.year from ratings INNER JOIN movies ON ratings.movieid = movies.movieid"; $stat = prepareStatement($sql); $stat->execute(); $rows = $stat->fetchAll(); $local_path = str_replace('actions.php', '', __FILE__) . 'calc_recs'; $rating_file = 'ratings.dat'; $fh = fopen("{$local_path}/{$rating_file}", 'w') or die("can't open file"); foreach ($rows as $row) { //999999::1::4::1357741027 $userid = $row['userid']; $movieid = $row['movieid']; #IMDb ID must be 7 chars long while (strlen($movieid) < 7) { $movieid = '0' . $movieid; } $rating = $row['rating']; //0000-00-00 00:00:00 $thetime = $row['time']; $title = trim($row['title']); $year = trim($row['year']); fwrite($fh, $userid . '::' . $movieid . '::' . $rating . '::' . $thetime . "\n"); } fclose($fh); }