Prikaz slike iz baze

[ trodon @ 19.04.2007. 23:29 ] @

Imamledecu stranicu povezanu s bazom:

Code:

<?php require_once('Connections/bilosta.php'); ?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_bilosta, $bilosta);
$query_Recordset1 = "SELECT * FROM oglasi";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $bilosta) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
  $all_Recordset1 = mysql_query($query_Recordset1);
  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table border="1">
  <tr>
    <td>oglas</td>
    <td>slika</td>
  </tr>
  <?php do { ?>
  <tr>
    <td><?php echo $row_Recordset1['oglas']; ?></td>
    <td><?php echo $row_Recordset1['slika']; ?></td>
  </tr>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

U koloni "slika" treba da mi se prikaze slika koja je u bazi. Shta treba da stavim u kod, da bi mi se slika stvarno i prikazala?

[ dimke7even @ 20.04.2007. 15:21 ] @

Morash u svakom slucaju u HTML kodu da imash tag <img> da bi ti se prikazala slika. Nisi nigde stavio taj tag.
Sada, ne znam da li u bazi cuvash samu sliku ili samo putanju do nje tj njen source.

Ja napr u bazi cuvam putanju do slike i tip slike tako da u html kodu pishem:

<img src="<?php echo $row["putanja_do_slike"]; ?>" type="<?php echo $row["tip_slike"] ?>">

ili samo <img src="<?php echo $row["putanja_do_slike"]; ?>" >

gde je $row["putanja_do_slike"]="sadrzaj\slike\nekaslika.gif" napr

a $row["tip_slike"]="image/gif"