Untitled

<?php

/*
Init variables
*/

$servername = "104.168.99.210";
$username = "matejr";
$password = "matejremote";
$database = "sharedDB";
$tablename = "registry"; //This is the table in the db u wanna set it ot retard

if (isset($_POST['submit']))
{
/*
Create connection to db
*/
$con = mysqli_connect($servername,$username,$password,$database);


// Check connection if error tell the retarded user
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$val1 =  $_POST['a'];;
/*
$val2 =  $_POST['b'];;
$val3 =  $_POST['c'];;
$val4 =  $_POST['d'];;
*/
/*
 Creates the SQL statement
---------------------
Change a b c d to the name of the table thing you got like
ID , lastname or whatever the fuck u got
*/

#$sql = "INSERT INTO " . $tablename . " (a , b , c , d) VALUES ('" . $val1 . "' , '" . $val2 . "' , '" . $val3 . "' , '" . $val4 ."')";
#$sql = "UPDATE" . $tablename . "SET value='" . $val1 . "' WHERE regID=1";
$sql = "UPDATE registry SET value='" . $val1 . "' WHERE RegID=1";
#$sql = "UPDATE registry SET value="' . $val1 . '" WHERE RegID=1";
#$sql = "UPDATE " . $tablename ." SET value=" (a) " WHERE regID = '1'";
#$sql = "INSERT INTO " . $tablename . " (a , b , c , d) VALUES ('" . $val1 . "' , '" . $val2 . "' , '" . $val3 . "' , '" . $val4 ."')";
if($con->query($sql) === TRUE )
{
  //Get everything from our table we set before
  $sql2 = "SELECT value FROM registry WHERE regID=1";
#    $sql2 = "SELECT * FROM `registry";
$result = $con->query($sql2);

  if($result)
  {
    while($row = $result->fetch_assoc())
    {
#      $printstuff = "A is: " . $row["a"]. "<br>";
      $printstuff = "A is: " . $row["value"]. "<br>";
#       $printstuff = "A is: " . $row["a"]. " - B is: " . $row["b"] . " C is  " . $row["c"] . "D is " . $row["d"] . "<br>";
       #$printstuff = "Value on remote server is" '" . $sql2. "';
     echo $printstuff;
    }
    $result->free();
  }
  else
  {
     $printstuff = "0 results";
     echo $printstuff;
  }
}
else
{
  echo "Error: "  . $sql . "<br>" . $con->error;
}


//Close the database
$con->close();

}

// PHP Sucks
?>

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>title</title>
    <link rel="stylesheet" href="style.css">
    <script src="script.js"></script>
  </head>
  <body>
                <form action="" method="post">
                        A: <input type="text" name="a"><br>
                        <input type="submit" name="submit">
                </form>
<br>opening from debian7.maros.online
<br>database from server.maros.online
  </body>
</html>