borang_ayam_proses3

<?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)
{
    $sql .= '(`' . implode('`, `', array_keys($data)) . '`)' .
    "\rVALUES\r";

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

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

if (!mysql_query($sqlsangkar))
    die('Error: ' . mysql_error());
else
    $papar = "$jumlah_key record added";

header('location: ./borang_papar.php?msg=' . $papar);