<?php
    include('config.php');
    define( '_JEXEC', 1 );
    define('JPATH_BASE', dirname(__FILE__) );
    define( 'DS', DIRECTORY_SEPARATOR );
    require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
    require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
    require_once ( JPATH_BASE .DS.'libraries'.DS.'joomla'.DS.'factory.php' );
    
    session_start();

    $mainframe =& JFactory::getApplication('site');
    $user =& JFactory::getUser();             
    
    if (!$user->guest) {
        $db_connection=mysql_connect($host, $username, $password, $db_name);
        if (!$db_connection) {
            die("<br><b>Database Error:</b> Could not connected. Try again later.<br>");
            exit;
        }
        @mysql_select_db($db_name, $db_connection) or die("Unable to select database.");
        mysql_query("SET NAMES 'utf8'", $db_connection);
  
        if(sizeof($_POST['lessons']) != 0) {
        $_SESSION['LESSONS_IDS'] = $_POST['lessons'];
        
        session_register('EDUCATOR_NOTES'); 
        session_register('SEMESTER_TEACHING');

        ?>
        <br>
            <form method="post" action="?option=com_content&view=article&id=53">
                <table>
                    <tr align="center" style='background-color: #B9EEAC;'>
                        <th>Τίτλος Μαθήματος
                        <th>Εξάμηνο
                        <th>Χορήγηση Εγκεκριμένων Σημειώσεων
                        <th>Εξάμηνα Διδασκαλίας
                    </tr>
                    <?php
                        foreach( $_POST['lessons'] as $lessonId ) {
                            $Q = "SELECT lessonTitle, semester FROM lesson WHERE id='".$lessonId."' ORDER BY semester,lessonTitle";
                             
                            $result = mysql_query($Q);
                            $row = mysql_fetch_array($result);
                    ?>
                            <tr onMouseOut="this.style.background='#FFFFFF'" onMouseOver="this.style.background ='#FFA346';">
                                <td><?php echo $row['lessonTitle'];?></td>
                                <td><?php echo $row['semester'];?></td>
                                <td align='center'><select name='userNotes[]'>
                                                    <option id='Όχι'>Όχι</option>
                                                    <option id='Ναί'>Ναί</option>
                                                    </select>
                                </td>
                                <td align='center'><select name='semesterTeaching[]'>
                                                    <?php
                                                    for($semester = 0; $semester <= 50; $semester++) {
                                                        echo "<option id='$semester'>$semester</option>";
                                                    }
                                                    ?>
                                                   </select>
                                </td>
                            </tr>          
                    <?php      
                        }
                    ?>
                    <tr>
                        <td colspan="5" align="right"><input type="submit" value="Επόμενο >>"></td>
                    <tr>
                </table>
            </form>
        
        <?php 
        }
        else {
            echo "<br><br><font color='red'>Δεν έχετε επιλέξει κάποιο μάθημα.</font>";
            echo " [ <a href='?option=com_content&view=article&id=47'> + Προσθήκη Μαθημάτων</a> ] ";                 
        }    
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>