Untitled

DATABASE

<?php
class Database
{
    private static $dbName = 'deb43619_koray' ;
    private static $dbHost = 'localhost' ;
    private static $dbUsername = 'deb43619_koray';
    private static $dbUserPassword = 'berkay5314';

    private static $cont  = null;

    public function __construct() {
        die('Init function is not allowed');
    }

    public static function connect()
    {
       // One connection through whole application
       if ( null == self::$cont )
       {
        try
        {
          self::$cont =  new PDO( "mysql:host=".self::$dbHost.";"."dbname=".self::$dbName, self::$dbUsername, self::$dbUserPassword);
        }
        catch(PDOException $e)
        {
          die($e->getMessage());
        }
       }
       return self::$cont;
    }

    public static function disconnect()
    {
        self::$cont = null;
    }
}
?>


DOCENTPAGINA(INDEX)
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
    <script src="css/bootstrap.min.js"></script>
    <script>
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>

<body>
    <div class="container">
            <div class="row">
                <h3>Leerlingen overzicht</h3>
            </div>
            <div class="row">
            <p>
              <a href="register.php" class="btn btn-success">Nieuwe leerling toevoegen</a>
				<a href="logout.php" class="btn btn-success">uitloggen</a>
				<form>
					<select name="users" onchange="showUser(this.value)">
					<option value="">Selecteer een groep:</option>
					<option value="1">Groep 1</option>
					<option value="2">Groep 2</option>
					<option value="3">Groep 3</option>
					<option value="4">Groep 4</option>
					<option value="5">Groep 5</option>
					<option value="6">Groep 6</option>
					<option value="7">Groep 7</option>
					<option value="8">Groep 8</option>
					<option value="">Alles</option>
					</select>
				</form>
                </p>
                <div id="txtHint">
                <table class="table table-striped table-bordered">
                <table class="table table-striped table-bordered">
                  <thead>
                    <tr>
                      <th>Id</th>
                      <th>Naam</th>
                      <th>Wachtwoord</th>
                      <th>Groep</th>
                      <th>Action</th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php
                   include 'database.php';
                   $pdo = Database::connect();
                   $sql = 'SELECT * FROM leerling';
                   foreach ($pdo->query($sql) as $row) {
                            echo '<tr>';
                            echo '<td>'. $row['id'] . '</td>';
                            echo '<td>'. $row['username'] . '</td>';
                            echo '<td>'. $row['password'] . '</td>';
                            echo '<td>'. $row['groep'] . '</td>';
                            echo '<td width=200>';
                                echo '<a class="btn btn-success" href="update.php?id='.$row['id'].'">Update</a>';
                                echo ' ';
                                echo '<a class="btn btn-danger" href="delete.php?id='.$row['id'].'">Delete</a>';
                                echo '</td>';
                            echo '</tr>';
                   }
                   Database::disconnect();
                  ?>
                  </tbody>
            </table>
        </div>
    </div> <!-- /container -->
  </body>
</html>
    <?php
    /* some code here */

    show_source(__FILE__);
?>

TELT WAARDE OP
INSERT INTO voorraad(Locatiecode,Productcode,Aantal) VALUES (1,1,10)
ON DUPLICATE KEY UPDATE Aantal= Aantal + $aantal;

LOGIN
<?php
error_reporting(0);
   include("config.php");
   session_start();

   if($_SERVER["REQUEST_METHOD"] == "POST") {
      // username and password sent from form

      $myusername = mysqli_real_escape_string($db,$_POST['username']);
      $mypassword = mysqli_real_escape_string($db,$_POST['password']);

      $sql = "SELECT id FROM docent WHERE username = '$myusername' and password = '$mypassword'";
      $result = mysqli_query($db,$sql);
      $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
      $active = $row['active'];

      $count = mysqli_num_rows($result);

      // If result matched $myusername and $mypassword, table row must be 1 row

      if($count == 1) {
        // session_register("myusername");
         $_SESSION['login_user'] = $myusername;

         header("location: docentpagina.php");
      }else {
         $error = "Your Login Name or Password is invalid";
      }
   }
?>
<?php
error_reporting(0);
   if($_SERVER["REQUEST_METHOD"] == "POST") {
      // username and password sent from form

      $myusername = mysqli_real_escape_string($db,$_POST['username']);
      $mypassword = mysqli_real_escape_string($db,$_POST['password']);

      $sql = "SELECT id FROM leerling WHERE username = '$myusername' and password = '$mypassword'";
      $result = mysqli_query($db,$sql);
      $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
      $active = $row['active'];

      $count = mysqli_num_rows($result);

      // If result matched $myusername and $mypassword, table row must be 1 row

      if($count == 1) {
        // session_register("myusername");
         $_SESSION['login_user'] = $myusername;

         header("location: leerlingpagina.php");
      }else {
         $error = "Your Login Name or Password is invalid";
      }
   }
?>
<html>

   <head>
      <title>Login Page</title>

      <style type = "text/css">
         body {
   font:400 12px "Arial", sans-serif;
   color:#000;
   background:#000;
}
.header {
   margin-top:20px;
}
.wrapper {
   max-width:500px;
   width:95%;
   margin:0 auto;
   position:relative;
}
#contact-form input[type="text"],
#contact-form input[type="password"],
#contact-form textarea,
#contact-form button[type="submit"] {
   font:100 16px/18px "Arial";
}
   #contact-form button[name="submit1"] {
   font:100 16px/18px "Arial";
}

