register.php

<?php
error_reporting(E_ALL);
    //DB Connection;
	$DB_NAME = "my_data";
	$DB_USERNAME = "root";
	$DB_PASSWORD = "";
	$DB_IP = "localhost";

	$mysqli = mysqli_connect($DB_IP, $DB_USERNAME, $DB_PASSWORD, $DB_NAME);

	if(isset($_POST['submit']))
	{

        $first_name = filter_var($_POST['first_name'], FILTER_SANITIZE_STRING);
        $last_name = filter_var($_POST['last_name'], FILTER_SANITIZE_STRING);
        $email = filter_var($_POST['email'], FILTER_SANITIZE_STRING);
        $phonenumber = filter_var($_POST['number'], FILTER_SANITIZE_STRING);
        $companyname = filter_var($_POST['company_name'], FILTER_SANITIZE_STRING);
        $address = filter_var($_POST['address'], FILTER_SANITIZE_STRING);
        $city = filter_var($_POST['city'], FILTER_SANITIZE_STRING);
        $state = filter_var($_POST['state'], FILTER_SANITIZE_STRING);
        $country = filter_var($_POST['country'], FILTER_SANITIZE_STRING);
        $pincode = filter_var($_POST['pincode'], FILTER_SANITIZE_STRING);
		//password encrypted..
		$password2 = filter_var($_POST ['pass'], FILTER_SANITIZE_STRING);
		$password = password_hash($password2, PASSWORD_BCRYPT);

    if( !empty($first_name) && !empty($last_name) && !empty($email) && !empty($phonenumber) && !empty($companyname) && !empty($address) && !empty($city) && !empty($state) && !empty($country) && !empty($pincode) && !empty($pass))
    {
        $add_query = "INSERT INTO tb_cart(first_name, last_name, email, number, company_name, address, city, state, country, pincode, password) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

        $thisexecutequery = $mysqli->prepare($add_query);
        $thisexecutequery->bind_param("sssssssssns", $first_name, $last_name, $email, $phonenumber, $companyname, $address, $city, $state, $country, $pincode, $pass);

        $thisexecutequery->execute();
	}

    }
	?>


<!doctype html>
<html lang ="en">
	<head>

		<meta charset="UTF-8">
		<title>Register Your Self | Snow Web Host</title>
		<meta name="description" content="You can buy cheap but high quality Website Hosting from us.">
		<meta name="keywords" content="best website hosting, best webhosting, hosting website, india website hosting, top webhosting">
		<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
		<link rel="stylesheet" href="style.css">
		<meta charset="utf-8">


	</head>
	<body>

	<body id="bill_form">

		<div class="container">
			<div class="col-sm-10">
			<br>
				<center><h2>Fill This Form</h2></center>
				<br>
			</div>
			<div class="col-sm-9">
			<form action="register.php" method="post" class="well">

				<div class="form-group prepend-icon">

				 <label>First Name</label>
				 <input type="text" class="form-control" name="first_name" placeholder="Type Your First Name" required>

           		</div>

                <div class="form-group">
                <label>Last Name</label>
				 <input type="text" class="form-control " name="last_name" placeholder="Type Your Last Name" required>
				</div>


				<div class="form-group">
				 <label>Email</label>
				 <input type="text" class="form-control" name="email" placeholder="Type Your Email" required>
				</div>

                <div class="form-group">
				 <label>Phone Number</label>
				 <input type="number" class="form-control" name="number" placeholder="Type Your Phone Number" required>
				</div>

                <div class="form-group">
				 <label>Company Name</label>
				 <input type="text" class="form-control" name="company_name" placeholder="Type Your Compamy Name" required>
				</div>

                <div class="form-group">
				 <label>Address</label>
				 <input type="text" class="form-control" name="address" placeholder="Type Your Address" required>
				</div>

                <div class="form-group">
				 <label>City</label>
				 <input type="text" class="form-control" name="city" placeholder="Type Your City" required>
				</div>

                <div class="form-group">
				 <label>State</label>
				 <input type="text" class="form-control" name="state" placeholder="Type Your State" required>
				</div>

                <div class="form-group">
				 <label>Country</label>
				 <input type="text" class="form-control" name="country" placeholder="Type Your Country" required>
				</div>

                <div class="form-group">
				 <label>Pin Code</label>
				 <input type="number" class="form-control" name="pincode" placeholder="Type Your PinCode" required>
				</div>

                <div class="form-group">
				 <label>Type Password For Your Account</label>
				 <input type="password" class="form-control" name="pass" placeholder="Type Password For Your Account" required>

				</div>

				<div class="form-group">
					<br>
					<input type="submit" name="submit" class= "btn btn-primary" value="Register">

				</div>
                </form>
                </div>
            </div>
	</body>
</html>