Jump to content

how to get and display array from *.csv


tetecko81sk

Recommended Posts

can help me somebody?

i am using db stored in csv file (ponuka.csv) and i want to display lines (arrays) by key (words in first row). i wrote code written under this text but every time i want to diplay data it display only first row data correctly others are wrong

HELP, PLEASE!

 

PONUKA.CSV:

row descriptions ->

Keys;Name;Description;1;2;3;4;5;6;Category   

bcap001;1aaa;aaaa;50;a;a;a;a;a;a;24
bcap002;2bbb;bbb;150;n;n;n;n;n;a;24
bcap003;3ccc;ccc;140;n;n;n;n;n;a;24

 

 

SCRIPT:

$file_handle = fopen("ponuka.csv", "r");

session_start();
session_name("hiphop_eShop_kosice");
if ($_SESSION["kosik"]){
$produkty = array_keys($_SESSION["kosik"]);
$pocet=count($produkty);

echo '
<table border=0 width=600>
<form action="index.php?cat=4" method="post" >
	<tr class="pmenu">
		<th width=70>Nahlad:</th><th width=260>Názov:</th><th width=100>Cena:</th><th width=50>Kusov:</th><th width=100>Celkom:</th></tr>';
$sumac=0;

for ($i=0; $i <= $pocet; $i++){
	$produkt=$produkty[$i];
	$kusov = $_SESSION["kosik"][$produkty[$i]];
	$riadok = fgetcsv($file_handle, 512, ";");

	if ($riadok[0] = $produkt AND $kusov>0){
		echo '
		if ($riadok[4]=="a"){
			$img[4]="tn_".$riadok[0]."_1.jpg";$riadok[4]=$riadok[0]."_1.jpg";
		} else {
			$riadok[4]="tn_nopict.png"; $img[4]="tn_nopict.png";
		}
		if (strlen($riadok[2])>35){$riadok[2]=substr($riadok[2],0,30)."...";}
		$suma=($riadok[3]*$kusov);
		echo '
	<tr class="'.$pzoznam.'">
		<td class="ponuka1" rowspan=2>
			<a href="index.php?cat='.$riadok[10].'&kod='.$riadok[0].'">
				<img src="images/'.$img[4].'"  width=50 border=0 /></a></td>
		<td class="ponuka2">
			<a href="index.php?cat='.$riadok[10].'&kod='.$riadok[0].'">
				<b>'.$riadok[1].'</b></a></td>
		<td class="ponuka4" rowspan=2>'.$riadok[3].' Sk</td>
		<td class="ponuka4" rowspan=2>'.$kusov.' ks</td>
		<td class="ponuka4" rowspan=2>'.$suma.' Sk</td></tr>
	<tr>
		<td class="ponuka2" height="30">'.$riadok[2].'</td></tr>';
		$sumac=$suma+$sumac;
	}
}
echo '<tr><td colspan=5><hr color=#CC0000 /></td></tr>';
echo '<tr><td colspan=4 class="ponuka4"><b>Suma celkom:</b></td><td class="ponuka4"><b>'.$sumac.' Sk</b></td></tr>';
echo '</form></table><br /><br />';
fclose($file_handle);
} else {
echo "<b>Košík je prázdny!</b>";
}

Link to comment
https://forums.phpfreaks.com/topic/45448-how-to-get-and-display-array-from-csv/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.