0) { konekcija(); } else { echo "Error while editing...
"; } } else { konekcija(); } } else if ($_GET["action"] == 3) { // Brisanje $delete=$_GET["action1"]; mysql_query("DELETE FROM mydvds WHERE id='$delete'") or sqlerr(__FILE__, __LINE__); if(mysql_affected_rows()>0) { konekcija(); } else { echo "Error while deleting...
"; } } else if ($_GET["action"] == 4) { // Editiranje $edit=$_GET["action1"]; $query=mysql_query("SELECT * FROM mydvds WHERE id='$edit'") or sqlerr(__FILE__, __LINE__); $arr_edit=mysql_fetch_assoc($query); echo "
Edited:

"; echo ""; $buffer1 = $arr_edit[title].$arr_edit[year].$arr_edit[genre].$arr_edit[dvdnumber]; echo ""; echo ""; echo "

Image	Title	Year	Genre	DVD#
	$arr_edit[title]	$arr_edit[year]	$arr_edit[genre]	$arr_edit[dvdnumber]

"; } else if ($_GET["action"] == 5) { // Potvrda brisanja echo "
Potvrda brisanja

"; $delete=$_GET["action1"]; $query=mysql_query("SELECT * FROM mydvds where id='$delete'") or sqlerr(__FILE__, __LINE__); $arr_del=mysql_fetch_assoc($query); echo ""; echo "

Image	Title	Year	Genre	DVD#	Really delete?
	$arr_del[title]	$arr_del[year]	$arr_del[genre]	$arr_del[dvdnumber]	Yes / No

"; } else if(!$_GET["action"]) { konekcija(); } /** Ispis iz baze **/ function konekcija() { if(isset($_GET['currentPage'])) { $currentPage = $_GET['currentPage']; } else { $currentPage=1; } $query=mysql_query("SELECT * FROM mydvds") or sqlerr(__FILE__, __LINE__); //$arr=mysql_fetch_assoc($query); $itemNum=mysql_numrows($query); $pageLimit = 15; $nextPage = $currentPage+1; $prevPage = $currentPage-1; $pageNum = ceil($itemNum/$pageLimit); echo "
Go Back"; echo "Items = ".$itemNum.". Pages = ".$pageNum."

"; echo ""; if($currentPage<$pageNum) { for($i=(($currentPage-1)*$pageLimit); $i<($currentPage*$pageLimit); $i++) { $query1=mysql_query("SELECT * FROM mydvds ORDER BY title LIMIT ".$i.", ". $pageLimit ."") or sqlerr(__FILE__, __LINE__); $arr=mysql_fetch_assoc($query1); echo ""; }// End For } else { for ($i=(($currentPage-1)*$pageLimit); $i < $itemNum; $i++) { $query2=mysql_query("SELECT * FROM mydvds ORDER BY title LIMIT ".$i.", ". $pageLimit ."") or sqlerr(__FILE__, __LINE__); $arr=mysql_fetch_assoc($query2); echo ""; }// End For } echo "

Image	Title	Year	Genre	DVD#	Edit	Delete
	$arr[title]	$arr[year]	$arr[genre]	$arr[dvdnumber]	Edit	Delete
	$arr[title]	$arr[year]	$arr[genre]	$arr[dvdnumber]	Edit	Delete

"; if($_GET['currentPage'] == 1 || $_GET['currentPage'] == "") { echo "

Previous -

Page ".$currentPage." / ".$pageNum."

- Next

"; } else if($_GET['currentPage'] == $pageNum) { echo "

Previous -

Page ".$currentPage." / ".$pageNum."

- Next

"; } else { echo "

Previous -

Page ".$currentPage." / ".$pageNum."

- Next

"; } }// End of konekcija(); echo "
Go UP
"; mysql_close(); ?>