Sådan koder du et taglib i PHP
Denne linies kode skal du så bare tilføje til din PHP side
<?php
require_once(HTML_DB_SELECT_VIEW_PATH.'/ViewSelect.php');
ViewSelect::display();
?>
Først skal du definere tabellens felter i mySQL
Dette SQL skal du benytte for at oprette tabellen i mySQL
<?
CREATE TABLE IF NOT EXISTS `demo_select` (
`demo_select_id` int(11) not null auto_increment,
`demo_session_id` varchar(32) not null,
`name` varchar(100) not null DEFAULT '',
`label` varchar(100) DEFAULT '',
`value` varchar(100) DEFAULT '',
`text` varchar(100) DEFAULT '',
`selected` enum('Y','N') not null DEFAULT 'N',
`created_date` datetime not null DEFAULT '2011-11-16 23:14:42',
`modified_date` datetime not null DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`demo_select_id`),
KEY `demo_select_demo_session_id_fk` (`demo_session_id`)
) ENGINE=MyISAM COMMENT='SqlCreateTable::get(table, fields, engine, comment)'
?>
Dette SQL skal du benytte for at indsætte nogle test data i tabellen i mySQL
<?
INSERT INTO `demo_select` ( `demo_session_id`,`name`,`label`,`value`,`text`,`selected`,`created_date`,`modified_date` ) VALUES
('5cb3a39002cf9566f2ba763dbce8ef96','SELECT_NETBANK_TO_ACCOUNT','','1','Vælg ...','y','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','SELECT_NETBANK_TO_ACCOUNT','privat','2','0735 0123784669 Finns lommepenge','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','SELECT_NETBANK_TO_ACCOUNT','privat','3','0735 0123784677 Opsparing','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','SELECT_NETBANK_TO_ACCOUNT','erhverv','4','0735 0123784677 Udlands konto','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','SELECT_NETBANK_TO_ACCOUNT','erhverv','5','0735 0123784677 Erhvervs konto','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','filial','fyn','6','Odense city','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','saveInCreditorRegister','saveInCreditorRegister','saveInCreditorRegister','Gem i kreditorregister','','20111117001442','20111117001442'),
('5cb3a39002cf9566f2ba763dbce8ef96','sendRecipt','sendRecipt','sendRecipt','Kvittering ønskes tilsendt','','20111117001442','20111117001442')
?>
Komponenten: myphp-1.11-db-select
Komponenten: myphp-1.11-db-select består af de følgende komponenter:
For at se den fulde kildekode for komponenter, så kan du klikke på nedestående links
|
