why data cannot come out at the sql php?

[Hayic]

<?php

    $name = $email = $password = $repeatpass = '';

    $name = $_POST['name'];
    $email = $_POST['email'];
    $password = $_POST['password'];
    $repeatpass = $_POST['repeatpass'];

    $con = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

    $sql = "INSERT INTO user-regis (name, email, password, repeatpass) VALUES ('$name', '$email', '$password', '$repeatpass')";
    $result = $con->query($sql);
    if (!$result) {
        header("Location: login.php");
    } else {
        echo "Error :" . $sql;
    }
    ?>

[rproffitt]

Didn't anyone tell you to never store passwords in the clear like that?

More at https://www.google.com/search?&q=never+store+passwords+in+a+database

Also, with so many login, password examples on the web, why did you decide to create yet another one?

[Dani]

Can you please explain what you're trying to do that isn't working? You're saying data is not coming out? Coming out of what? You are trying to insert a row into the table, correct? Are you sure that the connection is able to successfully be established?

Also, always escape your values before passing them into a MySQL query with real_escape_string().