borang_ayam_proses2

<?php
//echo '<pre>'; print_r($_POST) . '</pre>';

$host        =    'localhost';
$user        =    'dbayam';
$password    =    'pwdayamdb';
$database    =    'ayam';
$conn        =    mysql_connect($host,$user,$password) or die('Server Information is not Correct');
mysql_select_db($database,$conn) or die('Database Information is not correct');

/*
Contoh sql yang sepatutnya

INSERT INTO serama_a
(sangkar,gaya,tubuh,ekor,balung,sayap,bulu,warna,kaki,lawi)
VALUES
('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi')
*/

$isi = null;
$jumlah_key = count($_POST['serama_a']);
$sql ="\rINSERT INTO serama_a \r";

foreach ($_POST['serama_a'] as $key=>$data)
{
    $tajuk = '(`' . implode('`, `', array_keys($data)) . '`)' .
    "\rVALUES\r";

    $isi .= '("' . implode('", "', array_values($data)) . '")';
    $isi .= ($key == $jumlah_key) ? "\r" : ",\r";
}

echo 'Jumlah key = ' . $jumlah_key . '<br><pre>' .
$sql . $tajuk . $isi . '<br></pre>';