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