Untitled

<?php
 session_start();

 #############################
 # Moneta                    #
 # Sukure Aivaras Selevicius #
 # 2017/04/06                #
 #############################

 /*
 CREATE TABLE `zaidejai` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `monetos` varchar(50) NOT NULL,
  `kreditai` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
 )
 */

  ##############
  # Nustatymai #
  ##############

  $nMonetos = 100; # Naujokui duodamos monetos
  $nKreditai = 5; # Naujokui duodami kreditai

  $wName = "Moneta";
  $wVersion = "1.0.0";

  $servername = "localhost";
  $username = "root";
  $password = "";
  $db = "moneta";

  $conn = mysqli_connect($servername, $username, $password,$db);

  if (!$conn) {
   die("Connection failed: " . mysqli_connect_error());
  }

  function PhpLogo() {
   echo '<img src="http://php.net//images/logos/php-power-micro2.png" alt="Php Logo">';
  }

  #############
  # Puslapiai #
  #############
?> <html><head><title><?php echo $wName; ?></title></head> <?php

  echo '<h2>'; echo $wName." ".$wVersion; echo '</h2>';
  echo '<hr>';

  if(isset($_POST['aregister'])) {
    $register_username = $_POST['rusername'];
    $register_email = $_POST['remail'];
    $register_password = $_POST['rpassword'];

    $register_username = mysqli_real_escape_string($conn, $register_username);
   $register_email = mysqli_real_escape_string($conn, $register_email);
   $register_password = mysqli_real_escape_string($conn, $register_password);
   $register_password = md5($register_password);

   $sql = "SELECT email FROM zaidejai WHERE email='$register_email'";
   $result = mysqli_query($conn,$sql);
   $row = mysqli_fetch_array($result,MYSQLI_ASSOC);

   $sql1 = "SELECT username FROM zaidejai WHERE username='$register_username'";
   $result1 = mysqli_query($conn,$sql1);
   $row1 = mysqli_fetch_array($result1,MYSQLI_ASSOC);

   if(strlen($register_username) <= 5) {
    echo 'atsiprasome bet slapyvardis turi buti bent 5 raidziu ilgumo!';
   } else {
   if(!filter_var($register_email, FILTER_VALIDATE_EMAIL)) {
    echo 'Jusu pateiktas el pastas yra blogai ivestas!';
   } else {
   if(mysqli_num_rows($result) == 1) {
    echo 'Atsiprasome bet sis emailas jau egzistuoja!';
   } else {
    if(mysqli_num_rows($result1) == 1) {
        echo 'Atsiprasome bet sis slapyvardis jau egzistuoja!';
    } else {
        $query = mysqli_query($conn, "INSERT INTO zaidejai (username,email,password,monetos,kreditai) VALUES ('$register_username', '$register_email', '$register_password','$nMonetos','$nKreditai')");

        if($query) {
         echo $register_username." Sekmingai uzregistruotas!";
        }
    }
   }
   }
   }
  }

  if(isset($_GET['register'])) { ?>
   <form action="" method="POST">
    <input type="text" name="rusername" placeholder="Slapyvardis"><br>
    <input type="text" name="remail" placeholder="El.Pastas"><br>
    <input type="password" name="rpassword" placeholder="Slaptazodis"><br>
    <input type="submit" name="aregister" value="Registruotis">
   </form>
  <?php } else {

?>
Sveikas zaidejau, prisijunk arba <a href="index.php?register"><u>prisiregistruok</u></a><br><br>
<form action="" method="POST">
 <input type="text" name="lusername" placeholder="Slapyvardis">
 <input type="password" name="lpassword" placeholder="Slaptazodis">
 <input type="submit" name="login" value="Prisijungti">
</form>
<?php } ?>
</html>