Advertisement
GWibisono

form input

Oct 22nd, 2013
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.14 KB | None | 0 0
  1. <?php
  2. //ubah dengan susunan field tablemu
  3. $field=array(
  4. 'satu','dua','tiga'
  5. );
  6. $table="empat";
  7.  
  8. $mysqli = new mysqli("localhost", "root", "", "temp_main");
  9.  
  10. //==========Apakah ada data yang dikirim?========
  11. $aData=array();
  12. if(isset($_POST))
  13. {
  14.     $s=$_POST['data'];
  15. //==========Pecah-pecah berdasarkan penekanan enter======= 
  16.     $a1=explode("\n",$s);
  17.     foreach($a1 as $v)
  18.     {
  19. //==========Pecah-pecah berdasarkan fieldnya============== 
  20.         $a2=explode("\t",trim($v));
  21.         $aData[]=$a2;
  22.     }
  23. //==========Input Data Di mulai=============   
  24.     $no=0;
  25.     foreach($aData as $a)
  26.     {
  27. //=============FIELD
  28.         $field="`$field[0]`";
  29.         for($i=1;$i<count($field);$i++)
  30.         {
  31.             $field.=", `{$field[$i]}`";
  32.         }
  33. //=============DATA
  34.         $data="`$a[0]`";
  35.         for($i=1;$i<count($a);$i++)
  36.         {
  37.             $data.=", `{$a[$i]}`";
  38.         }
  39.        
  40.         $sql="insert into `$table` ( $field ) values ( $data )";   
  41.    
  42.         $q=$mysqli->query($sql);
  43.         if(!$q)
  44.         {
  45.             die($mysqli->error);
  46.         }
  47.         if($no%100&&$no>1)
  48.         {
  49.             echo "<br/> input data ke $no";
  50.         }
  51.         $no++;
  52.     }
  53. exit();
  54. }
  55. ?><form method="post">
  56. <textarea rows="4" cols="50" name='data'></textarea>
  57. <br/> <input type='submit' />
  58. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement