iCentar » Forum » Racunari i oprema » Programirannje i baze podataka » PHP » upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

#1

03.04.2018 12:13

Avko

Administrator

Registrovan od:28.05.2014
Postovi:4,812

Predmet:upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

index.html

PreuzmiIzvorni kôd (HTML):

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>PHP File Uploader</title>
<link href="boostrap/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="navbar navbar-default navbar-static-top">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index.php">PHP File Uploader</a>
</div>
</div>
</div>
<div class="container">
<div class="row">
<div class="col-lg-12">
<form class="well" action="upload.php" accept-charset="utf-8" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="file">Izaberi datoteku</label>
<input type="file" name="uploadFile" id="uploadFile" value="" />
<p class="help-block">Prihvaca se samo csv datozeka, max. velicine 1 MB.</p>
</div>
<input type="submit" class="btn btn-lg btn-primary" name="submitBtn" id="submitBtn" value="Upload" />
</form>
</div>
</div>
</div>
</body>
</html>

upload.php

PreuzmiIzvorni kôd (PHP):

<?php
//provjera greske
error_reporting(E_ALL);
ini_set('display_errors', 1);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_FILES['uploadFile']['name'];
$tmpName = $_FILES['uploadFile']['tmp_name'];
$error = $_FILES['uploadFile']['error'];
$size = $_FILES['uploadFile']['size'];
$ext = strtolower(pathinfo($name, PATHINFO_EXTENSION));
echo "<br>";
echo "ime: ".$name."<br>";
echo "tmpName: ".$tmpName."<br>";
echo "greska: ".$error."<br>";
echo "velicina: ".$size."<br>";
echo "nastavak: ".$ext."<br>";
switch ($error) {
case UPLOAD_ERR_OK:
$valid = true;
//validate file extensions
if ( !in_array($ext, array('csv')) ) {
$valid = false;
$response = 'Nedozvoljen tip datoteke.';
echo $response;
exit;
}
//validate file size
if ( $size/1024/1024 > 2 ) {
$valid = false;
$response = 'Velicina datoteke premasuje dozvoljenu velicinu.';
}
//upload file
if ($valid) {
// $targetPath = dirname( __FILE__ ) . DIRECTORY_SEPARATOR. 'uploads' . DIRECTORY_SEPARATOR. $name;
// move_uploaded_file($tmpName,$targetPath);
// header( 'Location: index.php' ) ;
// exit;
$response = 'Datoteka ispravna.';
}
break;
case UPLOAD_ERR_INI_SIZE:
$response = 'The uploaded file exceeds the upload_max_filesize directive in php.ini.';
break;
case UPLOAD_ERR_PARTIAL:
$response = 'The uploaded file was only partially uploaded.';
break;
case UPLOAD_ERR_NO_FILE:
$response = 'No file was uploaded.';
break;
case UPLOAD_ERR_NO_TMP_DIR:
$response = 'Missing a temporary folder. Introduced in PHP 4.3.10 and PHP 5.0.3.';
break;
case UPLOAD_ERR_CANT_WRITE:
$response = 'Failed to write file to disk. Introduced in PHP 5.1.0.';
break;
default:
$response = 'Unknown error';
break;
}
echo $response;
}
//
,Å¾,Å¡ slova
$row = 1;
if (fopen($_FILES['uploadFile']['tmp_name'], "r")) {
$handle=fopen($_FILES['uploadFile']['tmp_name'], "r");
//pokazi vrstu utf-a
$encoding = mb_detect_encoding($tmpName , 'UTF-8, UTF-7, ASCII, EUC-JP,SJIS, eucJP-win, SJIS-win, JIS, ISO-2022-JP');
echo "<br>"."Vrsta utf-a:".$encoding;
$output = '<table border="1">';
while( ($data = fgetcsv( $handle )) !== false ){
$output .= '<tr>';
foreach( $data as $value )
{
$output .= sprintf( '<td>%s</td>', $value );
}
$output .= '</tr>';
}
fclose( $handle );
$output .= '</table>';
}
echo $output;
?>

ucitam csv datoteku ali mi u tabli ne pokazuje slova č,Å¾,Å¡

Dali ste imali vi taj problem i kako ste ga rijesili?

Prilozi:

proba.rar
Preuzimanja:363
Velicina datoteke:160 Bajt

zivot je moja domovina.

Ovaj post je ureden 2 puta. Posljednja izmjena 04.04.2018 13:53 od strane Avko.

