Home
My Quiz

Insert Data Using php in Mysql Database

Publish: 29 March 2024, 5:12 pm IST | Views: Page View 119

<?php

include 'data-conn.php';

// Define array of data to be inserted
$data = array(
    array('John', 'Doe'),
    array('Jane', 'Smith'),
    array('Michael', 'Johnson'),
    array('Emily', 'Williams')
);

// Loop through each data item and insert into the database
foreach ($data as $row) {
    $first_name = $row[0];
    $last_name = $row[1];

    // Insert data into the database
    $sql = "INSERT INTO users (first_name, last_name) VALUES ('$first_name', '$last_name')";
    if(mysqli_query($conn, $sql)){
        echo "Record inserted successfully.<br>";
    } else{
        echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn) . "<br>";
    }
}

// Close the database connection
mysqli_close($conn);
?>

इसको इन्सर्ट करने से टेबल में डाटा इन्सर्ट हो जायेगा

Categories: Uncategorized