<div>
Here's my teaching example showing how to upload and store a CSV. &nbsp;If you can show us the contents of your CSV test file and the CREATE TABLE statement, we can probably give you a more complete example. 

<pre><code class="code-100 nolinks" id="code-20-42109130-1">&lt;?php // demo/upload_example.php
/**
 * Demonstrate how to upload one or more files, using HTML5 and PHP
 *
 * REQUIRED: Man Page References
 * http://www.w3schools.com/tags/att_input_multiple.asp
 *
 * http://php.net/manual/en/reserved.variables.files.php
 * http://php.net/manual/en/features.file-upload.php
 * http://php.net/manual/en/features.file-upload.post-method.php
 * http://php.net/manual/en/features.file-upload.common-pitfalls.php
 * http://php.net/manual/en/features.file-upload.errors.php
 * http://php.net/manual/en/features.file-upload.multiple.php
 *
 * http://php.net/manual/en/function.move-uploaded-file.php
 *
 * IMPORTANT: If dealing with large files
 * http://php.net/manual/en/ini.core.php#ini.upload-max-filesize
 * http://php.net/manual/en/ini.core.php#ini.post-max-size
 * http://php.net/manual/en/info.configuration.php#ini.max-input-time
 *
 * SEE ALSO:
 * http://php.net/manual/en/security.filesystem.php
 */
error_reporting(E_ALL);

// MAY NOT BE NEEDED - CHECK PHP_INI PARAMETERS FOR YOUR TIMEZONE
date_default_timezone_set('America/Chicago');

// ESTABLISH THE NAME OF THE DESTINATION FOLDER ('storage' DIRECTORY)
$storage = 'storage';
if (!is_dir($storage))
{
 mkdir($storage);
}

// ESTABLISH THE BIGGEST FILE SIZE WE WILL ACCEPT - ABOUT 8 MB
$max_file_size = 8 * 1024 * 1024;

// AN ARRAY TELLING THE KINDS OF FILE EXTENSIONS WE WILL ACCEPT
$file_exts = [ 'csv' ];

// ARRAY OF ERRORS THAT MAY BE REPORTED IN $_FILES[][&quot;error&quot;] (THERE IS NO #5)
$errors = array
( UPLOAD_ERR_OK =&gt; &quot;Success!&quot;
, UPLOAD_ERR_INI_SIZE =&gt; &quot;The uploaded file exceeds the upload_max_filesize directive in php.ini&quot;
, UPLOAD_ERR_FORM_SIZE =&gt; &quot;The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form&quot;
, UPLOAD_ERR_PARTIAL =&gt; &quot;The uploaded file was only partially uploaded&quot;
, UPLOAD_ERR_NO_FILE =&gt; &quot;No file was uploaded&quot;
, 5 =&gt; &quot;UNDEFINED ERROR #5&quot;
, UPLOAD_ERR_NO_TMP_DIR =&gt; &quot;Missing a temporary folder&quot;
, UPLOAD_ERR_CANT_WRITE =&gt; &quot;Cannot write file to disk&quot;
, UPLOAD_ERR_EXTENSION =&gt; &quot;A PHP extension stopped the file upload&quot;
)
;


