Interests_requestController.php

Go to the documentation of this file.

<?php

class Interests_requestController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }

        public function autocomplete_subtopics()
        {
            
            Connect_DatabaseController::connect(); 
            if(isset($_POST['topname']))
            {
            $topname = $_POST['topname'];
            $ar = mysql_query("SELECT * FROM interests_subtopics WHERE id IN 
                            (SELECT subtopicid FROM topic_subtopic WHERE topicid IN
                            (SELECT id FROM interests_topics WHERE name='$topname'))");

            $i=0;
            
            if(mysql_num_rows($ar)!=0)
            {
            while($row = mysql_fetch_array($ar))
            {
                $nam[$i] = $row['name'];
                echo "<b>" . ($i+1) . ")</b>" . $row['name'] . "<br>";
                $i++; 
            }
            echo "<br>";
            
            return $nam;
            }
            }
            
        }
        
        public function autocomplete_alltopics()
        {
            
            Connect_DatabaseController::connect(); 
            
            $ar = mysql_query("SELECT * FROM interests_topics");

            $i=0;
            
            if(mysql_num_rows($ar)!=0)
            {
            while($row = mysql_fetch_array($ar))
            {
                $nam2[$i] = $row['name'];
                $i++; 
            }
            
            return $nam2;
            
            }
            
        }        
        
        public function autocomplete_allsubtopics()
        {
            
            Connect_DatabaseController::connect(); 

            $ar = mysql_query("SELECT * FROM interests_subtopics");

            $i=0;
            
            if(mysql_num_rows($ar)!=0)
            {
            while($row = mysql_fetch_array($ar))
            {
                $nam[$i] = $row['name'];
                $i++; 
            }
            
            return $nam;
            }
  
        }
        
        public function view_subtopics()
        {
            

            Connect_DatabaseController::connect(); 
            
            $topname = $_POST['topic'];

            
            echo "<form action='index.php?r=interests_selection/index' method='post'>";          

                $topics = mysql_query("SELECT * FROM interests_topics WHERE name='$topname'");

                $i=0;
                $k=0;
                $o=0;
                if(mysql_num_rows($topics)!=0)
                {
                while($row = mysql_fetch_array($topics))
                        {
                        $as[$o] = $row['name'];
                        $asd[$o] = $row['id'];
                        $result1 = mysql_query("SELECT subtopicid FROM topic_subtopic WHERE topicid='$asd[$o]'");
                            echo "<h3>$as[$o]</h3>" . "";

                        while($row2 = mysql_fetch_array($result1))
                                {
                                $asd2 = $row2['subtopicid'];
                                
                                $result2 = mysql_query("SELECT name FROM interests_subtopics WHERE id='$asd2'");
                                
                                    while($row3 = mysql_fetch_array($result2))
                                    {

                                        $asd3[$k] = $row3['name'];
                                        
                                                        echo "<B>".($k+1)."</B>" . ") ";

                echo "<input type='checkbox' name='topicid[]' value=$asd2>";

//                echo "<a href=\" ./index.php?r=user_profile/index&username=$asd3[$k]\">" . $asd3[$k] . "</a><br><br>";                
                echo $asd3[$k] . "</a><br><br>";                


                                    }
                                $k++;
                                
                                }
                        $co = $row2['subtopicid'];
                $k=0;
                $o++;
                $i++;
                        }      
                }
                else echo "No Subtopics For This Topic<br><br>";
            
            $j=0;
            $l=0;
            
            
    echo "<input type='radio' name='knowledge' value='1' /> Mediocre Knowledge";
    echo "<input type='radio' name='knowledge' value='2' /> Good Knowledge";
    echo "<input type='radio' name='knowledge' value='3' /> Excellent Knowledge";
    echo "<br>";
    echo "<input type='submit' name=\'formSubmit' value='Select Interests' />";           
    echo "</form>";  
            
        }        
    // 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',
            ),
        );
    }
    */
}