title: MySQL replaces my PHP input data
body: <p>So, I've been trying to create a Signup/Login process using PHP and MySQL. I created a Signup form, and a handling page. Then I tred it out, set the email as <code>a@a.com</code> and password as <code>MyPassword</code>. </p>
  
  <p>I then checked the database and got surprised. The email was correctly inputted, alright, but the password wasn't! It was one of the passwords that I used to test before, and it is a pretty personal one.</p>
  
  <p>Every time I tried it again, the same thing happened. The password was always changed to my personal one whenever I signed up. </p>
  
  <p>The problem is that, in my code, I don't have that personal password, anywhere. I only used it to test my signup flow once, and now it's stuck to my database!</p>
  
  <p>Here, I registered using test credentials. The password is <code>asd</code> and it's obviously 3 letters long.
  <a href="https://i.stack.imgur.com/8OL8D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8OL8D.png" alt="enter image description here"></a></p>
  
  <p>But when I check the database, I see the following. Even though I edited the password so you can't see it, it's still obvious it's more than 3 letters long.
  <a href="https://i.stack.imgur.com/IWkcK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IWkcK.png" alt="enter image description here"></a></p>
  
  <p>Is this some kind of MySQL over-writing thing, that I just don't know about yet?</p>
  
  <p>Here is the full code of the SignUp Page (Might be a little long, bear with me):</p>
  
  <pre><code>&lt;?php
  session_start();
  $firstName = $_POST['firstName'];
  $lastName = $_POST['lastName'];
  $email = $_POST['signUpemail'];
  $password = $_POST['signUppassword'];
  include("mysql_base.php");
  echo "Preparing MYSQL Statement...&lt;br&gt;";
  echo "&lt;script&gt;";
  echo "firstPart()";
  echo "function firstPart() {";
  echo "document.write('Starting to process MYSQL Statement...')";
  echo "window.setTimeout(secondPart(),2000)";
  echo "}";
  echo "function secondPart() {";
  echo "document.write('Starting to stop processing MSYQL Statement...')";
  echo "}";
  echo "&lt;/script&gt;";
  echo "Started to proccess...&lt;br&gt;";
  $sql = "INSERT INTO pages_accounts (email, pass, firstname, lastname, confirm) VALUES ('".$email."','".$password."','".$firstName."','".$lastName."','0')";
  if ($conn-&gt;query($sql) === true){
    echo "&lt;b&gt;SIGNUP SUCCESS&lt;/b&gt;&lt;br&gt;";
    echo "SUCH HAPPINESS. WOW. MMM.&lt;br&gt;&lt;br&gt;";
    echo "--Check your mail for a confirmation email. Check SPAM too!--";
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
    $headers .= 'From: FoxInFlame Pages&lt;pages@foxinflame.tk&gt;' . "\r\n";
    $message = "
    &lt;html&gt;
    &lt;body&gt;
    &lt;center&gt;
    &lt;div style='background-color:orange'&gt;&lt;h1&gt;Confirm your Account&lt;/h1&gt;&lt;br&gt;&lt;h3&gt;At FoxInFlame Pages&lt;/h3&gt;&lt;/div&gt;
    You seem to have registered for an account at FoxInFlame Pages. Now please click on the following link to complete your registration, and start creating amazing websites!&lt;br&gt;&lt;a href='http://www.foxinflame.tk/pages/confirm.php?id=".$conn-&gt;insert_id."'&gt;Click Here&lt;/a&gt;
    &lt;/center&gt;
    &lt;/body&gt;
    &lt;/html&gt;
    ";
    mail($email, "[CONFIRM] Account on FoxInFlame Pages", $message);
  } else {
    echo "MUCH SADNESS. SUCH DEPRESSION. FAIL ERROR. NO RETURN.";
    echo "Error: ".$sql."&lt;br&gt;".$conn-&gt;error;
  };
  ?&gt;
  </code></pre>