Advertisement
GWibisono

update BB

Nov 25th, 2013
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.51 KB | None | 0 0
  1. <?php
  2. /*
  3. CREATE TABLE IF NOT EXISTS `file_csv` (
  4.   `id` int(11) NOT NULL AUTO_INCREMENT,
  5.   `code` varchar(50) NOT NULL,
  6.   `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  7.   `contents` longblob NOT NULL,
  8.   `user_id` int(11) NOT NULL,
  9.   PRIMARY KEY (`id`),
  10.   UNIQUE KEY `code` (`code`)
  11. ) ENGINE=MyISAM
  12. */
  13. $mysqli = new mysqli("localhost", "root", "", "inibayik_bayi");
  14.  
  15.     /* check connection */
  16.     if (mysqli_connect_errno()) {
  17.         printf("Connect failed: %s\n", mysqli_connect_error());
  18.         exit();
  19.     }
  20.    
  21.  
  22. if($_POST)
  23. {
  24.      copy($_FILES['f']['tmp_name'],'035.tmp');
  25.     $row = 1; $s='';
  26.     /*
  27.     $a=array('tes1'=>434,'tes2'=>33535);
  28.     die(implode(",",array_keys($a) ));
  29.     */
  30.     $a=array('code'=>$_FILES['f']['name'],
  31.     'user_id'=>99
  32.     );
  33.    
  34.     //die("'".implode("','",array_keys($a) )."'");
  35.    
  36.     if (($handle = fopen("035.tmp", "r")) !== FALSE)
  37.     {
  38.         $aCsv=array();
  39.         while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  40.             $num = count($data);
  41.             $aCsv[]=$data;
  42.            
  43.         }
  44.  
  45.    
  46.         $a['contents'] = json_encode($aCsv);
  47.         //trim(fread($handle, filesize('035.tmp')) );
  48.        
  49.         $a2=array();
  50.         foreach($a as $n=>$v)$a2[$n]= addslashes($v);      
  51.         $val=implode("','", $a2 );
  52.         $sql="select count(id) c from file_csv where code like '$a[code]'";
  53.         $q=$mysqli->query($sql);
  54.         $row = $q->fetch_assoc();
  55.         $stat="update";
  56.         if($row['c']==0)
  57.         {
  58.             $stat="insert";
  59.         }
  60.        
  61.         if($stat=='update')
  62.         {
  63.             $sql="select id
  64.             from file_csv
  65.             where code like '$a[code]'";
  66.             $q=$mysqli->query($sql);
  67.             $row = $q->fetch_assoc();
  68.             if(!$q)
  69.             {
  70.                 die($mysqli->error);
  71.             }
  72.                        
  73. //==============rename file csv yang terdahulu
  74.             $mktime=@mktime()-1385442970;
  75.             $sql="UPDATE   `file_csv` SET  `code` =  '{$a['code']}_".$mktime."' WHERE  `file_csv`.`id` =$row[id];";
  76.             $q=$mysqli->query($sql);
  77.            
  78.             $sql="insert into
  79.             file_csv(`".implode("`,`",array_keys($a) )."`)
  80.             values('$val')";
  81.            
  82.         }else{
  83.             $sql="insert into
  84.             file_csv(`".implode("`,`",array_keys($a) )."`)
  85.             values('$val')";
  86.         }
  87.        
  88.         fclose($handle);
  89.         $q=$mysqli->query($sql);
  90.         unlink('035.tmp');
  91.         if(!$q)
  92.         {
  93.             die($mysqli->error);
  94.         }
  95.     }
  96.      
  97.     ?><script>alert('data sudah di upload');
  98.     window.location.href ="?done=1"; </script><?
  99. }
  100. ?>
  101. <form name='myform' enctype='multipart/form-data' method='POST'>
  102.          
  103.         <div id='selectfile'>
  104.         <input type=file name=f />
  105.         </div>
  106.     <br>
  107.     <input type='hidden' name='n'  value='1' />
  108.    <INPUT TYPE=SUBMIT VALUE='upload' name ='submit'>
  109.     </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement