<?php 
   session_start();
   // require_once('../system/loginCheck.php'); 
   require_once('./system/dbConn.php');
   connect();


   $vid=$_GET['vid'];
   $userid=$_SESSION['userid'];

   $sqlQu="select * from collects where vid=$vid and uid=$userid";
   $resultQu=mysql_query($sqlQu);
   $numQu=mysql_num_rows($resultQu);
   if ($numQu>0) {
   	$sql="delete from collects where vid=$vid and uid=$userid";
   	$flag=0;
   }
   else{
	$sql="insert into collects values(null,'$userid','$vid')";
	$flag=1;
}


	$result=mysql_query($sql);//执行sql语句
	//增删改查操作$result位操作成功结果的记录条数
	//查询$result位结果集类型
	if ($result) {
		if ($flag==0) {
		echo "<i class='glyphicon glyphicon-star-empty'></i>收藏";
		}
		else{
		echo "<i class='glyphicon glyphicon-star'></i>已收藏";
		}
		// header("refresh:2;url='show.php?vid=$vid'");
		// header("location:show.php?vid=$vid");
		
	}
	else{
		// echo "<br>收藏失败";
	}
   ?>