[Phpmyadmin-devel] Query Builder Ajax UI

[Dougal Matthews]

That's still working, I also enabled that Add/Remove tables (they get tables
directly from the database now) and the generate SQL.

I've not allowed the executing of the query yet as i need to do security
checks and also the generation of the SQL isn't quite finished - i've not
implemented the joins.

By the way, when you add the tables, note that you can join tables by
dragging rows from one to another. I should really add a note to tell people
this because nobody thinks you would be able to do that :)

Dougal


On 07/05/07, Dougal Matthews <dougal85 at gmail.com> wrote:
>
> Sorry, I fixed it now, I uploaded the wrong version by mistake!
> My bad, It should be good to go now.
>
> Sorry about that.
>
> Dougal
>
> On 06/05/07, Marc Delisle <Marc.Delisle at cegepsherbrooke.qc.ca> wrote:
> >
> > Dougal Matthews a écrit :
> > > Hi,
> > >
> > > I contact you all a while ago saying that I was going to attempting to
> > > create a query builder power by JavaScript for phpMyAdmin as a
> > > university project.
> > >
> > > I have been working away at it and have learned loads, this is the
> > first
> > > time I've used JavaScript for anything serious.
> > >
> > > Anyway, I have so far created a prototype that I would like to show
> > you.
> > > I first need to state that due to time constraint with university this
> > > prototype currently ONLY supports Firefox 2 and above (maybe 1.5 but
> > > I've been testing with version 2). It may also work in Safari and
> > opera,
> > > I don't know.
> > >
> > > This is by no means a finished product, However, I'd like to show you
> > > have I have so far. You will run into a number of a issues, however
> > any
> > > feedback would be appreciated.
> > >
> > > I have been having problems utilizing the functions in phpMyAdmin to
> > use
> > > within my Ajax engine, I believe this is because of headers and
> > cookies
> > > being sent by PHP. Any suggestions how I can get around this?
> > >
> > > Right... less talking, more prototype showing...
> > >
> > > Please read this section before visiting;
> > >
> > > Known Limitations (there are more, I've not got the list next to me,
> > but
> > > the main problems are below);
> > >
> > >     * Add remove tables can be buggy when tables are added and removed
> > >       repeatedly
> > >     * View SQL Query and Run SQL query are not yet working. Due to
> > >       problems hooking in with the phpMyAdmin php
> > >
> > > System Requirements:
> > >
> > >     * FireFox 2+ (maybe 1.5+)
> > >     * A decent screen resolution, 1280 X 1024 recommended. It will
> > work
> > >       on lower but wont look as good. try going to full screen.
> > >
> > >
> > >
> > > And finally the URL is... http://www.dougalmatthews.com/hp/pma/
> > >
> > > Depending on the feedback and what you guys think, I am hoping to
> > > continue this project in the summer and fix all the problems and add
> > in
> > > cross browser support. I also hope to reduce the size of the
> > JavaScript
> > > by eliminating some of the library use.
> > >
> > > Thanks
> > >
> > > Dougal
> >
> > Hello Dougal,
> > I am testing with FF 2.0.0.3 on Win XP.
> >
> > I click Add/Remove Tables.
> > I tick table1 and get
> >         TypeError
> >         QB::addTable - Error adding table
> >         Table::Constructor - type error: pId must be a Number
> >         Undefined(undefined)
> >         qb::manage - Adding table1
> >
> > Then I close the Add/remove tables window and cannot do anything else.
> >
> > Marc Delisle
> >
>
>
>
> --
> Website : www.dougalmatthews.com




-- 
Website : www.dougalmatthews.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20070507/88663b07/attachment.html>