如何使用php显示上传的csv文件数据

Question

Currently I am doing a project in php for uploading CSV file and to insert data into database. Before inserting the data I need to display the data in table format.

I used this code for uploading and inserting the data.

if (isset($_POST['submit'])) 
{
$name = $_POST['camname'];
if (is_uploaded_file($_FILES['filename']['tmp_name'])) 
{
    echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
}

Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
    $import="INSERT into uploadmail(name,email) values('$name','$data[0]')";
    mysql_query($import) or die(mysql_error());
}

fclose($handle);
}

This coding successfully inserts the data into database but I need to display the data in table format.so please give any suggestions.

THANKS IN ADVANCE.

Answer 1

Just replace your code with this. Data will be save to DB and will be display as well. I added display data in table format code in your code.

if (isset($_POST['submit'])) 
{
$name = $_POST['camname'];
if (is_uploaded_file($_FILES['filename']['tmp_name'])) 
{
    echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
}

Import uploaded file to Database
$handle = fopen($_FILES['filename']['tmp_name'], "r");
echo "<table>
<tr><th>Name</th><th>Email</th></tr>";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
    echo "<tr>";
    $import="INSERT into uploadmail(name,email) values('$name','$data[0]')";

    echo "<td>".$name."</td><td>".$data[0]."</td>";
    mysql_query($import) or die(mysql_error());
    echo "</tr>";
}
echo "
</table>";
fclose($handle);
}