#2

03.04.2018 14:27

Gjoreski

Administrator

Registrovan od:02.02.2009
Postovi:1,854

Predmet:Re: otvaranje datoteke sa č,Å¾,Å¡ slovima

Ne znam u php ali imao sam par problema sa znakova u ceskoj ja sam to resio tako sta sam napravio tabeli koi imaju kodna strana latin2 i tako sad vec nemam problema sa ceski znakova.

#3

04.04.2018 09:40

Avko

Administrator

Registrovan od:28.05.2014
Postovi:4,812

Predmet:Re: otvaranje datoteke sa č,Å¾,Å¡ slovima

Nasao gresku.

Znaci, nije uopce trebalo dekodirati i kodirati i sta ti ja znam. Trebalo je samo staviti na pocetku datoteke upload.php ovo:

echo "<META http-equiv='Content-Type' content='text/html; charset=UTF-8'>";

sada vidim nasa slova normalno u tabeli.

zivot je moja domovina.

#4

04.04.2018 09:45

zxz

Administrator

Registrovan od:03.02.2009
Postovi:10,644

Predmet:Re: otvaranje datoteke sa č,Å¾,Å¡ slovima

Stavi probaj ovako:
form class="well" action="upload.php" accept-charset="Windows-1250" method="post" enctype="multipart/form-data">

Ja obicno to stavim na pocetku htmla.
<head>
<meta charset="Windows-1250"/>

Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.

#5

04.04.2018 09:49

zxz

Administrator

Registrovan od:03.02.2009
Postovi:10,644

Predmet:Re: otvaranje datoteke sa č,Å¾,Å¡ slovima

PreuzmiIzvorni kôd (HTML):

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="windows-1250">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>PHP File Uploader</title>
<link href="boostrap/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="navbar navbar-default navbar-static-top">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index.php">PHP File Uploader</a>
</div>
</div>
</div>
<div class="container">
<div class="row">
<div class="col-lg-12">
<form class="well" action="upload.php" accept-charset="windows-1250" method="post" enctype="multipart/form-data">
<div class="form-group">
<label for="file">Izaberi Å¡
Å¾Å¾datoteku</label>
<input type="file" name="uploadFile" id="uploadFile" value="" />
<p class="help-block">Prihvaca se samo csv datozeka, max. velicine 1 MB.</p>
</div>
<input type="submit" class="btn btn-lg btn-primary" name="submitBtn" id="submitBtn" value="Upload" />
</form>
</div>
</div>
</div>
</body>
</html>

Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.

#6

04.04.2018 13:36

Avko

Administrator

Registrovan od:28.05.2014
Postovi:4,812

Predmet:Re: otvaranje datoteke sa č,Å¾,Å¡ slovima

dobro zxz, probat cu i sa time.

evo sada pojednostavljeno sve, radi.

index.html

PreuzmiIzvorni kôd (HTML):

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="windows-1250">
<title>Upload csv datoteke</title>
</head>
<body>
<form class="well" action="upload.php" accept-charset="Windows-1250" method="post" enctype="multipart/form-data">
<label for="file">Izaberi datoteku:</label>
<input type="file" name="uploadFile" id="uploadFile" value="" />
<p class="help-block">Prihvaca se samo csv datozeka, max. velicine 1 MB.</p>
<input type="submit" class="btn" name="submitBtn" id="submitBtn" value="Upload" />
</form>
</body>
</html>

upload.php

PreuzmiIzvorni kôd (PHP):