#contact-form {
   text-shadow:0 1px 0 #FFF;
   border-radius:4px;
   -webkit-border-radius:4px;
   -moz-border-radius:4px;
   background:#F9F9F9;
   padding:25px;
}

#contact-form label span {
   cursor:pointer;
   color:#006064;
   display:block;
   margin:5px 0;
   font-weight:900;
   font:100 16px/18px "monotype corsiva";
}
#contact-form input[type="text"],
#contact-form input[type="password"],
#contact-form textarea {
   width:100%;
   box-shadow:inset 0 1px 2px #DDD, 0 1px 0 #FFF;
   -webkit-box-shadow:inset 0 1px 2px #DDD, 0 1px 0 #FFF;
   -moz-box-shadow:inset 0 1px 2px #DDD, 0 1px 0 #FFF;
   border:1px solid #CCC;
   background:#FFF;
   margin:0 0 5px;
   padding:10px;
   border-radius:5px;
}
#contact-form input[type="text"]:hover,
#contact-form input[type="password"]:hover,
}
#contact-form textarea {
   height:100px;
   max-width:100%;
}
#contact-form button[type="submit"] {
   cursor:pointer;
   width:100%;
   border:none;
   background:#000;
   color:#FFF;
   margin:0 0 5px;
   padding:10px;
   border-radius:5px;
}
#contact-form button[name="submit1"] {
   cursor:pointer;
   width:100%;
   border:none;
   background:#991D57;
   color:#FFF;
   margin:0 0 5px;
   padding:10px;
   border-radius:5px;
}
   </style>
   </head>

   <body>


               <div class="wrapper">
                  <div id="main" style="padding:20px 0 0 0;">
               <form id="contact-form" action = "" method = "post">
                  <label>Username  :</label><input placeholder="Please enter your username" type = "text" name = "username" pattern=".{2,}" title="Minimal 2 symboles" required/><br /><br />
                  <label>Password  :</label><input placeholder="Please enter your password" type = "password" name = "password" pattern=".{2,}" title="Minimal 2 symboles" name="psw" required/><br/><br />
            <div>
            <button type = "submit" name="submit" value = " Submit ">Login</button>
            <div style = "font-size:11px; color:#cc0000; margin-top:10px"></div>
            </div>
               </form>


            </div>

         </div>

      </div>

   </body>
</html>

LOGOUT
<?php
   session_start();

   if(session_destroy()) {
      header("Location: login.php");
   }
?>

CREATE

<?php

    require 'database.php';

    if ( !empty($_POST)) {
        // keep track validation errors
        $usernameError = null;
        $passwordError = null;
        $klasError = null;

        // keep track post values
        $username = $_POST['username'];
        $password = $_POST['password'];
        $klas = $_POST['klas'];

        // validate input
        $valid = true;
        if (empty($username)) {
            $usernameError = 'Please enter Name';
            $valid = false;
        }

        if (empty($password)) {
            $passwordError = 'Please enter password';
            $valid = false;
        }

        if (empty($klas)) {
            $klasError = 'Please enter klass';
            $valid = false;
        }

        // insert data
        if ($valid) {
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO leerling (username,password,klas) values(?, ?, ?)";
            $q = $pdo->prepare($sql);
            $q->execute(array($username,$password,$klas));
            Database::disconnect();
            header("Location: welcome1.php");
        }
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
    <script src="css/bootstrap.min.js"></script>
</head>

<body>
    <div class="container">

                <div class="span10 offset1">
                    <div class="row">
                        <h3>Create a student</h3>
                    </div>

                    <form class="form-horizontal" action="create.php" method="post">
                      <div class="control-group <?php echo !empty($nameError)?'error':'';?>">
                        <label class="control-label">Name</label>
                        <div class="controls">
                            <input name="username" type="text"  placeholder="Name" value="<?php echo !empty($username)?$username:'';?>">
                            <?php if (!empty($usernameError)): ?>
                                <span class="help-inline"><?php echo $usernameError;?></span>
                            <?php endif; ?>
                        </div>
                      </div>
                      <div class="control-group <?php echo !empty($passwordError)?'error':'';?>">
                        <label class="control-label">Password</label>
                        <div class="controls">
                            <input name="password" type="text" placeholder="Password" value="<?php echo !empty($password)?$password:'';?>">
                            <?php if (!empty($passwordError)): ?>
                                <span class="help-inline"><?php echo $passwordError;?></span>
                            <?php endif;?>
                        </div>
                      </div>
                      <div class="control-group <?php echo !empty($klasError)?'error':'';?>">
                        <label class="control-label">Klass</label>
                        <div class="controls">
                            <input name="klas" type="text"  placeholder="klas" value="<?php echo !empty($klas)?$klas:'';?>">
                            <?php if (!empty($klasError)): ?>
                                <span class="help-inline"><?php echo $klasError;?></span>
                            <?php endif;?>
                        </div>
                      </div>
                      <div class="form-actions">
                          <button type="submit" class="btn btn-success">Create</button>
                          <a class="btn" href="welcome1.php">Back</a>
                        </div>
                    </form>
                </div>

    </div> <!-- /container -->
  </body>
</html>
<?php
    /* some code here */

    show_source(__FILE__);
?>