hi everyone,
i write data from database to the csv file,but i face problem how to print the csv file with multiple colors background for example first line is green then second line must be blue,
please help me how can i do this in php
mehrantahir 0 Newbie Poster
linuxaomi 0 Newbie Poster
Did you say print ? To print on paper ?
I am doing the following: display HTML code on the screen and use CSS media=print.
(Sorry for the poor layout below)
echo'<style type="text/css" media="print">';
echo "TABLE {
border:1pt solid #000;
border-collapse:collapse;
font-family:arial,sans-serif;
font-size:90%;
background-color: red;
}
TD,TH{
border:1pt solid #000;
border-collapse:collapse;
white-space: nowrap;
font-size:90%;
text-align:center;
}";
echo'</style>';
echo "<div STYLE=' height: 257pt; font-size: 12pt; overflow: auto;'>";
echo "<TABLE BORDER=1 WIDTH='100%'>";
.
.
.
for ($i = 0; $i < $nrg88_num_rows; $i++)
{
$nrg88_row = mysql_fetch_row($nrg88_sql_result);
$nrg88_color = '#ffffff';
if ($i % 2 == 1)
{
$nrg88_color = '#eeeeee';
}
echo "<TR>";
$nrg88_col0[$i] = $nrg88_row[0];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col0[$i]</TD>";
$nrg88_col1[$i] = $nrg88_row[1];
echo "<TD style='width:15%; background-color:$nrg88_color;'>$nrg88_col1[$i]</TD>";
$nrg88_col2[$i] = $nrg88_row[2];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col2[$i]</TD>";
$nrg88_col3[$i] = $nrg88_row[3];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col3[$i]</TD>";
$nrg88_col4[$i] = $nrg88_row[4];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col4[$i]</TD>";
$nrg88_col5[$i] = $nrg88_row[5];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col5[$i]</TD>";
$nrg88_col6[$i] = $nrg88_row[6];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col6[$i]</TD>";
$nrg88_col7[$i] = $nrg88_row[7];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col7[$i]</TD>";
$nrg88_col8[$i] = $nrg88_row[8];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col8[$i]</TD>";
$nrg88_col9[$i] = $nrg88_row[9];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col9[$i]</TD>";
$nrg88_col10[$i] = $nrg88_row[10];
echo "<TD style='width:7.5%; background-color:$nrg88_color;'>$nrg88_col10[$i]</TD>";
echo "</TR>";
}
#echo "</TR>";
echo "</TABLE>";
echo "</div>";
Would be glad if this helps.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.