Shorty1968
Erfahrenes Mitglied
Hallo ich möchte mir für meinen Shop ein MODUL erstellen mit einem PHP select Feld,dazu habe ich in die DB folgendes eingetragen.
in die PHP Datei:
ins smartyTemplate.
Aber es wird im Admin Zwar das selct Feld angezeigt,aber keine auswahl was habe ich Falsch gemacht?
SQL:
CREATE TABLE `price_text` (
`price_text_id` INT(5) NOT NULL,
`language_id` INT(5) NOT NULL,
`price_text` VARCHAR(50) COLLATE latin1_german1_ci NOT NULL,
PRIMARY KEY (`price_text_id`,`language_id`)
);
ALTER TABLE `price` ADD `price_text_id` INT(5) NOT NULL ;
INSERT INTO `price_text` (`price_text_id`,`language_id`,`price_text`) VALUES (0,2,'ab ');
INSERT INTO `price_text` (`price_text_id`,`language_id`,`price_text`) VALUES (1,2,'All Inkl ');
INSERT INTO `price_text` (`price_text_id`,`language_id`,`price_text`) VALUES (2,2,'Preis pro Std ');
INSERT INTO `price_text` (`price_text_id`,`language_id`,`price_text`) VALUES (3,2,'Komplett Preis ');
PHP:
function productSpecialsText ($products_id) {
$price_text = array();
$price_text = xtc_db_fetch_array(xtDBquery( "SELECT " . TABLE_PRICE_TEXT . ".price_text
FROM " . TABLE_PRICE_TEXT . " LEFT JOIN " . TABLE_PRICE . "
ON " . TABLE_PRICE_TEXT . ".price_text_id = " . TABLE_PRICE . ".price_text_id
WHERE " . TABLE_PRICE_TEXT . ".language_id = " . $_SESSION['languages_id'] . "
AND " . TABLE_PRICE . ".products_id = ".$products_id ));
if (strtolower($_SESSION['language_charset']) !== 'utf-8') $price_text['price_text'] = htmlentities ($price_text['price_text'], ENT_QUOTES, strtoupper($_SESSION['language_charset']),false);
return $price_text['price_text'];
}
Code:
<tr>
<td class="main"><?php echo TEXT_PRICE_PRICE_TEXT; ?>: </td>
<td class="main"><?php echo xtc_draw_pull_down_menu('text_special_price_text',$price_text_input,$price_text_selected); ?></td>
</tr>