amin007

borang_ayam_proses

Nov 13th, 2012
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. <?php
  2. //echo '<pre>'; print_r($_POST) . '</pre>';
  3. $host        =    'localhost';
  4. $user        =    'dbayam';
  5. $password    =    'pwdayamdb';
  6. $database    =    'ayam';
  7. $conn        =    mysql_connect($host,$user,$password) or die('Server Information is not Correct');
  8. mysql_select_db($database,$conn) or die('Database Information is not correct');
  9. /*// Contoh sql yang sepatutnya
  10.  
  11. INSERT INTO serama_a
  12. (sangkar,gaya,tubuh,ekor,balung,sayap,bulu,warna,kaki,lawi)
  13. VALUES
  14. ('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
  15. ('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
  16. ('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
  17. ('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi'),
  18. ('$sangkar','$gaya','$tubuh','$ekor','$balung','$sayap','$bulu','$warna','$kaki','$lawi')
  19. */
  20.  
  21. $sql ="\rINSERT INTO serama_a \r";
  22.        
  23. foreach ($_POST['serama_a'] as $key=>$data)
  24. {
  25.     $tajuk = '(`' . implode('`, `', array_keys($data)) . '`)' .
  26.     "\rVALUES\r";
  27.  
  28.     //$sql.="\r$key => $data | ";
  29.     $isi .= '("' . implode('", "', array_values($data)) . '")' .
  30.         ',<br>';
  31. }
  32.  
  33. echo $sql . '<br>' . $tajuk . '<br>' . $isi;
Advertisement
Add Comment
Please, Sign In to add comment