Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- CREATE TABLE IF NOT EXISTS `file_csv` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `code` varchar(50) NOT NULL,
- `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `contents` longblob NOT NULL,
- `user_id` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `code` (`code`)
- ) ENGINE=MyISAM
- */
- $mysqli = new mysqli("localhost", "root", "", "inibayik_bayi");
- /* check connection */
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- if($_POST)
- {
- copy($_FILES['f']['tmp_name'],'035.tmp');
- $row = 1; $s='';
- /*
- $a=array('tes1'=>434,'tes2'=>33535);
- die(implode(",",array_keys($a) ));
- */
- $a=array('code'=>$_FILES['f']['name'],
- 'user_id'=>99
- );
- //die("'".implode("','",array_keys($a) )."'");
- if (($handle = fopen("035.tmp", "r")) !== FALSE)
- {
- $aCsv=array();
- while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
- $num = count($data);
- $aCsv[]=$data;
- }
- $a['contents'] = json_encode($aCsv);
- //trim(fread($handle, filesize('035.tmp')) );
- $a2=array();
- foreach($a as $n=>$v)$a2[$n]= addslashes($v);
- $val=implode("','", $a2 );
- $sql="select count(id) c from file_csv where code like '$a[code]'";
- $q=$mysqli->query($sql);
- $row = $q->fetch_assoc();
- $stat="update";
- if($row['c']==0)
- {
- $stat="insert";
- }
- if($stat=='update')
- {
- $sql="select id
- from file_csv
- where code like '$a[code]'";
- $q=$mysqli->query($sql);
- $row = $q->fetch_assoc();
- if(!$q)
- {
- die($mysqli->error);
- }
- //==============rename file csv yang terdahulu
- $mktime=@mktime()-1385442970;
- $sql="UPDATE `file_csv` SET `code` = '{$a['code']}_".$mktime."' WHERE `file_csv`.`id` =$row[id];";
- $q=$mysqli->query($sql);
- $sql="insert into
- file_csv(`".implode("`,`",array_keys($a) )."`)
- values('$val')";
- }else{
- $sql="insert into
- file_csv(`".implode("`,`",array_keys($a) )."`)
- values('$val')";
- }
- fclose($handle);
- $q=$mysqli->query($sql);
- unlink('035.tmp');
- if(!$q)
- {
- die($mysqli->error);
- }
- }
- ?><script>alert('data sudah di upload');
- window.location.href ="?done=1"; </script><?
- }
- ?>
- <form name='myform' enctype='multipart/form-data' method='POST'>
- <div id='selectfile'>
- <input type=file name=f />
- </div>
- <br>
- <input type='hidden' name='n' value='1' />
- <INPUT TYPE=SUBMIT VALUE='upload' name ='submit'>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement