PHP Insert Multiple Data In MySQL
Submitted by alpha_luna on Friday, May 13, 2016 - 15:35.
If you are looking for a tutorial on How To Insert Multiple Data In MySQL then you are at the right place. In my previous tutorial, we already have a PHP Inserting Data To MySQL. We are going to use this source code and add some codes to have PHP Insert Multiple Data In MySQL.
This is our table that we are going to insert multiple data.
For MySQLi (Procedural) Save it as "mysqli_procedural_connection.php".
For PDO (PHP Data Objects) Save it as "pdo_connection.php".
So what can you say about this work? Share your thoughts in the comment section below or email me at [email protected]. Practice Coding. Thank you very much.
- CREATE TABLE `tbl_registration` (
- `tbl_registration_id` INT(11) NOT NULL,
- `first_name` VARCHAR(100) NOT NULL,
- `middle_name` VARCHAR(100) NOT NULL,
- `last_name` VARCHAR(100) NOT NULL,
- `email` VARCHAR(100) NOT NULL,
- `contact_number` VARCHAR(100) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Inserting Multiple Data Using MySQLi and PDO
Creating Our Connection For MySQLi (Object-Oriented). Save it as "mysqli_o_o_connection.php".- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "add_multiple_data";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- }
- ?>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "add_multiple_data";
- // Create connection
- // Check connection
- if (!$conn) {
- }
- ?>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "add_multiple_data";
- $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
- ?>
PHP Query To Insert Multiple Data
Using MySQLi (Object-Oriented)
- <?php
- include ('mysqli_o_o_connection.php');
- $sql = "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('John', 'Meyer', 'Doe', '[email protected]', '345-2346');";
- $sql .= "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('Mark', 'Meyer', 'Doe', '[email protected]', '235-5682');";
- $sql .= "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('Jane', 'Meyer', 'Doe', '[email protected]', '869-2356');";
- if ($conn->multi_query($sql) === TRUE) {
- echo "Multiple Data Successfully Created!!!";
- } else {
- echo "Error: " . $sql . "<br>" . $conn->error;
- }
- $conn->close();
- ?>
Using MySQLi (Procedural)
- <?php
- include ('mysqli_procedural_connection.php');
- $sql .= "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('Mark', 'Meyer', 'Doe', '[email protected]', '235-5682');";
- $sql = "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('John', 'Meyer', 'Doe', '[email protected]', '345-2346');";
- $sql .= "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- VALUES ('Jane', 'Meyer', 'Doe', '[email protected]', '869-2356');";
- echo "Multiple Data Successfully Created!!!";
- } else {
- }
- ?>
Using PDO (PHP Data Objects)
- <?php
- include ('pdo_connection.php');
- try {
- // set the PDO error mode to exception
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- // begin the transaction
- $conn->beginTransaction();
- // our SQL statements
- $conn->exec("INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- $conn->exec("INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- $conn->exec("INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number)
- // commit the transaction
- $conn->commit();
- echo "Multiple Data Successfully Created!!!";
- }
- catch(PDOException $e)
- {
- // roll back the transaction if something failed
- $conn->rollback();
- echo "Error: " . $e->getMessage();
- }
- $conn = null;
- ?>
Add new comment
- 1708 views