在csv插入phpmyadmin之前仔细检查我的数据 [英] double check my data before csv inserting into phpmyadmin
本文介绍了在csv插入phpmyadmin之前仔细检查我的数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我尝试上传然后在导入我的数据库之前检查它可能是某些字段需要编辑同样有错误（例如电话邮件）例如...
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 |
----------------------------------------------------------
现在我做了什么我可以上传，它直接将csv上传到phpmyadmin。
但是我点击上传后要做的事情应该是临时显示user1data所有数据，检查后它会存储在db中然后user2data来验证并重复同样的想法..
这里我到目前为止用于导入csv到db的代码。
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>
推荐答案
_POST [' submit']））
{
_POST['submit'])) {
file =
file =
_FILES [' file'] [' tmp_name'];
_FILES['file']['tmp_name'];
这篇关于在csv插入phpmyadmin之前仔细检查我的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
