Advertisement
Guest User

Untitled

a guest
Apr 15th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.15 KB | None | 0 0
  1. <?php
  2. SESSION_START();
  3.  
  4. if(isset($_POST["likeval"])){
  5.     /*
  6.      * Insert text data into database
  7.      */
  8.     $likeval = $_POST['likeval'];
  9.     $userID = $_POST['userID'];
  10.     $postID = $_POST['postID'];
  11.    
  12.     echo $likeval;
  13.     echo $userID;
  14.     echo $postID;
  15.  
  16.  
  17.     //DB details
  18.     // Connect to the database
  19.     $host = "localhost";
  20.     $database = "db_33101156";
  21.     $user = "33101156";
  22.     $password = "mynewpass";
  23.  
  24.     $connection = mysqli_connect($host, $user, $password, $database);
  25.     $error = mysqli_connect_error();
  26.     $dataTime = date("Y-m-d H:i:s");
  27.     if($error != null){
  28.         $output = "<p>Unable to connect to database!</p>";
  29.         die($output);
  30.     }
  31.     $user = $_SESSION['username'];
  32.     //Insert image content into database
  33.     $sql = "INSERT into likedPosts (username, postID) VALUES ('$userID', '$postID')";
  34.  
  35.     // $sql = "INSERT into images (image, created) VALUES ('$imgContent', '$dataTime')";
  36.     $insert = mysqli_query($connection,$sql);
  37.     if($insert){
  38.         echo "successful text post.";
  39.     }else{
  40.         echo "text post upload failed, please try again.";
  41.         echo $sql;
  42.     }
  43. }
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement