Kl insertnya manual, berarti :
INSERT INTO contoh ( nama, alamat ) VALUES ('Andi', 'Bandung');
INSERT INTO contoh ( nama, alamat ) VALUES ('Dedi', 'Semarang');
INSERT INTO contoh ( nama, alamat ) VALUES ('Toni', 'Bali');
INSERT INTO contoh ( nama, alamat ) VALUES ('Dewi', 'Jakarta');
INSERT INTO contoh ( nama, alamat ) VALUES ('Dewo', 'bandung');
Kalo looping schema nya(5x insert), berarti :
for($i=1; $i<=5; $i++)
{
$input_[$i]="INSERT INTO user (nama,alamat)
VALUES('$nama_[$i]','$alamat[$i]')";
mysql_query($input_[$i]);
}
kira2 begitu..
Muhadkly - Acho- , http://muhadly.info
====================================
----- Original Message -----
From: Danny Eka
To: itcenter
Sent: Wednesday, April 04, 2007 11:35 AM
Subject: [ITCENTER] Tanya PHP & MySQL
Halo ITers,
Mo tanya, klo mo insert data ke dalam database MySQL, perintahnya gimana,
datanya dalam bentuk multiple, maksud aku recordnya lebih dari satu, misal :
Cth nama & alamat yg mo di insert ke MySQL
1. Andi Bandung
2. Dedi Semarang
3. Toni Bali
4. Dewi Jakarta
5. Dewo Bandung
jadi pas di MySQL recordnya langsung ada 5 records, perintah MySQLnya gimana
ya..?
Thanks in Advance
Rgds
Danny
[Non-text portions of this message have been removed]
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
## Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
