upload a CSV file using PHP file upload functionality and insert the data into a DB
For simplicity, I have everything including the PHP code, Bootstrap and DB connection all in one file: csv_upload.php
Bootstrap- submit type input field to upload the file
<p> Upload CSV: <input type="file" name="file"></p>
<p> <input type="submit" name="submitfile" value="Import"></p>
PHP- 1. check if file extension is csv
if($_FILES['file']['name'])
{
$filename = explode(".", $_FILES['file']['name']);
if($filename[1]=='csv')- check if the size is under 1MB (or anything else user can specify)
if ($_FILES['file']['size'] < 1000000) //filesize is always in kb- insert csv file data into the DB table called csv_data
$sql = "insert into csv_data(id, name, email, phone, street_address, city, state, postal_code) values('','$item1'
,'$item2','$item3','$item4','$item5','$item6','$item7')";
mysqli_query($db, $sql) or die(mysqli_error($db)."...at line- ". __LINE__);- close Mysql connection
mysqli_close($db);