Insert Data Using php in Mysql Database
Publish: 29 March 2024, 5:12 pm IST | Views: 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








