Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- date_sourced : date
- sha1: varchar(255)
- vsdt: varchar(255)
- trendx:varchar(255)
- notes:varchar(255)
- <?php
- if(isset($_POST['submit'])) {
- $host = 'localhost';
- $user = 'root';
- $password = '';
- $db = 'jeremy_db';
- ini_set('max_execution_time', 500);
- $con = mysqli_connect($host,$user,$password) or die('Could not' .mysqli_error($con));
- mysqli_select_db($con, $db) or die ('Could not' .mysqli_error($con));
- $file = $_FILES['file']['tmp_name'];
- $handle = fopen($file, "r");
- ini_set ('memory_limit', filesize ($file) + 4000000);
- $c = 0;
- while(($csvdata = fgetcsv($handle,10000,","))!== FALSE){
- $sha1 = $csvdata[0];
- $vsdt = $csvdata[1];
- $trendx = $csvdata[2];
- $sql = "INSERT INTO jeremy_table_trend (sha1,vsdt,trendx) VALUES ('$sha1','$vsdt','$trendx')";
- $query = mysqli_query($con , $sql);
- $c = $c+1;
- }
- if($query){
- echo '<script type="text/javascript">';
- echo ' alert("CSV uploaded to server");';
- echo ' window.location.href = "trendx.php";';
- echo '</script>';
- }
- else {
- echo "SLAM";
- }
- }
- ?>
- <form id = "myForm" class="ui input" enctype="multipart/form-data" method = "POST" action="trend_upload_csv.php" role = "form">
- <input type = "file" name ="file" id="file" size = "150">
- <input id="myBtn" class="ui small red button" type = "submit" class = "btn btn-default" name ="submit" onclick = "myFunction();" value = "Upload CSV" disabled />
- </form>
Add Comment
Please, Sign In to add comment