Server IP : 51.89.169.208 / Your IP : 18.216.230.65 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/ |
Upload File : |
<?php $conn = mysqli_connect("localhost","yellow_db","office3ffff21451s23","yellow_db"); if(isset($_POST["import"])){ ini_set('max_execution_time', 800); $fileName = $_FILES["file"]["tmp_name"]; if($_FILES ["file"]["size"] > 0){ $file = fopen($fileName, "r"); while(($column = fgetcsv($file,10000, ",")) !== FALSE){ $sqlInsert ="Insert into data ( ext_compay_ids) values ('" . $column[0] . "')"; $result = mysqli_query($conn, $sqlInsert); } if(!empty($result)){ echo "csv data imported"; }else{ echo "Data not importing"; } } } ?> <form class="form-horizoontal" action="" method="post" name="uploadCsv" enctype="multipart/form-data"> <div> <label for="">Choose file</label> <input type="file" name="file" accept=".csv"> <button type="submit" name="import">Import</button> </div> </form>