Posts Tagged ‘MySQL’

revision : upload file and image

Wednesday, February 3rd, 2010

I am sorry when I check back my previous tutorial on uploading files and images, there are some mistakes that should be fixed in its database, and there are some parts that I have not explained clearly. Now I will try to explain again some of which I consider important.

  1. On these tutorials you can only upload image files that have extensions gif,  jpeg and png. if you upload a file extension other than the image file, the file will not be able to upload or error.
  2. create a folder image and article to store files uploaded.

download this sourcecode , demo this application

form-upload-extjs

Create bar chart using extjs and php

Sunday, January 31st, 2010

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

Tutorial Extjs: Grouping

Friday, February 13th, 2009

I hope this day is a nice day for you and your family, ang  i hope you still hold to the spirit of learning. Now let’s continue this tutorial, in this section we will about how to make Grouping in Extjs. Grouping is very useful for us in the search data, with the grouping we will be more easily explore the data that we find.

(more…)

Tutorial Extjs Expanded Row

Friday, February 13th, 2009

Today, we will continue our tutorial about extjs, and in this section we will learn about how to make Expanded row in Extjs grid form. According to me Expanded row is very useful to provide additional information from the data that we created, so the data is clearly.

(more…)

Simple Paging Grid Extjs

Wednesday, February 11th, 2009

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