4 cách thêm dữ liệu vào cơ sở dữ liệu bằng PDO

require_once 'connect.php';

$username = 'Nguyễn Văn Nghiệp';
$email = 'nguyenvannghiepvn@gmail.com';
$age = 25;

/* Cách 1*/
$sql = "INSERT INTO users(username,email,age,create_at) VALUES ('$username','$email',$age,NOW())";
$statement = $conn->prepare($sql);
$status = $statement->execute();

/*Cách 2*/
$sql = "INSERT INTO users(username,email,age,create_at) VALUES (:username,:email,:age,NOW())";
$statement->bindParam(':username',$username);
$statement->bindParam(':email',$email);
$statement->bindParam(':age',$age);

$statement = $conn->prepare($sql);
$status = $statement->execute();

/*Cách 3*/
$sql = "INSERT INTO users(username,email,age,create_at) VALUES (:username,:email,:age,NOW())";
$statement = $conn->prepare($sql);
$data = [
	'username' => $username,
	'email' => $email,
	'age' => $age
];

$status = $statement->execute($data);

/*Cách 4*/
$sql = "INSERT INTO users(username,email,age,create_at) VALUES (?,?,?,NOW())";
$statement = $conn->prepare($sql);
$data = [
	$username,
	$email,
	$age
];
$status = $statement->execute($data);

// Check kết quả
if($status){
	echo "Them du lieu thanh cong";
}else{
	echo "Them du lieu that bai"; 
}