phpMyAdmin Ajax Query Builder

[dougal85]

I have mentioned this on the forum a number of times; it’s a project I’ve been working on for university. Basically I have been creating a query builder for phpMyAdmin that is powered by JavaScript.

I am running out of time before the work is due in, so I wont be developing much more on my prototype. I am writing up what I have learnt and what I plan for the future. I am going to try and do more on it over the summer when I have time.

Anyway, I’d be grateful if you could provide me with any feedback

Please read this section before visiting;

It's best to test it with the testing controls for the time being, but feel free to play with the others. (only the add/remove tables works :P)

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.

Dougal

*edit*

Note, the reason this is not currently integrated into the phpMyAdmin interface is I am having problems integrating with some of there functions through AJAX. I think it is because they are spitting out headers and cookies all over the place. So it is seperate for now, however integration will be easier when I fix this problem. Any suggestions on how to do so would be appreciated.

*edit 2*

I'm having server problems for some reason, i'm working on it just now. I think my servers mySQL database server crashed. I've contacted them, waiting to see what happens.

[dougal85]

It's running again now.

[bpat1434]

Overlay is not defined _db_qbe.php (line 1)

Totally useless for me currently..... Firefox 2.0.0.3

[dougal85]

try again, ive had horrible problems with my cheap crap host today.

I just had to re-upload everything.

[stolzyboy]

just a note, CPU consumption ranged from 50% to 95% when running this

[dougal85]

Cool, thanks.

It was a university project so had to do a demo today, so there was a bit of code i hacked together to get it working on time.

When i do that part properly it will be allot better. Before the CPU usage was no where near as high.

[bpat1434]

Hmm.. maybe it's just my firefox, but it keeps saying that "Overlay is not defined" in my Firebug extension window. And I did too notice that my computer started to lag during the "loading" of the app. My mouse crawled across the screen.... instead of scurrying that is ;)

[halojoy]

Anyway, I’d be grateful if you could provide me with any feedback

Please read this section before visiting;

It's best to test it with the testing controls for the time being, but feel free to play with the others. (only the add/remove tables works :P)

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.

Dougal> Anyway, I’d be grateful if you could provide me with any feedback


I give you feedback, but more on your website
than on your mysql application

( I do not use mysql, unless I have to
... if some script I want to download/install has got no other alternative
I scan the web for php open source applications that use SQLite or Flatfile DB
The dBase ( xBase ) module that comes with PHP does not give justice to xBase data model
I am always having my own NON-SQL MiniDB PHP Class project going.
But just as your php work, it goes too slow for me.
But I know in my head how I will structure my PHP MiniDB Class
Not serialize/unserialize this time, but use custom data delimiters )


1. you have one of nicest websites I have seen this year
2. you plan to provide for users to register and add stuff
3. you will have time to do more work on this this summer of 2007


> Depending on the feedback and what you guys think, I am hoping to continue this project

Don't say that! Don't go there!
Obviously to me you know very well what you are doing.
You are probably way more clever with web applications than many of those posting here :p
Judging from the little stuff you so far have at your site
I have ripped most of it! And put it in My Documents.

C:\My Documents\dougalmatthews.com\070512\index.php5
.. and so on :)

I hope I will have time to see how you do it.
And learn a few new things for my own small website designs.

'Depending on what you guy think' ????
I say:
Do not be dependent, be in-dependent!!!
Like modern African and most former USSR and Jugoslavian states are today.


Listen to good advice to guide you on your way.
But YOUR WAY and your intentions should be YOURS .. nobody elses.

Independent of what other and the mainstream of PHP Gurus say and do
.. I try to do PHP Scripting my way.
I may fail sometimes, but it is my own failures .. not because of some bad influences!

I will, I am sure, have success .. and it will be MY OWN SUCCESS.
Not much credits to all those giving my directions go the 'wrong way' the 'other way'.
The way not of My own Choice and thinkings.

Good luck I say yo you Matthews.
Stay true to your self.
And you will have better chance of learn how to be true to others true.

If we can not be true to our selves, who we love the most
.. to whom will we be able to be true to?


I ask.


------------------------------
finally .....
I ran your script -> JAVA to -> SQL Query.
http://www.dougalmatthews.com/hp/pma/
No problems what I could discover ... no errors what I could notice.
I also have Firefox 2.0.0.3.


Regards
halojoy
:)

[dougal85]

Hi,

Thanks for that feedback, its very encouraging.

However, I am actually planning on changing the goals etc of that website. I'm not really sure what yet, but really that website is used more as a learning curve for me. I like to try out new Idea's and see where they take me. I've not yet made a serious website for myself yet... I always get bored and start again.

What I think i may do it make it a place for hosting posting about experimental projects, similar to the query building one.

Anyway, back to the post topic... the Query Builder got posted on Ajaxian so I managed to get some good feedback from that and a few thousand hits.

[dougal85]

Hmm.. maybe it's just my firefox, but it keeps saying that "Overlay is not defined" in my Firebug extension window. And I did too notice that my computer started to lag during the "loading" of the app. My mouse crawled across the screen.... instead of scurrying that is ;)

I'm sure I replied to this before. strange.

I've noticed that happening before, I think sometimes the Overlay file doesn't download properly. I need to put all my JavaScript in one file. Usually fixes when i refresh.

...and yeah performance is a biggy for me to fix. I know what I'm going to do to fix it, just need to get my uni exams out the way first.