// IF WE HAVE GOT SOMETHING IN $_POST - RUN THE ACTION SCRIPT
if (!empty($_POST))
{
 echo &quot;&lt;h2&gt;Results: File Upload&lt;/h2&gt;&quot; . PHP_EOL;

 // ACTIVATE THIS TO SEE WHAT IS COMING THROUGH IN THE REQUEST
 // echo &quot;&lt;pre&gt;&quot;; var_dump($_FILES); var_dump($_POST); echo &quot;&lt;/pre&gt;&quot;;

 // REORGANIZE THE CONTENTS OF $_FILES SO WE CAN USE AN ITERATOR MORE SENSIBLY
 $nf = count($_FILES['userfile']['name']);
 while ($nf)
 {
 $nf--;
 $my_uploaded_files[$nf]['name'] = $_FILES['userfile']['name'][$nf];
 $my_uploaded_files[$nf]['type'] = $_FILES['userfile']['type'][$nf];
 $my_uploaded_files[$nf]['tmp_name'] = $_FILES['userfile']['tmp_name'][$nf];
 $my_uploaded_files[$nf]['error'] = $_FILES['userfile']['error'][$nf];
 $my_uploaded_files[$nf]['size'] = $_FILES['userfile']['size'][$nf];
 }

 // ITERATE OVER THE COLLECTION OF UPLOADED FILES
 foreach ($my_uploaded_files as $my_uploaded_file)
 {
 // SKIP OVER EMPTY SPOTS - NOTHING UPLOADED
 $error_code = $my_uploaded_file[&quot;error&quot;];
 if ($error_code == UPLOAD_ERR_NO_FILE) continue;

 // IF THERE ARE ERRORS
 if ($error_code != UPLOAD_ERR_OK)
 {
 $error_message = $errors[$error_code];
 trigger_error(&quot;Upload error code: $error_code: $error_message&quot;, E_USER_WARNING);
 continue;
 }

 // SYNTHESIZE THE NEW FILE NAME
 $f_type = explode('.', basename($my_uploaded_file['name']));
 $f_type = end($f_type);
 $f_type = trim(strtolower($f_type));

 $f_name = explode('.', basename($my_uploaded_file['name']));
 $f_name = current($f_name);
 $f_name = trim(strtolower($f_name));

 // SERVER PATH TO THE NEW FILE
 $my_file_path
 = getcwd()
 . DIRECTORY_SEPARATOR
 . $storage
 . DIRECTORY_SEPARATOR
 . $f_name
 . '.'
 . $f_type
 ;

 // URL PATH TO THE NEW FILE
 $my_file_url
 = $storage
 . DIRECTORY_SEPARATOR
 . $f_name
 . '.'
 . $f_type
 ;

 // OPTIONAL TEST FOR ALLOWABLE EXTENSIONS
 if (!in_array($f_type, $file_exts))
 {
 trigger_error(&quot;$f_type Not allowed&quot;, E_USER_WARNING);
 continue;
 }

 // GET THE FILE SIZE
 $file_size = number_format($my_uploaded_file[&quot;size&quot;]);

 // IF THE FILE IS NEW (DOES NOT EXIST)
 if (!file_exists($my_file_path))
 {
 // IF THE MOVE FUNCTION WORKED CORRECTLY
 if (move_uploaded_file($my_uploaded_file['tmp_name'], $my_file_path))
 {
 $upload_success = 1;
 }
 // IF THE MOVE FUNCTION FAILED
 else
 {
 $upload_success = -1;
 }
 }

 // IF THE FILE ALREADY EXISTS
 else
 {
 echo &quot;&lt;br/&gt;&lt;b&gt;&lt;i&gt;$my_file_url&lt;/i&gt;&lt;/b&gt; already exists.&quot; . PHP_EOL;

 // SHOULD WE OVERWRITE THE FILE? IF NOT
 if (empty($_POST[&quot;overwrite&quot;]))
 {
 $upload_success = 0;
 }
 // IF WE SHOULD OVERWRITE THE FILE, TRY TO MAKE A BACKUP
 else
 {
 $now = date('Ymd\THis');
 $my_bak = $my_file_path . '.' . $now . '.bak';
 if (!copy($my_file_path, $my_bak))
 {
 trigger_error(&quot;Backup Failed for $my_file_url&quot;, E_USER_WARNING);
 }
 if (move_uploaded_file($my_uploaded_file['tmp_name'], $my_file_path))
 {
 $upload_success = 2;
 }
 else
 {
 $upload_success = -1;
 }
 }
 }

 // REPORT OUR SUCCESS OR FAILURE
 if ($upload_success == 2) { echo &quot;&lt;br/&gt;It has been overwritten.&quot; . PHP_EOL; }
 if ($upload_success == 1) { echo &quot;&lt;br/&gt;&lt;b&gt;$my_file_url&lt;/b&gt; has been saved.&quot; . PHP_EOL; }
 if ($upload_success == 0) { echo &quot;&lt;br/&gt;&lt;b&gt;It was NOT overwritten.&lt;/b&gt;&quot; . PHP_EOL; }
 if ($upload_success &lt; 0) { echo &quot;&lt;br/&gt;&lt;b&gt;ERROR: $my_file_url NOT SAVED - SEE WARNING FROM &lt;i&gt;move_uploaded_file()&lt;/i&gt;&lt;/b&gt;&quot; . PHP_EOL; }
 if ($upload_success &gt; 0)
 {
 echo &quot;$file_size bytes uploaded.&quot; . PHP_EOL;
 if (!chmod ($my_file_path, 0644))
 {
 echo '&lt;br/&gt;chmod(0644) FAILED: fileperms() = ';
 echo substr(sprintf('%o', fileperms($my_file_path)), -4);
 }
 echo '&lt;br/&gt;See the file: &lt;a target=&quot;_blank&quot; href=&quot;' . $my_file_url . '&quot;&gt;' . $my_file_url . '&lt;/a&gt;&lt;br/&gt;' . PHP_EOL;
 }
 } // END FOREACH ITERATOR - EACH ITERATION PROCESSES ONE FILE
} // END ACTION SCRIPT


// CREATE THE HTML FORM USING HEREDOC NOTATION
$form = &lt;&lt;&lt;EOF
&lt;h2&gt;Upload file(s)&lt;/h2&gt;
&lt;!--
 SOME IMPORTANT THINGS TO NOTE ABOUT THIS FORM...
 REQUIRES THE HTML5 DOCTYPE
 ENCTYPE= ATTRIBUTE IN THE HTML &lt;FORM&gt; TAG
 MAX_FILE_SIZE HIDDEN CONTROL MUST PRECEDE THE FILE INPUT CONTROLS
 INPUT NAME= IN TYPE=FILE DETERMINES THE NAME YOU FIND IN _FILES ARRAY
 ABSENCE OF ACTION= ATTRIBUTE IN &lt;FORM&gt; TAG CAUSES POST TO SAME URL
--&gt;
&lt;form name=&quot;UploadForm&quot; enctype=&quot;multipart/form-data&quot; method=&quot;post&quot;&gt;
&lt;input type=&quot;hidden&quot; name=&quot;MAX_FILE_SIZE&quot; value=&quot;$max_file_size&quot; /&gt;
&lt;p&gt;
Find the file(s) you want to upload and click the &quot;Upload&quot; button below.
&lt;/p&gt;

&lt;input type=&quot;file&quot; multiple name=&quot;userfile[]&quot; size=&quot;80&quot; /&gt;

&lt;br/&gt;Check this box &lt;input autocomplete=&quot;off&quot; type=&quot;checkbox&quot; name=&quot;overwrite&quot; /&gt; to &lt;b&gt;overwrite&lt;/b&gt; existing files.
&lt;input type=&quot;submit&quot; value=&quot;Upload&quot; /&gt;
&lt;/form&gt;
EOF;

echo $form;
</code></pre>
</div>

<div>
Ray's teaching sample's are usually definitive works. If you are looking for the bare bones CSV import based on <a href="http://php.net/manual/en/function.fgetcsv.php" rel="ugc">fgetcsv()</a> 
 

<pre><code class="code-1 nolinks" id="code-20-42109178-1">$pathtofile = 'set your file name here';
$fh = fopen($pathtofile, &quot;rt&quot;);
while($data = fgetcsv($fh,1000, &quot;,&quot;) ){
 // $data is an array holding the comma separated values from the next row in the file
 // populate your query here
}
</code></pre>
</div>

