Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- if (!isset($_SESSION['session_username'])){
- header("Location: index.php");}
- ?>
- <?php
- $DB_SERVER="localhost";
- $DB_USER="root";
- $DB_PASS="new_password";
- $DB_NAME="parlistdb";
- $link=mysqli_connect($DB_SERVER,$DB_USER,$DB_PASS,$DB_NAME);
- mysqli_query($link, "SET NAMES 'UTF-8'");
- mysqli_query($link, "SET CHARACTER SET 'utf8'");
- mysqli_query($link, "SET SESSION collation_connection = 'utf8_general_ci'");
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>
- Расписание
- </title>
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <!-- Latest compiled and minified CSS -->
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
- <!-- Optional theme -->
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
- </head>
- <body>
- <nav class="navbar navbar-default" role="navigation">
- <div class="container-fluid">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
- <span class="sr-only">Навигация</span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand info" href="#">Взыскач</a>
- </div>
- <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
- <ul class="nav navbar-nav">
- <li class="active">
- <a href="#">На день</a>
- </li>
- <li>
- <a href="#">На неделю</a>
- </li>
- <li>
- <a href="#">Форум</a>
- </li>
- <li class="divider">
- </li>
- <li class="dropdown">
- <a href="#" class="dropdown-toggle" data-toggle="dropdown"><?php echo $_SESSION['session_username']; ?><b class="caret">
- </b></a>
- <ul class="dropdown-menu">
- <li>
- <a href="#">Сменить пароль</a>
- </li>
- <li class="divider">
- </li>
- <li>
- <a href="logout.php">Выход</a>
- </li>
- </ul>
- </li>
- </ul>
- </div>
- </div>
- </nav>
- <h2>
- Расписание на неделю
- </h2>
- for ($i=1; $i<=7; $i++)
- {
- switch ($i)
- {
- case 1:
- $day="Понедельник";
- break;
- case 2:
- $day="Вторник";
- break;
- case 3:
- $day="Среда";
- break;
- case 4:
- $day="Четверг";
- break;
- case 5:
- $day="Пятница";
- break;
- case 6:
- $day="Суббота";
- break;
- case 7:
- $day="Воскресение";
- break;
- }
- echo "
- <blockquote>
- $day
- </blockquote>
- ";
- if ($i==7)
- {
- echo "
- <h1>
- Отдыхай, брат
- </h1>
- ";
- break;
- }
- $query="SELECT * FROM paratbl LEFT OUTER JOIN rate_subject ON paratbl.subject_id=rate_subject.id WHERE day_of_week=".$i;
- $answer=mysqli_query($link,$query);
- while ($row=mysqli_fetch_assoc($answer))
- {
- if ($row[type]=="Л")
- {
- ?>
- <tr>
- <td align="center" class="success">
- <?php echo $row[subject_name]; ?></td>
- <td align="center" class="success">
- <?php echo $row[type]; ?></td>
- <td align="center" class="success">
- <?php echo $row[aud]; ?></td>
- </tr>
- <?php
- }
- ?>
- <?php
- else
- {
- switch ($row[rate])
- {
- case 1 : $color="success";
- break;
- case 2 : $color="info";
- break;
- case 3: $color="warning";
- break;
- case 4: $color="danger";
- }?>
- <tr>
- <td align="center" class=
- <?php echo $color ?>>
- <?php echo $row[subject_name]; ?></td>
- <td align="center" class=
- <?php echo $color ?>>
- <?php echo $row[type]; ?></td>
- <td align="center" class=
- <?php echo $color ?>>
- <?php echo $row[aud]; ?></td>
- </tr>
- <?php }
- }
- }
- ?>
- <!-- jQuery -->
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
- <!-- Latest compiled and minified JavaScript -->
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement