<?php
  $dbhost = 'mysql2.000webhost.com';
  $dbuser = 'a1059070_Alexi';
  $dbpass = 'jhkhjkhkjh';


  $con = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error Connection to MySQL');


  $dbname = 'a1059070_users';

  mysql_select_db($dbname);

  $error = array();
  if (isset($_POST['reguser']))
      $username = $_POST['reguser'];
  else
      $error[] = 'Username left blank';

  if (isset($_POST['regpass1']))
      $pass = $_POST['regpass1'];
  else
      $error[] = 'Password left blank';

  if (empty($error)) {
      $password = md5($pass);
      if (isset($_POST['regpass2'])) {
         if( md5($_POST['regpass2']) != $password)
            $error[] = 'Passwords do not match';
      } else
          $error[] = 'Confirmation pass left blank';
  }
  $queryuser = mysql_query("SELECT * FROM users WHERE USERNAME='$username' ");
  $checkuser = mysql_num_rows($queryuser);
  if ($checkuser != 0) {
      echo "Sorry, " . $username . " has already been taken.";
  } elseif (empty($error)) {
      $username = mysql_real_escape_string($username);
      $password = mysql_real_escape_string($password);

      $insert_user = mysql_query("INSERT INTO users (USERNAME, PASSWORD) VALUES ('$username', '$password')");

      if ($insert_user !== false) {
          $id = mysql_insert_id();
          //$query1 = "SELECT FROM users WHERE USERNAME=='$username');
          //$result1 = mysql_query($query1);


          mysql_query("INSERT INTO userwing (userid) VALUES ('$id')");

          echo "Registration Successfull";
      } else {
          echo "error in registration" . mysql_error();
      }
  } else {
      foreach ($error as $err)
          echo $err . '<br />' . PHP_EOL;
  }
  mysql_close($con);
?>