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…)

Today i will continue my previous tutorial about edit, delete file using extjs and php. And In this section we will learn about how to make function add file in extjs.

Below I only include a snippet from the sourcecode, for the full source code you can combine with the previous tutuorial.

(more…)

In this section, we will learn about how to  show data from database to grid form. In this post we need more file, on of is JSON.php, this file is very important, without  this file we can not  display data to grid form. And in this post we will also learn paging grid extjs.

(more…)

In this section, we will learn about how to make a simple form Extjs and how to change the Extjs theme, so that form looks nice. But before continuing, you must have an installer of Extjs, you can download the latest version of Extjs from its official site http://www.extjs.com/products/extjs/download.php. The latest version of Extjs was ext-2.2.1.

(more…)