$location = null;
}
// $servername = "localhost";
$servername = "engr-cpanel-mysql.engr.illinois.edu";
$username = "******";
$password = "******";
$dbname = "backpack_user";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
// echo "database connection failed <br>";
}
$content = mysqli_real_escape_string($conn, $content1);
$title = mysqli_real_escape_string($conn, $title1);
$author = mysqli_real_escape_string($conn, $author1);
$location = mysqli_real_escape_string($conn, $location1);
$rating = sentiment_analysis($contentIn);
$cmd = "SELECT * FROM crawled_posts WHERE title = '" . $title . "'";
$result = $conn->query($cmd);
// echo $result->num_rows." ";
// echo $content;
if ($result->num_rows == 0) {
// echo $content;
$cmd = "INSERT INTO crawled_posts(author, location, content, title, rating) VALUES('{$author}','{$location}','{$content}','{$title}', '{$rating}')";
if (!mysqli_query($conn, $cmd)) {
// echo "in ";
echo "Error: " . mysqli_error($conn) . " ";
}
echo "success";
return;
}
echo "duplicate";
$servername = "engr-cpanel-mysql.engr.illinois.edu";
$username = "******";
$password = "******";
$dbname = "backpack_user";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$cur_user = $_SESSION['login_user'];
$sql = "SELECT * FROM post";
$result = mysqli_query($conn, $sql);
if ($result->num_rows > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$su_content = $row['content'];
$su_sentiment = sentiment_analysis($su_content);
$insertrank = "UPDATE post set sentiment = '{$su_sentiment}'\n ";
mysqli_query($conn, $insertrank) or die(mysqli_error($conn));
}
}
}
?>
</div>
</div>
</div>
</div>
</body>
</html>
