Predmet:Re: csv u bazu
napredovo jesam ali nisam uspio rijesii sljedeci problem.
sada IMPORT izgleda ovako:
html za import:
PreuzmiIzvorni kôd (Text):<table class="buttons width-25">
<tr>
<td>
<p>1. Tehnicar racunarstva</p>
</td>
<td>
<input id="file-upload" type="file" />
<label class="buttons custom" for="file-upload">IZABERI FILE</label>
</td>
<td>
<form method="post" enctype="multipart/form-data">
<button type="submit" class="buttons submit" name="submit" value="submit">UPLOAD</button>
</form>
</td>
</tr>
<tr>
<td>
<p>2. Tehnicar elektronike</p>
</td>
<td>
<input id="file-upload" type="file" />
<label class="buttons custom" for="file-upload">IZABERI FILE</label>
</td>
<td>
<form method="post" enctype="multipart/form-data">
<button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD </button>
</form>
</td>
</tr>
<tr>
<td>
<p>3. Tehnicarelektro-energetike</p>
</td>
<td>
<input id="file-upload" type="file" />
<label class="buttons custom" for="file-upload">IZABERI FILE</label>
</td>
<td>
<form method="post" enctype="multipart/form-data">
<button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD </button>
</form>
</td>
</tr>
<tr>
<td>
<p>4. Tehnicar mehatronike</p>
</td>
<td>
<input id="file-upload" type="file" />
<label class="buttons custom" for="file-upload">IZABERI FILE</label>
</td>
<td>
<form method="post" enctype="multipart/form-data">
<button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD</button>
</form>
</td>
</tr>
<tr>
<td>
<p>5. Elektricar </p>
</td>
<td>
<input id="file-upload" type="file" />
<label class="buttons custom" for="file-upload">IZABERI FILE</label>
</td>
<td>
<form method="post" enctype="multipart/form-data">
<button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD</button>
</form>
</td>
</tr>
</table>
PreuzmiIzvorni kôd (Text):[color=#33CC66]table {
width: 100%;
border-collapse: collapse;
}
table td {
border: 1px solid black;
}
.width-25 td {
width: 15%;
/* sakriti crte kolona */
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
.width-25 input[type="file"], input[type="submit"] {
display: none;
}[/color]
u function.php fajlu imam kod koji provjerava dali je pritisnut button UPLOAD name="submit"
PreuzmiIzvorni kôd (Text):[color=#FF0066]if(isset($_POST["submit"])){
$filename=$_FILES["file"]["tmp_name"];
if($_FILES["file"]["size"] > 0)
{
$file = fopen($filename, "r");
while (($getData = fgetcsv($file, 10000, ",")) !== FALSE)
{
$sql = "INSERT into racunarstvo (imePrezime,email)
values ('".$getData[0]."','".$getData[1]."')";
$result = mysqli_query($con, $sql);
if(!isset($result))
{
echo "<script type=\"text/javascript\">
alert(\"Invalid File:Please Upload CSV File.\");
window.location = \"index.php\"
</script>";
}
else {
echo "<script type=\"text/javascript\">
alert(\"CSV File has been successfully Imported.\");
window.location = \"index.php\"
</script>";
}
}
fclose($file);
}
} [/color]
problem je u sljedecem:
-kada izaberem csv fajl za upload , nigdje mi ne napise koji sam fajl pripremio za upload.
to za sada pa kad to rijesim onda cemo do import u table
Prilozi:
01_web_oop_icentar.zip
Preuzimanja:198
Velicina datoteke:36.45 KB
zivot je moja domovina.
Ovaj post je ureden
3
puta. Posljednja izmjena 27.05.2020 18:55 od strane Avko.