Predmet:Re: Warning: mysql_fetch_assoc() expects...
evo konacnog koda koji radi (oba fajla)
1. config.php fajl (povezuje se na bazu podataka na serveru)
PreuzmiIzvorni kôd (PHP):<?php
$servername='127.0.0.1'; // Your MySql Server Name or IP address here
$dbusername='root'; // Login user id here
$dbpassword=''; // Login password here
$dbname='fm_db'; // Your database name here
//connection to the database
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
if(!$link){die("Could not connect to MySQL");}
}
?>
[/php]
[b]2. index.php fajl[/b] (prikazuje podatke iz tabele igraci po stranicama)
[php]
<?php
//connection to the database
require 'config.php';
//max display per page
$per_page = 20;
//get start variable
if(isset($_GET['start'])){
$start = $_GET['start'];
}else{
$start = 0;
}
//count records
echo "U bazi je $record_count igraca<br />";
//count max pages
$max_pages = $record_count / $per_page; //may come out decimal
echo "Bice prikazanu ukupno $max_pages strana u tabeli<br />";
echo "<br />";
if (!$start)
$start = 0;
//display data
$get = mysql_query("SELECT *FROM igraci LIMIT $start, $per_page");
{
//get data
$id = $row['ID'];
$naziv = $row['Ime'];
$zemlja = $row['Zemlja'];
$Pozicija = $row['Pozicija'];
$Godine = $row['Godine'];
$Visina = $row['Visina'];
$Tezina = $row['Tezina'];
echo "$id $naziv $zemlja $Pozicija $Godine $Visina cm $Tezina kg<br /> ";
}
//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;
//shov prev button
If (!($start<=0))
echo " <a href='index.php?start=$prev'>Predhodno</a> ";
//shov page number
//set variable for first page
$i=1;
for($x=0;$x<$record_count;$x=$x+$per_page)
{
if($start!=$x)
echo " <a href='index.php?start=$x'>$i</a> ";
else
echo " <a href='index.php?start=$x'><b>$i</b></a> ";
$i++;
}
//shov next button
if(!($start>=$record_count-$per_page))
echo " <a href='index.php?start=$next'>Dalje</a> ";
?>
Pitanje:
Zna li neko kako da stranice budu prikazane u obliku "Predhodna 1 2 3 4 5 ... 114 115 sledeca" ? nije hitno
Ovaj post je ureden
1
puta. Posljednja izmjena 01.09.2010 23:57 od strane laponac84.