TRAJKO41
3.9.2009, 21:33
Imam u bazi napravljenu tabelu products koja sadrzi objekat sliku
tabela izgleda ovako
CREATE TABLE IF NOT EXISTS `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`description` varchar(5000) NOT NULL DEFAULT '',
`price` float(8,2) NOT NULL DEFAULT '0.00',
`on_special` tinyint(4) NOT NULL DEFAULT '0',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`picture` text NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
naravno imam
INSERT INTO `products` (`id`, `name`, `description`, `price`, `on_special`, `timestamp`, `picture`) VALUES
(6, 'Ardo frizider MP 34SH', Ardo frizider MP 34SH'', 33239.00, 0, '2009-05-10 13:58:41', 'Ardo MP 34SH.jpg');
e sada imam php fajl product details.php
u kome hocu da odstampam ovu sliku
ali da bude za svaki id odgovarajuca slika, ovde gore sam naveo primer za id 6 a ja hocu kad ima vise proizvoda
kod fajla products.php izgleda ovako
<?php if (! $prod) { ?>
<h2>Product not found</h2>
<blockquote class="normal">
Sorry, the product you are looking for was not found on file. Please try
our <a href="<?=$CFG->wwwroot?>/shopping">shopping catalog</a>
to find what you are looking for.
</blockquote>
<?php return false; ?>
<?php } ?>
<div class="normal"><?php print_category_tree($prod->category_id, $prod->category_id) ?> :
<p class="h1"><?php pv($prod->name) ?></p>
<blockquote class="normal">
<?php pv($prod->description) ?>
<p>
<table>
<tr>
<td class="label">Cena:</td>
<td class="normal"><?php print_price($prod->price) ?></td>
/*ovde bih hteo da odstampam sliku za odgovarajuci id*/
</tr>
</table>
<p><a href="cart_add.php?id=<?php pv($prod->id)?>"><img src="<?php pv($CFG->icondir)?>/buy.gif" width="75" height="25" vspace="5" border="0" alt="Buy"></a>
<base target="_blank" />
<a href="slika.php?id=<?php pv($prod->id)?>"><img src="<?php pv($CFG->icondir)?>/picture.gif" width="75" height="25" vspace="5" border="0" >
</blockquote>
Ako neko zna neka pomaze, ne ide mi nesto najbolje php :(
Pozdrav
tabela izgleda ovako
CREATE TABLE IF NOT EXISTS `products` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`description` varchar(5000) NOT NULL DEFAULT '',
`price` float(8,2) NOT NULL DEFAULT '0.00',
`on_special` tinyint(4) NOT NULL DEFAULT '0',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`picture` text NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
naravno imam
INSERT INTO `products` (`id`, `name`, `description`, `price`, `on_special`, `timestamp`, `picture`) VALUES
(6, 'Ardo frizider MP 34SH', Ardo frizider MP 34SH'', 33239.00, 0, '2009-05-10 13:58:41', 'Ardo MP 34SH.jpg');
e sada imam php fajl product details.php
u kome hocu da odstampam ovu sliku
ali da bude za svaki id odgovarajuca slika, ovde gore sam naveo primer za id 6 a ja hocu kad ima vise proizvoda
kod fajla products.php izgleda ovako
<?php if (! $prod) { ?>
<h2>Product not found</h2>
<blockquote class="normal">
Sorry, the product you are looking for was not found on file. Please try
our <a href="<?=$CFG->wwwroot?>/shopping">shopping catalog</a>
to find what you are looking for.
</blockquote>
<?php return false; ?>
<?php } ?>
<div class="normal"><?php print_category_tree($prod->category_id, $prod->category_id) ?> :
<p class="h1"><?php pv($prod->name) ?></p>
<blockquote class="normal">
<?php pv($prod->description) ?>
<p>
<table>
<tr>
<td class="label">Cena:</td>
<td class="normal"><?php print_price($prod->price) ?></td>
/*ovde bih hteo da odstampam sliku za odgovarajuci id*/
</tr>
</table>
<p><a href="cart_add.php?id=<?php pv($prod->id)?>"><img src="<?php pv($CFG->icondir)?>/buy.gif" width="75" height="25" vspace="5" border="0" alt="Buy"></a>
<base target="_blank" />
<a href="slika.php?id=<?php pv($prod->id)?>"><img src="<?php pv($CFG->icondir)?>/picture.gif" width="75" height="25" vspace="5" border="0" >
</blockquote>
Ako neko zna neka pomaze, ne ide mi nesto najbolje php :(
Pozdrav