commentpost-audio.php

<?php ob_start(); ?>
<?php 
error_reporting(1);
session_start();
$user_id = $_SESSION['user_id'];
?>
<?php
 if(!$user_id){
   header("location: index.php");
  exit;
 }
?>
<?php



$userid = $_SESSION['user_id'];
$src = NULL;
$ext = "";
//Based upon file, convert for use in database
if ($_FILES["file"]["type"] == "audio/mp3")
{
	$ext = "mp3";
	$src = $_FILES['file']['tmp_name'];
}else if ($_FILES["file"]["type"] == "audio/mp3")
{
	$ext = "mpeg";
	$src = $_FILES['file']['tmp_name'];
}else if ($_FILES["file"]["type"] == "audio/mpeg")
{
	$ext = "ogg";
	$src = $_FILES['file']['tmp_name'];
}



//Make sure it was a valid file, if not complain. 
if ((($ext == "mp3") ||($ext == "ogg") ||($ext == "mpeg") || ($ext == "gif")) && ($_FILES["file"]["size"] < 10000000))
  {
  	//Check for errors, make sure upload worked
  	if ($_FILES["file"]["error"] > 0)
    	{
    			$post_wid =$_POST['post_id'];
		   $success = 'success';
header("location: post.php?pid=$post_wid&success=$success");
exit();
    	}
 

		
		//Get pic info and upload pic to server
		$RandoNum = "hbrd";
		$RandomNum = rand(0, 999999999);
		$nameof = " $RandoNum-$RandomNum-$userid";
		$nameofa = "$RandomNum-hbrd";
		
		$picid = $nameof;
		$picturelocation = "userfiles/audio/$nameofa.$ext";
	
		//move pic
		move_uploaded_file($_FILES["file"]["tmp_name"],
      "$picturelocation");
	     
$content = $_POST['postcomment'];
$post_id =$_POST['post_id'];
$follow_userid =$_POST['user'];
$location =$_POST['location'];
$timestamp = time();
$type ="comment";
		include "connect.php";


	$e="INSERT INTO posts(post,user_id,timestamp,location,post_id,role,image,type)
    VALUES
    ('$content','$userid','$timestamp ','$location','$post_id','$type','$picturelocation','$ext')";	

	$sql=mysqli_query($conn, $e) ;

		$ie= "UPDATE posts
					 SET comments = comments + 1
					 WHERE id='$post_id'
					";
				
					$com=mysqli_query($conn, $ie) or die(mysql_error());
						$comxc=  "UPDATE users
					 SET posts = posts + 1
			 WHERE id='$user_id'
				";
              $gotor=mysqli_query($conn, $comxc) or die(mysql_error());
					
												if($user_id==$follow_userid){
				}else{
						$ea="INSERT INTO notifications(post_id,user_id,user2, timestamp,content,type,content_id) 
						 VALUES ('$post_id','$user_id','$follow_userid','$timestap','$contentr','$type','$post_id')
						";
						mysqli_query($conn, $ea) ;
						
						}
							//Get hashtags from user text
	
	$strings = $_POST['postcomment'];
 $result = explode('#',$strings);
 array_shift($result);
 
 

 
 //print_R($result);
//echo $cleantexts = implode($result, " 	"); 
 
  //  foreach($result as $key => $resul) {
   // $key = $result;
	//echo "$key 
//	";
	$value0 = $result[0];
   $value1 = $result[1]; 
   $value2 = $result[2];   
   $value3 = $result[3];   
   
   
   
   
   
  
if($value0){

$comie=	"INSERT INTO tags(tag,user_id,timestamp,location) 
						 VALUES ('#$value0','$user_id','$timestamp','$location')
						";	
						$comi=mysqli_query($conn, $comie) or die(mysql_error());
						if($value1){
$comie1="INSERT INTO tags(tag,user_id,timestamp,location) 
						 VALUES ('#$value1','$user_id','$timestamp','$location')
						";
						$comi1=mysqli_query($conn, $comie1) or die(mysql_error());
						}
						
						if($value2){
$comie2=	"INSERT INTO tags(tag,user_id,timestamp,location) 
						 VALUES ('#$value2','$user_id','$timestamp','$location')
						";
						$comi2=mysqli_query($conn, $comie2) or die(mysql_error());
						}	

						if($value3){
$comie3=	"INSERT INTO tags(tag,user_id,timestamp,location) 
						 VALUES ('#$value3','$user_id','$timestamp','$location')
						";
						$comi3=mysqli_query($conn, $comie3) or die(mysql_error());
						}
						
						}	
	$stringse = $_POST['content'];
 $resulte = explode('@',$stringse);
 array_shift($resulte);
 
 

 
 //print_R($result);
//echo $cleantexts = implode($result, " 	"); 
 
  //  foreach($result as $key => $resul) {
   // $key = $result;
	//echo "$key 
//	";
	$value0e = $resulte[0];
   $value1e = $resulte[1]; 
   $value2e = $resulte[2];   
   $value3e = $resulte[3];   
   $timestap = time();
   $types = "mention";
       $contenta = "Mentioned you on a post";
    
    $gotosms = "SELECT id,username
                          FROM users 
                          WHERE username='$value0e'
                          ";
		$querym=mysqli_query($conn, $gotosms) or die(mysql_error());
						 
    
    if(mysqli_num_rows($querym)>=1){
     
      $rows = mysqli_fetch_assoc($querym);
	  
	  
	 $id = $rows['id'];





     if($value0e){
       
                $not="INSERT INTO notifications(user_id,user2, timestamp,content,type) 
						 VALUES ('$user_id','$id','$timestap','$contenta','$types')
						";
						mysqli_query($conn, $not) or die(mysql_error());
					//	if($value1){
                     //    $comie1="INSERT INTO tags(tag,user_id,timestamp,location) 
					//	 VALUES ('#$value1','$user_id','$timestamp','$location')
					//	";
					//	$comi1=mysqli_query($conn, $comie1) or die(mysql_error());
					//	}					
						}	
							
   	}
   
		
	header("location: post.php?pid=$post_id");


      } 

else
	{
 		   $success = 'success';
header("location: post.php?pid=$post_id&success=$success");
exit();
	}
	header("location: post.php?pid=$post_id");
?><?php ob_end_flush();?>