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 | ?> |