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@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@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