title: Can't upload text value to mysql by php
body: <p>Every time I submit the form of my website for comment, It only creates a new ID.But all other value is empty, what should I do? Do I need create some attribute for the name, email and content?
  <a href="https://i.stack.imgur.com/1q1u9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1q1u9.png" alt="enter image description here"></a></p>
  
  <pre><code>&lt;?php
  error_reporting(E_ALL);ini_set('display_errors',1); 
  
  $servername = "localhost";
  $username = "seamaszhou";
  $password = "123456";
  $dbname = "guest";
  
  
  
  
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, 
  $password);
  // set the PDO error mode to exception
  $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  
  // prepare sql and bind parameters
  $stmt = $conn-&gt;prepare("INSERT INTO guest 
  (guestName,guestEmail,guestContent) 
  VALUES (:guestName, :guestEmail, :guestContent)");
  
  $stmt-&gt;bindParam(':guestName', $guestName);
  $stmt-&gt;bindParam(':guestEmail', $guestEmail);
  $stmt-&gt;bindParam(':guestContent', $guestContent);
  
   // insert a row
   $guestName = "$guestName";
  $guestContent = "$guestContent";
  $guestEmail = "$guestEmail";
  $stmt-&gt;execute();
  
  
  
  ?&gt;
  </code></pre>
  
  <p>HTML CODE :<a href="https://i.stack.imgur.com/bwucM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bwucM.png" alt="enter image description here"></a></p>