What i am trying to do upload and then check it before import into my database may be some field need to edit same have wrong (like phone email) for example ...
-----------------------------------------------------------
field 1 | field 2 | field 2 | field 2 | field 2 |
-----------------------------------------------------------
user1data |user1data |user1data |user1data |user1data |
------------------------------------------------------------
user2data |user2data |user2data |user2data |user2data |
----------------------------------------------------------
Now what i did i can upload and it directly upload csv into phpmyadmin .
but what i am tring to do after click upload there should temporary show user1data all data after check it will store in db then user2data come for verification and repeat same think..
here the code I used so far for import csv into db .
<?php
include 'db.php';
if(isset($_POST['submit']))
{
$file = $_FILES['file']['tmp_name'];
$handle = fopen($file, "r");
while(($fileop = fgetcsv($handle,1000,",")) !== false)
{
$IdCorresponsal = $fileop[0];
$NombreCorresponsal = $fileop[1];
$PaisCorresponsal = $fileop[2];
$ClaveValidacion = $fileop[3];
$IdGiro = $fileop[4];
$Fecha = $fileop[5];
$Hora = $fileop[6];
$Total = $fileop[7];
$Moneda = $fileop[8];
$ClavePago = $fileop[9];
$Nota = $fileop[10];
$NombreRte = $fileop[11];
$Apellido1Rte = $fileop[12];
$Apellido2Rte = $fileop[13];
$CiudadRte = $fileop[14];
$PaisRte = $fileop[15];
$TipoDocRte = $fileop[16];
$NumDocRte = $fileop[17];
$NombreBnf = $fileop[18];
$Apellido1Bnf = $fileop[19];
$Apellido2Bnf = $fileop[20];
$DireccionBnf = $fileop[21];
$CiudadBnf = $fileop[22];
$PaisBnf = $fileop[23];
$Telefono1Bnf = $fileop[24];
$Telefono2Bnf = $fileop[24];
$TipoDocBnf = $fileop[26];
$NumDocBnf = $fileop[27];
$IdOficina = $fileop[28];
$NombreOficina = $fileop[29];
$CodigoOficina = $fileop[30];
$PagoBanco = $fileop[31];
$NombreBanco = $fileop[32];
$DireccionBanco = $fileop[33];
$NumeroCuenta = $fileop[34];
$sql = mysql_query("INSERT INTO sampledata (IdCorresponsal,NombreCorresponsal,PaisCorresponsal,ClaveValidacion,IdGiro,Fecha,Hora,Total,Moneda,ClavePago,Nota,NombreRte,Apellido1Rte,Apellido2Rte,CiudadRte,PaisRte,TipoDocRte,NumDocRte,NombreBnf,Apellido1Bnf,Apellido2Bnf,DireccionBnf,CiudadBnf,PaisBnf,Telefono1Bnf,Telefono2Bnf,TipoDocBnf,NumDocBnf,IdOficina,NombreOficina,CodigoOficina,PagoBanco,NombreBanco,DireccionBanco,NumeroCuenta)
VALUES ('$IdCorresponsal','$NombreCorresponsal','$PaisCorresponsal','$ClaveValidacion','$IdGiro','$Fecha','$Hora','$Total','$Moneda','$ClavePago','$Nota','$NombreRte','$Apellido1Rte','$Apellido2Rte','$CiudadRte','$PaisRte','$TipoDocRte','$NumDocRte','$NombreBnf','$Apellido1Bnf','$Apellido2Bnf','$DireccionBnf','$CiudadBnf','$PaisBnf','$Telefono1Bnf','$Telefono2Bnf','$TipoDocBnf','$NumDocBnf','$IdOficina','$NombreOficina','$CodigoOficina','$PagoBanco','$NombreBanco','$DireccionBanco','$NumeroCuenta')");
}
if($sql)
{
echo 'Data upload done';
}
}
?>
<html>
<head>
<meta content="">
<title>Test</title>
</head>
<body>
<a href="data.php" > See report</a>
<form method="post" action="index.php" enctype="multipart/form-data">
<input type="file" name="file" />
<br>
<input type="submit" name="submit" value="sumbit" />
</form>
</body>
</html>