<div>
@Julian I assume I can use a $_POST in $pathtofile = 'set your file name here'; Thanks
</div>

<div>
I would upload the CSV file first, then store it some place safe, then use something like Julian's fgetcsv() example. 
 
I can't believe that I didn't have a CSV-to-DB example in my library, so I wrote one. &nbsp;Here is the test data and the code sample. 
<a href="https://iconoun.com/demo/storage/csv_to_db_sample.csv" rel="ugc">https://iconoun.com/demo/storage/csv_to_db_sample.csv</a> 

<pre><code class="code-1 nolinks" id="code-20-42109319-1">red, green, blue
 3, 4, 5
 1, 2, 3
</code></pre>
<a href="https://iconoun.com/demo/csv_to_db.php" rel="ugc">https://iconoun.com/demo/csv_to_db.php</a> 

<pre><code class="code-100 nolinks" id="code-20-42109319-2">&lt;?php // demo/csv_to_db.php
/**
 * Show how to load a CSV file into a database
 */
error_reporting(E_ALL);


// DATABASE CONNECTION AND SELECTION VARIABLES
$db_host = &quot;localhost&quot;;
$db_name = &quot;??&quot;;
$db_user = &quot;??&quot;;
$db_word = &quot;??&quot;;

// OPEN A CONNECTION TO THE DATA BASE SERVER AND SELECT THE DB
$mysqli = new mysqli($db_host, $db_user, $db_word, $db_name);

// DID THE CONNECT/SELECT WORK OR FAIL?
if ($mysqli-&gt;connect_errno)
{
 $err
 = &quot;CONNECT FAIL: &quot;
 . $mysqli-&gt;connect_errno
 . ' '
 . $mysqli-&gt;connect_error
 ;
 trigger_error($err, E_USER_ERROR);
}


// THE URL OF THE CSV FILE
$url = 'storage/csv_to_db_sample.csv';


// OPEN THE SAMPLE FILE
$fpr = fopen($url, 'r');
if (!$fpr) trigger_error(&quot;Unable to open $url&quot;, E_USER_ERROR);

// GET THE COLUMN NAMES FROM THE TOP ROW OF THE CSV FILE
$top = fgetcsv($fpr);

// GENERATE THE &quot;CREATE TABLE&quot; STATEMNT
$sql = 'CREATE TEMPORARY TABLE csv_to_db_sample ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ';
foreach ($top as $col)
{
 $sql .= &quot;$col VARCHAR(24) NOT NULL DEFAULT '', &quot;;
}
$sql = rtrim($sql);
$sql = rtrim($sql, ',');
$sql .= ') ENGINE=MEMORY';

// CREATE THE TABLE. IF mysqli::query() RETURNS FALSE, LOG AND SHOW THE ERROR
if (!$res = $mysqli-&gt;query($sql))
{
 $err
 = 'QUERY FAILURE:'
 . ' ERRNO: '
 . $mysqli-&gt;errno
 . ' ERROR: '
 . $mysqli-&gt;error
 . ' QUERY: '
 . $sql
 ;
 trigger_error($err, E_USER_ERROR);
}


