View difference between Paste ID: DzhFY8NW and GpAhUhga
SHOW: | | - or go back to the newest paste.
1
<?php
2-
//konekcija do database
2+
$con = mysql_connect("localhost","USERNAME","SIFRA");
3-
$db_host = "localhost"; //obicno je localhost
3+
if (!$con)
4-
$db_username = "root";  //username za bazu
4+
  {
5-
$db_pass = "123456";  //password za bazu
5+
  die('Could not connect: ' . mysql_error());
6-
$db_name = "gamersbaza"; //ime baze
6+
  }
7
8
mysql_select_db("IMEBAZE", $con);
9-
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
9+
10-
mysql_select_db("$db_name") or die ("no database");             
10+
$result = mysql_query("SELECT * FROM igre ORDER BY id");
11
12-
?>
12+
while($row = mysql_fetch_array($result))
13-
<?php 
13+
  {
14-
           $row=mysql_fetch_array(mysql_query("SELECT * FROM igre ORDER BY id"));
14+
  echo $row['id'] . " " . $row['ime_igre']." " .$row['link_igre'];
15-
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
15+
  echo "<br />";
16-
$id = $row["id"]; // Ispis podataka
16+
  }
17-
$ime_igre= $row["ime_igre"]; // Ispis podataka
17+
18-
$link_igre = $row["link_igre"]; // Ispis podataka
18+
mysql_close($con);
19
?>