Defafe

In this tutorial, I will give examples of the usage of bar chart by using extjs and php. Generally, bar chart consists of the x-axis and y-axis in this tutorial I will provide a case study about the number of sales in each month, the x-axis represents the name of the month, while the y-axis represents the total sales of each month.

we first create a database with the name of “chart” after that create a table with a “sale”, tables of contents consists of two columns of “month” and “sumOfsel”, for more details on the source code can be seen below.

CREATE TABLE IF NOT EXISTS `sale` (

 `month` int(11) NOT NULL,

 `sumOfsel` int(11) NOT NULL

) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

after create tables, enter data into a table, like the example below:

INSERT INTO `penjualan` (`month`, `sumOfsel`) VALUES

(0, 1400),

(2, 2000),

(3, 4000),

(4, 8000),

(0, 30000),

(1, 5000),

(5, 14686);

(more…)

In this section i want to share about how to make chart using extjs and php, this chart very sampel, i use pie chart and json to make it.

case study: in this tutorial I want to display the graph the number of visitors in a particular month.

create database: exmaple “chart” after that create table like this:

CREATE TABLE IF NOT EXISTS `testchart` (
 `name` varchar(100) NOT NULL,
 `visit` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

(more…)

On occasion this time I just want to introduce additional features in extjs 3, before I continue my  project “ Part 1: simple application of extjs using layout browser “, just the information that my project is using extjs 2.

Ok, we start this review. in extjs 3 there are some features that help us to develop a website. some fiture of extjs 3 are as follow.

1.  Form (custome spinner widget example, vbox layout with form).

2. Toolbars and Menus (toolbar buttons group, toolbars overflow, status bar update ).

3. Template and Data Views (ListView).

4. Drag and drop (filed to grid drag and drop).

5. Misscellaneous (editor, bubble panel, button, spotlight, debuging console).

6. Tree (treeGrid, check tree).

7. Charts (chart, pie chart, stacked bar chat, reloaded chart ).

8. Tabs (group tabs, tabpanel scroller menu).

9. Grid (progress bar pager, sliding pager, grouping with dynamic summary, buffered grid view, editable grid with writable store, grouping grid view extension, looking grid view extension ).

links this tutorial

I think this tutorial is easy, and maybe many programmer alredy know how to make it.

Main point of this tutorial is how to get file id in the grid. After that, we call the name of the file that we will to download.

In this section, we use the database from the previous tutorial: Upload file and image using extjs, so here we will try to download a file that was saved in the previous tutorial: upload file and image using extjs

(more…)