Interests_selectionController.php

Go to the documentation of this file.

<?php

class Interests_selectionController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function selectfunction($topicid)
        {
            
            Connect_DatabaseController::connect(); 
            
            if(Yii::app()->user->id != NULL)
                $usid = Yii::app()->user->id;
            else
                $usid = 0;
            
            $knowledge=$_POST["knowledge"];
            
            $sql_delete_interest_user="DELETE FROM interest_user
                                    WHERE userid=$usid AND interestid=$topicid";
mysql_query($sql_delete_interest_user) or die (mysql_error());

            
            $sql_insert_interest_user="INSERT INTO interest_user ( userid, interestid, knowledge)
VALUES
('$usid', '$topicid', '$knowledge')";
mysql_query($sql_insert_interest_user) or die (mysql_error());

            
            
        }

    // Uncomment the following methods and override them if needed
    /*
    public function filters()
    {
        // return the filter configuration for this controller, e.g.:
        return array(
            'inlineFilterName',
            array(
                'class'=>'path.to.FilterClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }

    public function actions()
    {
        // return external action classes, e.g.:
        return array(
            'action1'=>'path.to.ActionClass',
            'action2'=>array(
                'class'=>'path.to.AnotherActionClass',
                'propertyName'=>'propertyValue',
            ),
        );
    }
    */
}