[tutorial] Grid / PHP / SQL for newbies

[nbize]

Hi community,

With the increasing number of new threads concerning the use of Grids with a PHP / SQL backend, I have put together a compilation of 12 small tutorials explaining how to build a fully functional php/sql/grid from scratch.

You can find the tutorial here

I hope it helps!

Happy Griding.

[hero2005]

very good one

thanx

[hoflandr]

Hi, thanks for the great tutorial! It helps me a lot!

There is a small bug after dragging the main window. The form gets disabled. In the tutorial 3 it's ok, but after 4 it doesn

[Richie1985]

hey thank you very much, this tutorial is realy good for newbies like me

but i have one problem:

i want to build a dynamic columnmodel:

boerse_ColumnModel = new Ext.grid.ColumnModel(
    [{
        header: '#',
        readOnly: true,
        dataIndex: 'id', // this is where the mapped name is important!
        hidden: true
      },{
        header: 'Intervall',
        hidden: true,
        dataIndex: 'intervall'
      },{
        header: 'Zeit',
        hidden: true,
        dataIndex: 'intervallstep'
      },{
        header: 'Von',
        dataIndex: 'zeit',
        renderer: von
      },{
        header: 'Bis',
        dataIndex: 'zeit',
        renderer: bis
      },{
        header: 'Calls',
        dataIndex: 'calls',
        editor: new Ext.form.NumberField({  // rules about editing
            allowBlank: false,
            allowNegative: false,
            maxValue: 5000
          })
      },{
        header: 'Standort1',
        dataIndex: 'standort1'
      },{
        header: 'Standort1',
        dataIndex: 'standort1'
      },{
        header: 'Standort1',
        dataIndex: 'standort1'
      }]
    );
    boerse_ColumnModel.defaultSortable= true; 

i want to create the "standort" from a php arrray. how can i do this?

Sorry for my bad english

thanks

[stevets]

Nicolas,

I just wanted to say thanks for a great tutorial. I am new at Javascript but I know basic web design and am pretty good with SQL and server-side scripting.

I have been looking at several libraries such as ext, yui, jquery, prototype, etc. I was never quite sure where to start with any of these. Your tutorial really did tie the pieces together for me and I have settled on ext for my project due in no small part to your tutorial.

If you had a "Pay-Pal Donate" link I would have clicked on it to thank you for your work.

I created an account on this site specifically to make this post.

[hero2005]

back again

update function does not working

[mjlecomte]

back again

update function does not working

Generally you need to provide more info than that. "Does not work" is very vague. Did the js work? Your backend doesn't work? Is your computer on? Be very specific if you expect valuable help.

[stevets]

I am reading along in the tutorial but there is something that I am having trouble understanding. In part 3 the datastore definition begins with the following:

 PresidentsDataStore = new Ext.data.Store({
      id: 'PresidentsDataStore', 

What does the id: do? What is the purpose and where is that used?

Go easy on me I'm a total newb.

[JoomlaMan]

This is awesome, going to read through it

[outrage]

This is a fantastic tutorial that helped me understand much more than just the grid component.

You deserve a medal. Thank you very much.

We need more tutorials of this calibre.