<?php
  $con=mysqli_connect('localhost','root','','register');

  if (isset($_POST['submit']))
    {
 $shop=$_POST['shopname'];
 $name=$_POST['name'];
 $user=$_POST['username'];
 $email=$_POST['email'];
$password=$_POST['password'];
$repassword=$_POST['repassword'];
$phone=$_POST['phone'];
$sql="INSERT INTO registration           (shop_name,name,username,email,password,repassword,phone) VALUES  ('$shop','$name''$user','$email','$password','$repassword','$phone')";
 if(mysqli_query($con,$sql))
   {
 echo "Signup Sucessfull";
   }
     else
     {
      echo mysqli_error();
         }
        }
           ?>