<?php
echo "<META http-equiv='Content-Type' content='text/html; charset=UTF-8'>";
//moguce greske
error_reporting(E_ALL);
ini_set('display_errors', 1);
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$name = $_FILES['uploadFile']['name'];
$tmpName = $_FILES['uploadFile']['tmp_name'];
$error = $_FILES['uploadFile']['error'];
$size = $_FILES['uploadFile']['size'];
$ext = strtolower(pathinfo($name, PATHINFO_EXTENSION));
switch ($error) {
case UPLOAD_ERR_OK:
$valid = true;
//validate file extensions
if ( !in_array($ext, array('csv')) ) {
$valid = false;
$response = 'Nedozvoljen tip datoteke.';
echo $response;
exit;
}
//validate file size
if ( $size/1024/1024 > 2 ) {
$valid = false;
$response = 'File size is exceeding maximum allowed size.';
}
//upload file
if ($valid) {
// $targetPath = dirname( __FILE__ ) . DIRECTORY_SEPARATOR. 'uploads' . DIRECTORY_SEPARATOR. $name;
// move_uploaded_file($tmpName,$targetPath);
// header( 'Location: index.php' ) ;
// exit;
$response = 'Datoteka je ucitana.';
}
break;
case UPLOAD_ERR_INI_SIZE:
$response = 'Velicina datoteke je veca od dozvoljene.';
break;
case UPLOAD_ERR_PARTIAL:
$response = 'The uploaded file was only partially uploaded.';
break;
case UPLOAD_ERR_NO_FILE:
$response = 'Datoteka nije ucitana.';
break;
case UPLOAD_ERR_NO_TMP_DIR:
$response = 'Nedostaje TMP folder. Introduced in PHP 4.3.10 and PHP 5.0.3.';
break;
default:
$response = 'Nepoznata greska';
break;
}
echo $response."<br>";
echo "informacije o datoteci:";
echo "<li>ime: ".$name."</li>";
echo "<li>tmpName: ".$tmpName."</li>";
echo "<li>greska: ".$error."</li>";
echo "<li>velicina: ".$size."</li>";
echo "<li>nastavak: ".$ext."</li>";
}
//stavljamo cijelu datoteku u matricu
$csv = array();
$file = fopen($_FILES['uploadFile']['tmp_name'], 'r');
while (($result = fgetcsv($file)) !== false){
$csv[] = $result;
}
fclose($file);
$ukupnoRedova=count($csv);
$ukupnoKolona= max( array_map( 'count', $csv ) );
echo "<br>CSV datoteka je ucitana u matricu<br>";
echo "<li>ukupno redova: ".$ukupnoRedova."</li>";
echo "<li>max. kolona: ".$ukupnoKolona."</li>";
echo "<br>Ispis matrice u tabeli";
echo '<tbody><table border="1">';
for ($row = 1; $row < $ukupnoRedova; $row++) {
echo "<tr>";
for ($col = 0; $col < $ukupnoKolona; $col++) {
//ako celija nema vrijednost onda upisemo null da ne pise Undefined offset:
if ( ! isset($csv[$row][$col])) {
$csv[$row][$col] = null;
}
echo "<td>".$csv[$row][$col]."</td>";
}
echo "</tr>";
}
echo '</table></tbody>';
ini_set('auto_detect_line_endings',FALSE);
?>

kako to izgleda kod mene:

zivot je moja domovina.

Ovaj post je ureden 4 puta. Posljednja izmjena 04.04.2018 13:50 od strane Avko.

#7

04.04.2018 19:05

zxz

Administrator

Registrovan od:03.02.2009
Postovi:10,644

Predmet:Re: upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

netreba ti ovo.
Znas li kako izgleda tvoja html stranica.

Citat:

<?php
echo "<META http-equiv='Content-Type' content='text/html; charset=UTF-8'>";

Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.

#8

04.04.2018 19:37

Avko

Administrator

Registrovan od:28.05.2014
Postovi:4,812

Predmet:Re: upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

ako to ne stavi ne napise mi č Å¡Å¾. to je php. datoteka

zivot je moja domovina.

#9

08.04.2018 22:10

zxz

Administrator

Registrovan od:03.02.2009
Postovi:10,644

Predmet:Re: upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

Da ali sto to saljes iz php kada mozes staviti u html.
Ako hoces mozemo pokrenuti temu kako napraviti cms.
Sve sto je staticko treba se nalaziti u html.
html moze biti i iz vise diojelova.

Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.

#10

09.04.2018 08:43

Avko

Administrator

Registrovan od:28.05.2014
Postovi:4,812

Predmet:Re: upload file, stavi u array, ispisi u tabelu sa č,Å¾,Å¡ slovima

Citiraj zxz:

Da ali sto to saljes iz php kada mozes staviti u html.
Ako hoces mozemo pokrenuti temu kako napraviti cms.
Sve sto je staticko treba se nalaziti u html.
html moze biti i iz vise diojelova.

Nista te nisam razumio, sta je to cms?

-Å¡aljem csv file
-stavljam ga u array
-ispisujem u tabli

a onda sam mislio poslati taj array u bazu

zivot je moja domovina.

Stranice (1):1

Centar za edukaciju-BiH

Glavni meni

Forumi

Linkovi

iCentar → Racunari i oprema → Programirannje i baze podataka → PHP

Srodne teme

Ko je online?

Prijavi se

Izdvojeno