InterestsController.php

Go to the documentation of this file.

<?php

class InterestsController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function autocomplete_topics()
        {
            
            Connect_DatabaseController::connect(); 

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

            $i=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>";  
            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++;
                        }      
            
            $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><br>";  
                
                
                echo "<form action='index.php?r=interests_request/index' method='post'>";          
                echo "<textarea hidden name='topname'>" . $topname . "</textarea>";
                echo "<input type='submit' name=\'formSubmit2' value='Add Subtopics For This Interest' />";           
                echo "</form>";  

                }

                else if($topname!=null)
                {
                    echo "</form>";  
                    echo "<form action='index.php?r=interests_request/index' method='post'>";          
                    echo "No Subtopics For " . $topname . "<br><br>";
                    //echo "<input hidden name='topname' value=$topname >"; 
                    echo "<textarea hidden name='topname'>" . $topname . "</textarea>";
                    echo "<input type='submit' name=\'formSubmit2' value='Add Subtopics For This Interest' />";           
                    echo "</form>";  
                }
                else 
                {
                    echo "</form>";  
                    echo "No Topic Specified.";
                }
                
                }
        
        public function view_topics()
        {
            
            Connect_DatabaseController::connect(); 
            
            echo "<form action='index.php?r=interests_selection/index' method='post'>";          

                $topics = mysql_query("SELECT * FROM interests_topics");

                $i=0;
                $k=0;
                $o=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++;
                        }            
            
            $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>";
            
            
            /*
while($l<sizeof($as))
{
    
    echo "<h3>$as[$l]</h3>" . "";
    
            while($j<sizeof($asd3))
            {
                echo "<B>".($j+1)."</B>" . ") ";

                echo "<input type='checkbox' name='names[]' value=$asd3[$j]>";

                echo "<a href=\" /test/index.php?r=user_profile/index&username=$asd3[$j]\">" . $asd3[$j] . "</a><br><br>";                
                $j++;
            }
            
            $l++;
}           
            */
            
            
           
        }

    // 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',
            ),
        );
    }
    */
}