<?php
session_start();
$baza = "baza1" ;
$ip_adresa = "localhost" ;
$us_baze = "root" ;
$ps_baze = "" ;
$konekcija = mysql_connect($ip_adresa,$us_baze,$ps_baze) or die("nije se uspostavila veza udaljeni MySQL A");
mysql_select_db ($baza,$konekcija) or die("nije otvorena baza");
$obrisi=mysql_query("delete from tabela1");
$fp = fopen("demo.txt", "r");
$i=0;
$k=0;
$b0 ='' ;
$b1 ='' ;
$b2 ='' ;
$b3 ='' ;
$b4 ='' ;
$b5 ='' ;
$b6 ='' ;
$b7 ='' ;
$b8 ='' ;
$b9 ='' ;
$b10 ='' ;
$b11 ='' ;
$b12 ='' ;
$b13 ='' ;
$b14 ='' ;
$b15 ='' ;
print "<table cellspacing=1 bgcolor=#000000>";
print "<tr>";
print "<td bgcolor=#ffffff>1</td>";
print "<td bgcolor=#ffffff>2</td>";
print "<td bgcolor=#ffffff>3</td>";
print "<td bgcolor=#ffffff>4</td>";
print "<td bgcolor=#ffffff>5</td>";
print "<td bgcolor=#ffffff>6</td>";
print "<td bgcolor=#ffffff>7</td>";
print "<td bgcolor=#ffffff>8</td>";
print "<td bgcolor=#ffffff>9</td>";
print "<td bgcolor=#ffffff>10</td>";
print "<td bgcolor=#ffffff>11</td>";
print "<td bgcolor=#ffffff>12</td>";
print "<td bgcolor=#ffffff>13</td>";
print "<td bgcolor=#ffffff>14</td>";
print "<td bgcolor=#ffffff>15</td>";
print "<td bgcolor=#ffffff>16</td>";
print "</tr>";
print "<tr>";
while (!feof($fp) )
{
if ($i <16)
{
$line = fgets($fp,2);
$slova[$i] =$line ;
print "<td bgcolor=#ffffff>$line</td>";
$i=$i+1;
}
else
{
print "</tr>";
print " <tr><td bgcolor=#ffffff colspan=16>brojac reda ". $k . "</td></tr>" ;
$k=$k+1 ;
$b0 =$slova[0] ;
$b1 =$slova[1] ;
$b2 =$slova[2] ;
$b3 =$slova[3] ;
$b4 =$slova[4] ;
$b5 =$slova[5] ;
$b6 =$slova[6] ;
$b7 =$slova[7] ;
$b8 =$slova[8] ;
$b9 =$slova[9] ;
$b10 =$slova[10] ;
$b11 =$slova[11] ;
$b12 =$slova[12] ;
$b13 =$slova[13] ;
$b14 =$slova[14] ;
$b15 =$slova[15] ;
$rez = mysql_query(" insert into tabela1 values (null,'" . $k . "','" . $b0 . "','" . $b1 . "','" . $b2 . "','" . $b3 . "','" . $b4. "','" . $b5 . "','" . $b6 . "','" . $b7 . "','" . $b8 . "','" . $b9 . "','" . $b10 . "','" . $b11 . "','" .$b12 . "','" . $b13 . "','" . $b14 . "','" . $b15 . "')") or die(mysql_error());
$i=0 ;
print "<tr>";
}
}
print "</table>";
fclose($fp);
?>