$host = "localhost"; $dbname = "mydatabase"; $username = "myusername"; $password = "mypassword"; try { $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password); } catch (PDOException $e) { die("Error connecting to database: " . $e->getMessage()); }
$email = $_POST['email']; if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $errors[] = "Email address is not valid"; } if (empty($_POST['password'])) { $errors[] = "Please enter a password"; }
$name = $_POST['name']; $email = $_POST['email']; $password = password_hash($_POST['password'], PASSWORD_DEFAULT); $stmt = $pdo->prepare("INSERT INTO users (name, email, password) VALUES (:name, :email, :password)"); $stmt->bindParam(':name', $name); $stmt->bindParam(':email', $email); $stmt->bindParam(':password', $password); if ($stmt->execute()) { // Success! The user data has been saved to the database. }In this example, the PDO library is used for database connections and prepared statements. The filter_var() function is used for validating user input.