PDA

View Full Version : Help column tree, PHP - MySql



idaelmis
15 Oct 2009, 2:07 PM
I am dabbling in community work with Ext JS and I loaded into a column tree data from a table in MySql I want it like this example http://www.extjs.com/deploy/dev/examples/tree/column-tree.html

Greetings and I hope for your help
:-/


CREATE TABLE `estudiante` (
`id_est` int(11) NOT NULL auto_increment,
`nombre` varchar(50) NOT NULL,
`apellido_a` varchar(50) NOT NULL,
`apellido_b` varchar(50) NOT NULL,
`ci` varchar(11) NOT NULL,
`edad` int(2) NOT NULL,
`sexo` varchar(50) NOT NULL,
`direccion` varchar(100) NOT NULL,
`pais` varchar(100) NOT NULL,
PRIMARY KEY (`id_est`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Volcar la base de datos para la tabla `estudiante`
--

INSERT INTO `estudiante` (`id_est`, `nombre`, `apellido_a`, `apellido_b`, `ci`, `edad`, `sexo`, `direccion`, `pais`) VALUES
(1, 'Alexander', 'Chavez', 'Ruiz', '85092610921', 24, 'masculino', 'Colon', 'Cuba'),
(2, 'Lazaro Martin', 'Ordoņez', 'Peņalver', '85092610921', 24, 'Masculino', 'calimete', 'Cuba'),
(3, 'Caridad', 'Perez', 'Diaz', '70041045263', 39, 'Femenino', 'Juarez', 'Mexico');

jay@moduscreate.com
19 Oct 2009, 4:19 AM
what exactly do you need help on? We're not going to write the entire app for you

idaelmis
19 Oct 2009, 4:56 PM
I have implemented my class ke student what not to be related to ExtJs

var tree = new Ext.tree.ColumnTree({
width: 550,
height: 300,
rootVisible:false,
autoScroll:true,
title: 'Example Tasks',
renderTo: Ext.getBody(),

columns:[{
header:'Task',
width:330,
dataIndex:'task'
},{
header:'Duration',
width:100,
dataIndex:'duration'
},{
header:'Assigned To',
width:100,
dataIndex:'user'
}],

loader: new Ext.tree.TreeLoader({
dataUrl:'column-data.json',
uiProviders:{
'col': Ext.tree.ColumnNodeUI
}
}),

root: new Ext.tree.AsyncTreeNode({
text:'Tasks'
})
});

jay@moduscreate.com
20 Oct 2009, 1:31 AM
I'm still not getting what you're looking for.