$con = mysqli_connect("localhost","my_user","my_password","my_db"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; $sql = "INSERT INTO users (name, email, password) VALUES ('$name', '$email', '$password')"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } echo "User added successfully"; mysqli_close($con);
$host = "localhost"; $dbname = "my_db"; $username = "my_user"; $password = "my_password"; try { $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['password']; $stmt = $pdo->prepare("INSERT INTO users (name, email, password) VALUES (:name, :email, :password)"); $stmt->bindValue(':name', $name); $stmt->bindValue(':email', $email); $stmt->bindValue(':password', $password); $stmt->execute(); echo "User added successfully"; } catch(PDOException $e) { echo "Error: " . $e->getMessage(); }The package library used in these examples is the database driver library, either mysqli or PDO, which allows PHP to interact with MySQL database.