General Politics Celebrities Crime Programming Health Business Sports Jobs Music and Videos Comedy Religion How to Live Sports EducationThere are many ways you can do this and few examples are given below:
$sqlAdd = "INSERT INTO contacts (firstname, lastname, email)
VALUES ('Godwin', 'Asu', 'asu@example.com');";
$sqlAdd .= "INSERT INTO contacts (firstname, lastname, email)
VALUES ('Mary', 'Ene', 'mary@example.com');";
$sqlAdd .= "INSERT INTO contacts (firstname, lastname, email)
VALUES ('Emeka', 'Ogbonna', 'emeka@example.com')";
if (mysqli_multi_query($conn, $sql)) {
echo "Records added successfully";
} else {
echo "Error add records: " . $sql . "
" . mysqli_error($conn);
}
INSERT INTO contacts (firstname, lastname, email)
values('$firstname', '$lastname', '$email')
,('$firstname', '$lastname', '$email')
,('$firstname', '$lastname', '$email')Need more examples or clarifications, drop your comments below.
