Interests_confirmationController.php

Go to the documentation of this file.

<?php

class Interests_confirmationController extends Controller
{
    public function actionIndex()
    {
        $this->render('index');
    }
        
        public function view_topics()
        {
            
            Connect_DatabaseController::connect(); 
            
            echo "<form action='index.php?r=interests_confirmation_function/index&new=1' method='post'>";          
                $topics = mysql_query("SELECT * FROM interests_topics_confirmation WHERE id IN (SELECT topicid FROM topic_subtopic_confirmation WHERE accepted=0)");
                
                $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_confirmation WHERE topicid='$asd[$o]' AND accepted=0");
                            echo "<h3>$as[$o]</h3>" . "";

                        while($row2 = mysql_fetch_array($result1))
                                {
                                $asd2 = $row2['subtopicid'];
                                
                                $result2 = mysql_query("SELECT name FROM interests_subtopics_confirmation 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 "<input type='hidden' name='topid[]' value=$asd[$o]>";
//                echo "<a href=\" /test/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++;
                        }

            echo "<input type='submit' name=\'formSubmit' value='Confirm Requests' />";           
            echo "</form><br>";
            
            
  
           
        }
        
        public function existing_interests()
        {
          Connect_DatabaseController::connect(); 

          echo "<form action='index.php?r=interests_confirmation_function/index&new=0' method='post'>";          
                $topics = mysql_query("SELECT * FROM interests_topics WHERE id IN (SELECT topicid FROM topic_subtopic_existing_confirmation WHERE accepted=0)");
                
                $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_existing_confirmation WHERE topicid='$asd[$o]' AND accepted=0");
                            echo "<h3>$as[$o]</h3>" . "";

                        while($row2 = mysql_fetch_array($result1))
                                {
                                $asd2 = $row2['subtopicid'];
                                
                                $result2 = mysql_query("SELECT name FROM interests_subtopics_confirmation 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 "<input type='hidden' name='topid[]' value=$asd[$o]>";

//                echo "<a href=\" /test/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++;
                        }

            echo "<input type='submit' name=\'formSubmit' value='Confirm Requests' />";           
            echo "</form><br>";   
            
            
        }
    // 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',
            ),
        );
    }
    */
}