You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.'Admin')' : <p>When I Try to add value of role in DB it shows me this error ,
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.'Admin')' at line 1,</p>

<pre><code>&lt;?

 $pin=$_POST['pin'];
 $password=$_POST['password'];
$name=$_POST['name'];
$email=$_POST['email'];
$role=$_POST['role'];
echo $pin;
echo $role;


If($pin=="1233")
{
mysqli_query($conn, "INSERT INTO admin(pin,name,email,password,role) VALUES('$pin','$name','$email','$password'.'$role')") or die(mysqli_error($conn));



header('location:index1.php');
}

?&gt;
      &lt;form class="form-horizontal" method="post" action="process.php"&gt;


enter code here
          &lt;label for="name" class="cols-sm-2 control-label"&gt;Pin Number :&lt;/label&gt;
          &lt;input type="text" name="pin" placeholder="Enter Pin"&gt;
          &lt;label for="name" class="cols-sm-2 control-label"&gt;Your Name :&lt;/label&gt;

              &lt;input type="text" name="name"  placeholder="Enter your Name"/&gt;
         &lt;label for="email" class="cols-sm-2 control-label"&gt;Your Email :&lt;/label&gt;

              &lt;input type="text"  name="email"   placeholder="Enter your Email"/&gt;   &lt;input type="text"  name="phone"   placeholder="Enter your Phone Number"/&gt;

          &lt;label for="password" class="cols-sm-2 control-label"&gt;Password :&lt;/label&gt;


              &lt;input type="password" name="password"   placeholder="Enter your Password"/&gt;

             &lt;label &gt;Role :&lt;/label&gt;
  &lt;select name="role" &gt;
    &lt;option value="Admin"&gt;Teacher&lt;/option&gt;
    &lt;option value="Teacher"&gt;Admin&lt;/option&gt;
  &lt;/select&gt; 
          &lt;input type="submit" class="btn-success" value="Sign up"  style="border-radius: 07px;padding: 3px;background: green"  name="register"&gt;
        &lt;/form&gt;
</code></pre>
