Inserting multiple records into a MySQL table using PHP can be an efficient way to store data. Instead of inserting records one by one, you can insert several records with a single SQL query. Here's an outline of the process:
Here's an outline of the process:
1. Connection Establishment:
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
2. Prepare Data:
$records = array(
array('John', 'john@email.com'),
array('Jane', 'jane@email.com'),
array('Doe', 'doe@email.com')
);
3. Build the SQL Query:
$values = "";
foreach ($records as $record) {
$name = $conn->real_escape_string($record[0]);
$email = $conn->real_escape_string($record[1]);
$values .= "('$name', '$email'),";
}
// Remove last comma
$values = rtrim($values, ',');
$sql = "INSERT INTO users (name, email) VALUES $values";
4. Execute the Query:
if ($conn->query($sql) === TRUE) {
echo "Records inserted successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
5. Close the Connection:
$conn->close();
Note:
UPCET Exam
Click Here
SAAT Exam
Click Here
MHT CET Exam
Click Here
IPU CET Exam
Click Here
KCET Exam
Click Here
COMEDK UG Exam
Click Here
VITEEE Exam
Click Here
BITSAT
Click Here
DSAT: Dayanand Sagar Admission Test
Click Here
Career In Animation in india
Click Here
Merchant Navy Courses in india
Click Here
Interior Design Career in india
Click Here
UGC NET Exam
Click Here
B. Ed Exam
Click Here
AFCAT - Air Force Common Admission Test
Click Here
GATE Exam
Click Here
Joint Entrance Examination (JEE)
Click Here
Common Admission Test (CAT)
Click Here
CDS - Combined Defence Services Exam
Click Here