/myproj/addfav.php

<?php
 session_start(); require_once 'function.inc.php';
  $u=$_SESSION[u_uid];
  
//                  *****************
//                  
//Programmer : Mr. Suhas Talekar
//Student ID : 12526175
//Contact email : suhaskrishna.talekar@my.jcu.edu.au
//
//                  *****************
  
                    $hostname='localhost';
                    $username='root';
                    $pwd='';
                    $dbname='jcu_e-cafe';
         
                    $connect=mysql_connect($hostname,$username,$password) or die (" Not able to connect-s);");
                    mysql_select_db($dbname,$connect);
                    $i=$_GET['id'];
                    
                    $query="SELECT Favourite_1,Favourite_2,Favourite_3 from  favourite where Favourite_ID='$u'";
                    $results=  mysql_query($query) or die(mysql_error()); 
                    $num_results = mysql_num_rows($results);
                    //if num_results is zero the user has never favorited .there is no entry of fav for that user
                    if ($num_results==0)
                    {
                    $query="Insert into favourite values ($u,$i,0,0)";
                    $results=  mysql_query($query) or die(mysql_error()); 
                    ?>
                    <script language="javascript">
                    alert('Favorite added ! ');window.location.href = 'home.php';
                    </script>
                    
                    <?php
                    }
                    
                    if ( $num_results>0) //the user has already made fav.
                    {
                    $query="SELECT Favourite_1,Favourite_2,Favourite_3 from  favourite where Favourite_ID='$u'";
                    $results=  mysql_query($query) or die(mysql_error());   
                    $msg="none";
                    $row=mysql_fetch_array($results);
                    if ($row['Favourite_1']==$i)
                    { 
                        $msg="Favorite already exists !";
                    }
                     
                    if ($row['Favourite_2']==$i)
                    { 
                       $msg="Favorite already exists !"; 
                    }
                     
                    if ($row['Favourite_3']==$i)
                    { 
                     $msg="Favorite already exists !";
                    }
                    //}
                    if ($msg!="none")
                    {
                    ?>
                    
                    <script language="javascript">
                    alert('<?php echo "$msg"; ?>');window.location.href = 'home.php';
                    </script>
                    <?php
                    }
                    if ($msg=="none")
                    {
                    $blank=0;
                    if ($row['Favourite_1']==0)
                    { 
                        $blank=1;
                        $query="UPDATE favourite SET Favourite_1 = $i WHERE Favourite_ID='$u'";
                        

                    }
                     
                    if ($row['Favourite_2']==0)
                    { 
                       $blank=2; 
                       $query="UPDATE favourite SET Favourite_2 = $i WHERE Favourite_ID='$u'";
                    }
                     
                    if ($row['Favourite_3']==0)
                    { 
                     $blank=3;
                     $query="UPDATE favourite SET Favourite_3 = $i WHERE Favourite_ID='$u'";
                    }
                    
                    if($blank!=0) //space for fav is avaliable
                    {
                      $results=  mysql_query($query) or die(mysql_error()); 
                    ?>
                    <script language="javascript">
                    alert('Favorite added !');window.location.href = 'home.php';
                    </script>
                    
                    <?php  
                    }
                    
                    if ($blank==0) //no more space for fav avaliable
                    {
                     ?>
                    <script language="javascript">
                       
                    alert('Favorites are full ! Please delete some from your favorites page.');window.location.href = 'home.php';
                    </script>
                    
                    <?php    
                    }
                    
                    }
                    
                    }
                    
                   
                    ?>