|
|
 Pali - 2011-07-19 15:13:52 To try your system we need a sql dump. Can you upload it?
 Milind More - 2012-01-17 10:24:13 - In reply to message 1 from Pali1)add in your parameters in sample.php
$treeSample = new Treeview('localhost','username','password','database','table', 'primaryKeyField', 'titleField', 'parent_idField', 'perfixForJqueryIDs');
2)so it would be
like(add your hostname,username,password)
$treeSample = new Treeview('localhost','username','password','test','result', 'id', 'fullname', 'fullname', 'perfix');
3)use this dump (it's an example dump)
DROP TABLE IF EXISTS `test`.`result`;
CREATE TABLE `test`.`result` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fullname` varchar(45) DEFAULT NULL,
`mobile` varchar(45) DEFAULT NULL,
`marks` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
3)add some records
4)refresh the sample.php
 Mohammad Keramatifar - 2012-02-14 15:02:46 - In reply to message 1 from Palithe sql sample file is added:
CREATE TABLE IF NOT EXISTS `hk` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`parent_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `hk`
--
INSERT INTO `hk` (`id`, `title`, `parent_id`) VALUES
(1, 'Software', 0),
(2, 'Programming', 1),
(3, 'Web', 2),
(4, 'Windows', 2),
(5, 'Graphic', 1),
(6, 'Photoshop', 5),
(7, 'Freehand', 5),
(8, 'PHP', 3),
(9, 'ASP.NET', 3),
(10, 'Hardware', 0),
(11, 'Network', 0),
(12, 'Monitor', 10),
(13, 'LCD', 12),
(14, 'CRT', 12);
|
