School System

<?php

/* Database connect */
function SQL()
{
  $username = "root";
  $password = "";

  // Connect function
  $conn = mysql_connect("localhost", $username, $password);
  mysql_select_db("school");

  // Check function of Database
  if (!$conn)
  {
    die("Connect error: " . mysqli_connect_error());
  }
}

/* Login Function */
function Login()
{
  session_start();

  if($_SESSION['user'] != 0)
	{
    header("Location: /");
  }

	// Variables
  $jmeno = mysql_real_escape_string($_POST['jmeno']);
  $heslo = md5(mysql_real_escape_string($_POST['heslo']));

  $data = mysql_query("SELECT * FROM users WHERE username = '".$jmeno."'");
  $data = mysql_fetch_array($data);

	// Check and settings of datas
	// $_SESSION['user'] = $data['user_id'];
	// redirect to the Dashboard

	  if(isset($_POST['login']))
	  {
		  if(!empty($jmeno))
		  {
			  if(!empty($heslo))
			  {
				  if($data['password']==$heslo)
				  {
					 $_SESSION['user'] = $data['user_id'];
					 ?>
					<meta http-equiv="refresh" content="1;url=database.php">
					 <?php
				  }
			  }
		  }
	  }
}


/* Logout function */
function LogOut()
{
  // Logout
  session_destroy();
}

/* Write all Students */
function GetUserList()
{
  // Take from DB
  $userData = mysql_query("SELECT * FROM users");

  while($row = mysql_fetch_array($userData))
  {
    echo $row['user_id'];
    echo $row['username'];
  }
}

/* CSS initialize */
function CSS_Initialize()
{
  print("<style>
  </style></head><body>");
}

/* HEAD OF HTML CODE */
function HTML_HEAD()
{
  print("<html><head><title> School System </title><meta charset='UTF-8'>");
}

/* BODY OD HTML CODE  LOGGED */
function HTML_BODY_LOGGED()
{
  print("<div class='Nadpis'> School System</div>
    <div class='menu'>
      <form action='' method='post'>
        <input type='submit' name='item_1' value='Marks'/>
        <input type='submit' name='item_2' value='Events'/>
        <input type='submit' name='item_3' value='Classes'/>
        <input type='submit' name='item_4' value='Lunch'/>
      </form>
    </div>
    <div class='Content'>");

    if($_POST['item1'])
    {
      Item1();
    }
    elseif($_POST['item2'])
    {
      Item2();
    }
    elseif($_POST['item3'])
    {
      Item3();
    }
    elseif($_POST['item4'])
    {
      Item4();
    }

  print("
    </div>
   </body></html>");
}

/* TAKE FROM DATABASE YOUR MARKS */
function Item1()
{
  // Take from DB
  $mark = mysql_query("SELECT * FROM marks WHERE id = user_id");

  while($row = mysql_fetch_array(($mark))
  {
    echo $row['subject'];
    echo $row['mark'];
    echo $row['detail'];
    echo $row['date'];
  }
}

/* TAKE FROM DATABASE EVENTS WHAT WILL FOR YOU */
function Item2()
{
  // Take from DB
  $event = mysql_query("SELECT * FROM events WHERE id = user_id");

  while($row = mysql_fetch_array($event))
  {
    echo $row['When'];
    echo $row['Where'];
    echo $row['Date'];
    echo $row['Teacher'];
  }
}

/* TAKE FROM DATABASE CLASSES WHAT IS FOR YOUR CLASS */
function Item3()
{
    /* Now I dont know how to do it ! */
}

/* FUNCTION FOR LUNCH TAKING AND SAVING */
function Item4()
{
  // Take from DB
  $lunch = mysql_query("SELECT * FROM lunch WHERE id = user_id");

  while($row = mysql_fetch_array($lunch))
  {
    echo $row['When'];
    echo $row['What'];
    echo $row['CLICK'];
    echo $row['Teacher'];
  }
}

/* BODY OF HTML CODE  UNLOGGED */
function HTML_BODY_UNLOGGED()
{
  print("
  <div class='Nadpis'> School System</div>
  <div class='Form'>
  <form action='' method='post'>
  				Username: <br>
  				<input type='text' name='jmeno'/><br />
  				Password:<br>
  				<input type='password' name='heslo'/><br /><br />
  				<input class='button_start' type='submit' name='login' value='Login'/>
  			</form>
  </div>
  </body></html>");
}


HTML_HEAD();
CSS_Initialize();

if($_SESSION['user'] == 0){
		HTML_BODY_UNLOGGED();
}
else
{
    HTML_BODY_LOGGED();
}

?>