ABCD/suggest.php at master · abbccdda/ABCD · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php

session_start();

$username = $_SESSION["user"];
$game = $_POST["game"];

require_once "classes/connecToDB.php";
$con = connectToDB();
if($con === false):
    return;
endif;

$searchGame = addslashes($game);
$sql = "SELECT similar_games FROM games WHERE name = '$searchGame'";

$result = mysqli_query($con, $sql);
if(!$result) {
    die('Error: ' . mysqli_error($con));
}

$row = mysqli_fetch_array($result);


if(strlen($row['similar_games']) === 0) {
    echo "no similar games";
    return;
}
else {
    $similar = $row['similar_games'];
    $similar = explode("<br>", $similar);
    $similar = array_slice($similar, 1);
}

//$similar = "<br>".implode("<br>", $similar);
//var_dump($similar);

$sql = "SELECT * FROM users WHERE email = '$username'";

$result = mysqli_query($con, $sql);
if(!$result) {
    die('Error: ' . mysqli_error($con));
}

$row = mysqli_fetch_array($result);

if(strlen($row['gamesMightLike']) === 0) {
    $mightLike = array();
} else {
    $mightLike = explode("<br>", $row['gamesMightLike']);
    $mightLike = array_slice($mightLike, 1);
}

if(strlen($row['gamesLiked']) === 0) {
    $gamesLiked = array();
} else {
    $gamesLiked = stripslashes( $row['gamesLiked']);
    $gamesLiked = explode("<br>", $gamesLiked);
    $gamesLiked = array_slice($gamesLiked, 1);
}

if(strlen($row['gamesDisliked']) === 0) {
    $disliked = array();
} else {
    $disliked = explode("<br>", $row['gamesDisliked']);
    $disliked = array_slice($disliked, 1);
}
var_dump($similar);
var_dump($gamesLiked);
$lenArr = count($similar);
for($i=0; $i<$lenArr; $i++):
    if (($key = array_search($similar[$i], $gamesLiked)) !== false || ($key = array_search($similar[$i], $disliked)) !== false) {
        unset($similar[$i]);
    }
endfor;

$newArr = array_unique(array_merge($mightLike, $similar));
if(count(newArr) === 0) {
    echo "no similar games";
    return;
}


$newGamesMightLike = "<br>".implode("<br>", $newArr);

$newGamesMightLike = addslashes($newGamesMightLike);
$sql = "UPDATE users SET gamesMightLike = '$newGamesMightLike' WHERE email = '$username'";
$result = mysqli_query($con, $sql);
if(!$result) {
    die('Error: ' . mysqli_error($con));
}

echo "similar games added";