Untitled

<?php
    session_start();
    $user = $_POST["user"];
    $pass = $_POST["pass"];
    $sqlhost = "sql7.freemysqlhosting.net";
    $sqluser = "sql7117187";
    $sqlpw = "mxi6v8DM6i";
    $sqldb = "sql7117187";

   $conn = new mysqli('sql7.freemysqlhosting.net', 'sql7117187', 'mxi6v8DM6i', 'sql7117187');
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT 1 FROM dietusers WHERE Name='".mysqli_real_escape_string($connect, $user)."' AND Password='".mysqli_real_escape_string($connect, $pass)."' LIMIT 1";
;
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
        $login = 1;
    while($row = $result->fetch_assoc()) {


    }
} else {
    //echo "0 results";
}
$conn->close();


    if($login == 1)
    {

        session_regenerate_id(true);
        $_SESSION["login"] = 1;


    }
    header("Location: /default/home.php")

    /*$connect = mysqli_connect($sqlhost, $sqluser, $sqlpw);
    mysqli_set_charset($connect, "utf8");
    if (!mysqli_select_db($connect, $sqldb)) { die("Error connecting database."); }
    mysqli_query($connect, "INSERT INTO `dietusers` (Name, Password, DOB, EmailVer) VALUES (
    '".mysqli_real_escape_string($connect, $user)."',
    '".mysqli_real_escape_string($connect, $pass)."',
    '".mysqli_real_escape_string($connect, $dob)."',
    '".mysqli_real_escape_string($connect, $emailver)."',

    )");*/


?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title></title>
    </head>
    <body>

    </body>
</html>