php使用mysqli向数据库添加数据的方法

$mydb = new mysqli('localhost', 'username', 'password', 'databasename');
$sql = "INSERT INTO users (fname, lname, ments)
VALUES ('$_POST[fname]', '$_POST[lname]', '$_POST[ments]')";
if ($mydb->query($sql) == TRUE) {
echo "user entry saved suessfully.";
} else {
echo "INSERT attempt failed" ;
}
$mydb->close();