Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //ubah dengan susunan field tablemu
- $field=array(
- 'satu','dua','tiga'
- );
- $table="empat";
- $mysqli = new mysqli("localhost", "root", "", "temp_main");
- //==========Apakah ada data yang dikirim?========
- $aData=array();
- if(isset($_POST))
- {
- $s=$_POST['data'];
- //==========Pecah-pecah berdasarkan penekanan enter=======
- $a1=explode("\n",$s);
- foreach($a1 as $v)
- {
- //==========Pecah-pecah berdasarkan fieldnya==============
- $a2=explode("\t",trim($v));
- $aData[]=$a2;
- }
- //==========Input Data Di mulai=============
- $no=0;
- foreach($aData as $a)
- {
- //=============FIELD
- $field="`$field[0]`";
- for($i=1;$i<count($field);$i++)
- {
- $field.=", `{$field[$i]}`";
- }
- //=============DATA
- $data="`$a[0]`";
- for($i=1;$i<count($a);$i++)
- {
- $data.=", `{$a[$i]}`";
- }
- $sql="insert into `$table` ( $field ) values ( $data )";
- $q=$mysqli->query($sql);
- if(!$q)
- {
- die($mysqli->error);
- }
- if($no%100&&$no>1)
- {
- echo "<br/> input data ke $no";
- }
- $no++;
- }
- exit();
- }
- ?><form method="post">
- <textarea rows="4" cols="50" name='data'></textarea>
- <br/> <input type='submit' />
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement