<?php
    $connect = @mysql_connect('localhost','root','') or die('ERROR Conection!');
    @mysql_select_db('pepsoman',$connect) or die ('DataBase ERROR');
    $success = "";
    if(isset($_POST['reg'])){
        $name = $_POST['name'];
        $surname = $_POST['surname'];
        $username = $_POST['username'];
        $password = $_POST['password'];
        $con_password = $_POST['con_password'];
        $age = $_POST['age'];
        $gender = $_POST['gender'];
        $insert = mysql_query("insert into users (name,surname,username,password,age,gender) values('$name','$surname','$username','$password','$age','$gender')");
        if($con_password != $password){
            $success = '
                <div class="panel panel-danger">
                  <div class="panel-heading">ERROR ConfirmPassword</div>
                </div>
            ';
        }
        else{
            $success = '
                <div class="panel panel-success ">
                  <div class="panel-heading">Registration</div>
                </div>
            ';
        }

    }

?>

`$insert = mysql_query("insert into users (name,surname,username,password,age,gender) values('$name','$surname','$username','$password','$age','$gender')");`

$insert = mysql_query("insert into users (name,surname,username,password,age,gender) values('".$name."','".$surname."' и т.д.