// READ THE DATA FROM THE CSV, MATCH TO THE TOP/COLUMN NAMES
while(!feof($fpr))
{
 $csv = fgetcsv($fpr);
 if (empty($csv)) continue; // SKIP EXTRA BLANK LINES AT THE END
 $csv = array_map('trim', $csv);
 $csv = array_combine($top, $csv);

 // MAKE A QUERY STRING FROM THE COMBINED COLUMN NAMES AND VALUES
 $cols = array_keys($csv);
 $vals = array_values($csv);
 $sql = &quot;INSERT INTO csv_to_db_sample (&quot;;
 $sql .= implode(',', $cols);
 $sql .= ') VALUES (';
 $sql .= &quot;'&quot; . implode(&quot;','&quot;, $vals) . &quot;'&quot;;
 $sql .= ')';

 if (!$res = $mysqli-&gt;query($sql))
	{
	 $err
	 = 'QUERY FAILURE:'
	 . ' ERRNO: '
	 . $mysqli-&gt;errno
	 . ' ERROR: '
	 . $mysqli-&gt;error
	 . ' QUERY: '
	 . $sql
	 ;
	 trigger_error($err, E_USER_ERROR);
 }
}
fclose($fpr);


// RUN A QUERY TO SHOW THAT WE LOADED THE CSV INTO THE DATABASE TABLE
$sql = &quot;SELECT * FROM csv_to_db_sample&quot;;
if (!$res = $mysqli-&gt;query($sql))
{
 $err
 = 'QUERY FAILURE:'
 . ' ERRNO: '
 . $mysqli-&gt;errno
 . ' ERROR: '
 . $mysqli-&gt;error
 . ' QUERY: '
 . $sql
 ;
 trigger_error($err, E_USER_ERROR);
}
echo '&lt;pre&gt;';
while ($row = $res-&gt;fetch_object())
{
 print_r($row);
}
</code></pre>
Outputs
<pre><code class="code-10 nolinks" id="code-20-42109319-3">stdClass Object
(
 [id] =&gt; 1
 [red] =&gt; 3
 [green] =&gt; 4
 [blue] =&gt; 5
)
stdClass Object
(
 [id] =&gt; 2
 [red] =&gt; 1
 [green] =&gt; 2
 [blue] =&gt; 3
)
</code></pre>
</div>

<div>
<blockquote>
can use a $_POST in $pathtofile
</blockquote>
Try it and see. &nbsp;Some PHP configuration options are in play here. &nbsp;You will need the allow_url_fopen() permission.
</div>

<div>
@Ray Thanks for samples. Definitive as usual. However, I do not need to store to db just display in select element. That was the problem when I googled, 99% covered mysql. 
 
Would my posted html be satisfactory? Thanks
</div>

<div>
@Julian in your code where do I store the file.
</div>

<div>
<blockquote>
Would my posted html be satisfactory? Thanks 
</blockquote>
Maybe I am misunderstanding the question. &nbsp;Here's what I'm thinking you want to do... 
 
1. Upload a CSV file 
2. Use the CSV file to create some kind of HTML &lt;select&gt; &lt;option&gt; tags. 
 
Here are the steps that I would follow 
1. Upload a CSV file 
2. Move the CSV file to a permanent location 
3. Sanitize each element in each row of the CSV file 
4. If anything failed sanitization, discard the CSV file 
5. Create the HTML &lt;select&gt; &lt;option&gt; tags, or store the CSV information in a database for future use, etc. 
 
The upload process seems logically disconnected (to me, at least) from using the external CSV file to build a client-facing web page.
</div>

<div>
I tried this an example and placed the data in na table. I can see the post in firebug but all I get in browser is no results. 
 

<pre><code class="code-10 nolinks" id="code-20-42109390-1">&lt;?php if ($_FILES[csv][size] &gt; 0) {

 //get the csv file
 $file = $_FILES[csv][tmp_name];
 $handle = fopen($file,&quot;r&quot;);
		
 //loop through the csv file
 
	while (($line = fgetcsv($handle)) !== false) {
 $row = $line[0]; // We need to get the actual row (it is the first element in a 1-element array)
 $cells = explode(&quot;;&quot;,$row);
 echo &quot;&lt;tr&gt;&quot;;
 foreach ($cells as $cell) {
 echo &quot;&lt;td&gt;&quot; . htmlspecialchars($cell) . &quot;&lt;/td&gt;&quot;;
 }
 echo &quot;&lt;/tr&gt;\n&quot;;
}
 

		} else {
	
	
	echo 'no reults';
}

?&gt;
</code></pre>
</div>

<div>
<blockquote>
Julian in your code where do I store the file.
</blockquote>
When the file is uploaded it goes to a temp folder. If you need to keep it first move it using <a href="http://php.net/manual/en/function.move-uploaded-file.php" rel="ugc">move_uploaded_file()</a> - if you don't need to keep it you can use it from the temp location and then remove it. Depends entirely on your application. 
 
the $_FILES array has the file information in it - original name and temp name.
</div>

<div>
<blockquote>
if you don't need to keep it you can use it from the temp location
</blockquote>
Before you do this, please read the cautionary notes for <a href="http://php.net/manual/en/function.is-uploaded-file.php" rel="ugc">is_uploaded_file()</a>. &nbsp;Otherwise you have created a security hole. &nbsp;PHP <a href="http://php.net/manual/en/function.move-uploaded-file.php" rel="ugc">move_uploaded_file()</a> handles this test for you. &nbsp;NEVER open the file from the temp location without this test!
</div>

<div>
So based on your comments should the code I posted work? because there are no results in browser. Thanks
</div>

<div>
No, there is a lot wrong with it 
1. Lines 1 and 4 

<pre><code class="code-1 nolinks" id="code-20-42110205-1">&lt;?php if ($_FILES[csv][size] &gt; 0) {
</code></pre>
If you had error checking on you would see that 'csv' is not an index - index names must be quoted 

<pre><code class="code-1 nolinks" id="code-20-42110205-2">&lt;?php if ($_FILES['csv']['size'] &gt; 0) {
...
$file = $_FILES[csv][tmp_name];
</code></pre>
 
2. The first line is problematic - what if no file was submitted or a file without an index 'csv' 

<pre><code class="code-1 nolinks" id="code-20-42110205-3">&lt;?php if ($_FILES[csv][size] &gt; 0) {
</code></pre>
Try this instead 

<pre><code class="code-1 nolinks" id="code-20-42110205-4">&lt;?php if (isset($_FILES['csv']) &amp;&amp; $_FILES['csv']['size'] &gt; 0) {
</code></pre>
 
3. It appears you are reading from a ';' delimited file in which case you need to tell fgetcsv that 

<pre><code class="code-1 nolinks" id="code-20-42110205-5">	while (($line = fgetcsv($handle, 1000, ';')) !== false) {
</code></pre>
 
4. You are outputting &lt;tr&gt; and &lt;td&gt; outside of a table element - need to add opening and closing &lt;table&gt; tags before and after loop 
 
This part I don't understand 

<pre><code class="code-1 nolinks" id="code-20-42110205-6"> $row = $line[0]; // We need to get the actual row (it is the first element in a 1-element array)
 $cells = explode(&quot;;&quot;,$row);
</code></pre>
Is the first data item itself a ';' delimited field or is the entire file ';' delimited and because you did not tell fgetcsv this it read the entire row into a single element, 
 
Here is my sample data 

<pre><code class="code-10 nolinks" id="code-20-42110205-7">1;Mister A;mistera@xxx.com;1;1
2;Mister B;misterb@xxx.com;2;1
3;Mister C;misterc@xxx.com;3;1
4;Mister D;misterd@xxx.com;4;1
5;Mister E;mistere@xxx.com;5;1
6;Mister F;misterf@xxx.com;6;1
7;Mister G;misterg@xxx.com;7;2
8;Mister H;misterh@xxx.com;8;2
9;Mister I;misteri@xxx.com;9;2
10;Mister J;misterj@xxx.com;10;2
11;Mister K;misterk@xxx.com;11;2
12;Mister L;misterl@xxx.com;12;2 
</code></pre>
Here is my sample code 

<pre><code class="code-10 nolinks" id="code-20-42110205-8">&lt;?php
if (isset($_FILES['csv']) &amp;&amp; 
	is_uploaded_file($_FILES['csv']['tmp_name']) &amp;&amp; 
	$_FILES['csv']['size'] &gt; 0) {
		
 //get the csv file
 $file = $_FILES['csv']['tmp_name'];
 $handle = fopen($file,&quot;r&quot;);
		
 //loop through the csv file
 echo &quot;&lt;table&gt;&quot;;
	while (($line = fgetcsv($handle, 1000, ';')) !== false) {
 $row = $line[0]; // We need to get the actual row (it is the first element in a 1-element array)
 echo &quot;&lt;tr&gt;&quot;;
 foreach ($line as $cell) {
 echo &quot;&lt;td&gt;&quot; . htmlspecialchars($cell) . &quot;&lt;/td&gt;&quot;;
 }
 echo &quot;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;&quot;;
}
else {
	echo 'no reults';
}
</code></pre>
 
Working sample <a href="http://www.marcorpsa.com/ee/t2369.html" rel="ugc">here</a>
</div>

<div>
@Ray Thanks for that. However, all i am getting is 'no result' instead of data. I change from ';' to ',' in the code. I have posted a sample of the csv file for your perusal. Thanks 
 

<pre><code class="code-1 nolinks" id="code-20-42110249-1">DEMOBILL001,DEMO10802,DEMO11122,DEMO6423,DEMO7462,DEMO7479,DEMO7479A,DEMO25,DEMO10079
</code></pre>
</div>

<div>
<blockquote>
I change from ';' to ',' in the code
</blockquote>
Why did you change? The code above handles the ';' - if you are going to change to ',' then you need to change that code to 

<pre><code class="code-10 nolinks" id="code-20-42110264-1">&lt;?php
if (isset($_FILES['csv']) &amp;&amp; 
	is_uploaded_file($_FILES['csv']['tmp_name']) &amp;&amp; 
	$_FILES['csv']['size'] &gt; 0) {
		
 //get the csv file
 $file = $_FILES['csv']['tmp_name'];
 $handle = fopen($file,&quot;r&quot;);
		
 //loop through the csv file
 echo &quot;&lt;table&gt;&quot;;
	// CHANGE THIS LINE
	while (($line = fgetcsv($handle, 1000, ',')) !== false) {
 $row = $line[0]; // We need to get the actual row (it is the first element in a 1-element array)
 echo &quot;&lt;tr&gt;&quot;;
 foreach ($line as $cell) {
 echo &quot;&lt;td&gt;&quot; . htmlspecialchars($cell) . &quot;&lt;/td&gt;&quot;;
 }
 echo &quot;&lt;/tr&gt;\n&quot;;
	}
	echo &quot;&lt;/table&gt;&quot;;
}
else {
	echo 'no reults';
}
</code></pre>
If you save your data line above to a file and change ',' back to ';' and then submit it to the sample link I posted you will see it works.
</div>

<div>
But my csv is comma delimited. What was happening was that I was looking at an incorrect input. should have been csvfile and not csv. It is now displaying data. However, how would I put in a select instead of table. Thanks
</div>

<div>
<blockquote>
However, how would I put in a select instead of table. Thanks 
</blockquote>
How do you mean - a SELECT to do what?
</div>

<div>
@Julian put the values in a dropdown
</div>

<div>
<blockquote>
the problem when I googled, 99% covered mysql
</blockquote>
Of course, because when applications allow clients to upload information to the server, the applications usually expect to store the information for future use. 
 
Please refer back to this comment and then help us understand what you're trying to achieve. 
<a href="https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42109343#a42109343" rel="ugc">https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42109343#a42109343</a> 
 
Do you want to upload a CSV file and produce an HTML document that contains the uploaded CSV in the form of &lt;option&gt; tags in a &lt;select&gt; list? &nbsp;I'm sure this is possible, but I have never seen any application do something like this. &nbsp;Maybe if we can get away from the technical details and get closer to the application requirements...
</div>

<div>
@Ray ok. Very simply, I have a need to allow a user to upload a valid CSV comma delimited file from excel and populate a html dropdown element. The reason is that this user has many files and this would be an easier way for him to do it. Events after this are taken care of from previous posts. So order of events. 
 
1) Upload CSV 
2) Check that size does not exceed 50mb 
3) Check that the file is CSV or TXT 
4) Extract data from file 
5) Populate a dropdown (&lt;select&gt;) element with results 
 
Hope that is clearer. Thanks
</div>

<div>
@Ray FYI In your script posted earlier, ID: 42109319, line 41 $file_exts = [ 'csv' ]; produces 'PHP Parse error: &nbsp;syntax error, unexpected '['
</div>

<div>
<blockquote>
$file_exts = [ 'csv' ]; produces 'PHP Parse error: &nbsp;syntax error
</blockquote>
This indicates that you're running a dangerously out-of-date version of PHP. &nbsp;Time to upgrade. &nbsp;The current versions of PHP are listed on the home page under the word &quot;Download.&quot; &nbsp;They all support the current array notation. 
<a href="http://php.net/" rel="ugc">http://php.net/</a>
</div>

<div>
Back to this... 
<a href="https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42110401#a42110401" rel="ugc">https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42110401#a42110401</a> 
 
You're saying that you do not actually want to save the uploaded information -- just create a &lt;select&gt; &lt;option&gt; collection?
</div>

<div>
<a href="https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42110439#a42110439" rel="ugc">https://www.experts-exchange.com/questions/29018695/How-do-I-Import-CSV-File-In-my-PHP-Application.html?anchorAnswerId=42110439#a42110439</a>
</div>

<div>
@Julian Thanks for that. Yes that is the correct answer. But I shall be posting another question to follow on from this as I know you have answered this correctly. Thank you
</div>

<div>
<div class="content wysiwyg-content">
Hello 
I need to upload a csv file to php, parse the file and place the contents in a select element. I have tried various ways after searching google, but noting seems to work. This is new to me and would appreicate any help. 
 
I have the html done but struggling to cope with php parsing of the file and populating select. 
 
I would be grateful if someone could show me how to proceed with this as this would be my first time at handling this type of event. many thanks 
 
 

<pre><code class="code-10 nolinks" id="code-10-29018695-1">&lt;form enctype=&quot;multipart/form-data&quot; action=&quot;somepage.php&quot; method=&quot;post&quot; id=&quot;upload&quot;&gt; 
 &lt;table cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; width=&quot;500&quot; border=&quot;0&quot;&gt; 
 &lt;tr&gt; 
 &lt;td class=&quot;width&quot;&gt;&lt;label for=&quot;image&quot;&gt;Upload CSV file : &lt;/label&gt;&lt;/td&gt; 
 &lt;td&gt;&lt;input type=&quot;hidden&quot; name=&quot;MAX_FILE_SIZE&quot; value=&quot;10000000&quot; /&gt;
 &lt;input type=&quot;file&quot; name=&quot;csvfile&quot; id=&quot;csvfile&quot; value=&quot;&quot;/&gt;&lt;/td&gt; 
 &lt;td&gt;&lt;input type=&quot;submit&quot; name=&quot;uploadCSV&quot; value=&quot;Upload&quot; /&gt;&lt;/td&gt; 
 &lt;/tr&gt; 
 &lt;/table&gt; 
 &lt;/form&gt;
</code></pre>
</div>
</div>

Hello
I need to upload a csv file to php, parse the file and place the contents in a select element. I have tried various ways after searching google, but noting seems to work. This is new to me and would appreicate any help. 

I have the html done but struggling to cope with php parsing of the file and populating select. 

I would be grateful if someone could show me how to proceed with this as this would be my first time at handling this type of event. many thanks


(CODE)

How do I Import CSV File In my PHP Application

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.