Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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')
- */
- $sql ="\rINSERT INTO serama_a \r";
- foreach ($_POST['serama_a'] as $key=>$data)
- {
- $tajuk = '(`' . implode('`, `', array_keys($data)) . '`)' .
- "\rVALUES\r";
- //$sql.="\r$key => $data | ";
- $isi .= '("' . implode('", "', array_values($data)) . '")' .
- ',<br>';
- }
- echo $sql . '<br>' . $tajuk . '<br>' . $isi;
Advertisement
Add Comment
Please, Sign In to add comment