How to Build Secure User Registration and Data Storage with PHP

User Registration

The registerUser function accepts three parameters— $username, $password, and $email. It first checks that none are empty, returning false if validation fails. The password is then encrypted using password_hash with PASSWORD_DEFAULT. A MySQL connection is created via mysqli_connect('localhost','username','password','database'), and an INSERT statement adds the new user to the users table. The function returns true on successful insertion, otherwise false.

function registerUser($username, $password, $email) {
    if (empty($username) || empty($password) || empty($email)) {
        return false;
    }
    $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
    $conn = mysqli_connect('localhost', 'username', 'password', 'database');
    $sql = "INSERT INTO users (username, password, email) VALUES ('$username', '$hashedPassword', '$email')";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        return true;
    } else {
        return false;
    }
}

Data Storage

The storeData function takes a single argument $data. It opens a MySQL connection, builds an INSERT query for the data table, executes it, and returns true if the operation succeeds, otherwise false.

function storeData($data) {
    $conn = mysqli_connect('localhost', 'username', 'password', 'database');
    $sql = "INSERT INTO data (data) VALUES ('$data')";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        return true;
    } else {
        return false;
    }
}

Conclusion

These examples demonstrate that PHP’s built‑in functions make implementing user registration and generic data storage straightforward. In production code, developers should further address security (e.g., prepared statements to prevent SQL injection) and performance concerns, but mastering these basics provides a solid foundation for backend development.