Guys tama ba yung query ko pag mag iinput ng multiple data sa madaming table
View attachment 1249305
Then eto ung pag iiputan ko ng mga data
View attachment 1249306
Boss gumamit ka ng multiple insert na command.
========================
for MySQLi(procedural)
========================
$username = "root";
$password = "";
$database = "mysqltutorial";
// Create connection
$conn = mysqli_connect($server, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// sql to Insert record table
$sql = "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Villanueva', 'Joken', 'Kabankalan City');";
$sql .= "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Batuto', 'Erick Jason', 'Cebu City');";
$sql .= "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Drapite', 'Bryan', 'Kabankalan City');";
if (mysqli_multi_query($conn, $sql)) {
echo "New record created successfully!";
} else {
echo "Error: " . $sql . "
" . mysqli_error($conn);
}
mysqli_close($conn);
?>
========================
ito yung way using MYQLi (OOP)
========================
die("Connection failed: " . $conn->connect_error);
}
// sql to Insert record table
$sql = "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Villanueva', 'Joken', 'Kabankalan City');";
$sql .= "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Batuto', 'Erick Jason', 'Cebu City');";
$sql .= "INSERT INTO tblpeople (LNAME, FNAME, ADDRESS)
VALUES ('Drapite', 'Bryan', 'Kabankalan City');";
if ($conn->multi_query($sql) === TRUE) {
echo "New records created successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
$conn->close();
?>
If my mga katanungan PM lg boss.