Postingan lainnya
insert 2 table sekaligus di php mysql dalam 1 eksekusi atau query
hello saya mau tanya , gimana caranya insert 2 table sekaligus?
statement 1====> $query= "INSERT INTO tb_users (username, password, ip, email, referer,joindate) VALUES('$username','$password','$laip','$email','$referer','$joindate')";
statement 2 ====> INSERT INTO lastregister (username,ip,joindate) VALUES('$username','$laip','$joindate2')
0
1 Jawaban:
Jawaban Terpilih
inisialisasi $query 2 kali tapi pake ".=" buat yang kedua dst.
$query = "INSERT INTO tb_users (username, password, ip, email, referer,joindate) VALUES('$username','$password','$laip','$email','$referer','$joindate')";
$query .= "INSERT INTO lastregister (username,ip,joindate) VALUES('$username','$laip','$joindate2')";
misal pakai mysqli
$q = mysqli_multi_query($conn, $query);
if ($q) {
echo "Success";
}
sumber: https://www.w3schools.com/php/php_mysql_insert_multiple.asp
1
