title: User entries not reflecting in the database
body: <p>I have connected the php code below to my html file to acquire inputs from users. But when an entry is made it doesn't reflect in my database.The user gets redirected to a different page(contact.php) and the feedback he/she gets is page isn't working right now.
  <a href="https://i.stack.imgur.com/O4Oz6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O4Oz6.png" alt="feedback when users make entries" /></a></p>
  <pre><code> &lt;?php 
  
  $name = $_POST['Name']
  $phone = $_POST['Phone']
  $email = $_POST['Email']
  $message = $_POST['Message']
  
  $conn = new mysqli('localhost','root','','circlecu_resultorientedmarket');
  if($conn -&gt; connect_error){
      die('Connection Failed:'.$conn-&gt;connect_error );
  }else{
      $stmt = $conn-&gt;prepare(&quot;insert into registration(Name, Phone, Email, Message)
      values(?,?,?,?)&quot;);
      $stmt -&gt;bind_param(&quot;siss&quot;,$name,$phone,$email,$message);
      $stmt -&gt; execute();
      $stmt-&gt;close();
      $conn-&gt;close();
  }
  ?&gt;
  </code></pre>
  <p>Below is the html form.</p>
  <pre><code>                        &lt;form action=&quot;contact.php&quot; class=&quot;contact-form&quot;&gt;
                              &lt;div class=&quot;input-wrapper&quot;&gt;
                              &lt;label for=&quot;name&quot; class=&quot;input-label&quot;&gt;Name *&lt;/label&gt;
  
                              &lt;input type=&quot;text&quot; name=&quot;name&quot; id=&quot;name&quot; required placeholder=&quot;Type Name&quot; class=&quot;input-field&quot;&gt;
                              &lt;/div&gt;
  
                              &lt;div class=&quot;input-wrapper&quot;&gt;
                                  &lt;label for=&quot;phone&quot; class=&quot;input-label&quot;&gt;Phone&lt;/label&gt;
      
                                  &lt;input type=&quot;tel&quot; name=&quot;phone&quot; id=&quot;phone&quot;  placeholder=&quot;Type Phone Number&quot; class=&quot;input-field&quot;&gt;
                              &lt;/div&gt;
  
                              &lt;div class=&quot;input-wrapper&quot;&gt;
                                  &lt;label for=&quot;email&quot; class=&quot;input-label&quot;&gt;Email Address *&lt;/label&gt;
      
                                  &lt;input type=&quot;email&quot; name=&quot;email&quot; id=&quot;email&quot; required placeholder=&quot;Type Email Address&quot; class=&quot;input-field&quot;&gt;
                              &lt;/div&gt;
  
                              &lt;div class=&quot;input-wrapper&quot;&gt;
                                  &lt;label for=&quot;message&quot; class=&quot;input-label&quot;&gt;How can we help you? *&lt;/label&gt;
      
                                  &lt;textarea name=&quot;message&quot; id=&quot;message&quot; placeholder=&quot;Type Description&quot; required class=&quot;input-field&quot;&gt;&lt;/textarea&gt;
                              &lt;/div&gt;
  
                              &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Send message&lt;/button&gt;
                          &lt;/form&gt;
  </code></pre>
  <ol>
  <li>How can i make user entries reflect in my database?
  2.How can i make the page refresh after users click on the submit button?</li>
  </ol>