PHP Classes

Sql dump

Recommend this page to a friend!

      PHP TreeView  >  All threads  >  Sql dump  >  (Un) Subscribe thread alerts  
Subject:Sql dump
Summary:Sql dump is missed
Messages:3
Author:Pali
Date:2011-07-19 15:13:52
Update:2012-02-14 15:02:46
 

  1. Sql dump   Reply   Report abuse  
Picture of Pali Pali - 2011-07-19 15:13:52
To try your system we need a sql dump. Can you upload it?

  2. Sql dump   Reply   Report abuse  
Picture of Milind More Milind More - 2012-01-17 10:24:13 - In reply to message 1 from Pali
1)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

  3. Re: Sql dump   Reply   Report abuse  
Picture of Mohammad Keramatifar Mohammad Keramatifar - 2012-02-14 15:02:46 - In reply to message 1 from Pali
the 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);