Jump to content

SQL String testing tool


fastsol

Recommended Posts

So I built a tool for my cms a while back and have decided to share it.  The only 2 things that I know of that are similar in nature is phpmyadmin or sql buddy.  Now my tool is not nearly as in depth as either of those but what it lets you do is run any query string right from the webpage.  But the cool thing that it has over phpmyadmin and sql buddy is that it has buttons for many of the common commands and a ajax select to get the available column names for the selected table.  So now you don't have to try and remember what table had what column and "how did I spell that column again".

 

I use this to test sql strings for syntax and to quickly see if it returns the results I expect without having to edit the code and then save, upload or hit refresh or whatever.  Since all the the stuff is done via ajax, it's all quickly displayed and you can change the query immediately and hit the Run Query button again.

 

I just thought that this could be helpful and useful for others.  You can download it here http://amecms.com/article/Test-SQL-Strings-Quickly-and-Easily

Link to comment
Share on other sites

Looks useful, I once made an automatic database tool that one can associate or remember any database info and to be used in dynamic queries later on.

 

On your site the download link on top doesn't work, but the ones below do.

Link to comment
Share on other sites

On your site the download link on top doesn't work, but the ones below do.

Can you be more specific as to which link you are referring to?  I test them often and all seem to be working for me.  Was it giving you a pop up type message saying the file is unavailable?

Link to comment
Share on other sites

Ahh, I did find something that I forgot to add to the link to make it not appear until after the page fully loaded.  If the link was clicked before the page finished loading the token var had not been set in php yet, so when trying to access the token on the dlupd.php it wasn't able to match that token and triggering the unavailable message.  That link was I think the only one I had forgotten when coding it a while back.

 

I guess thanks for catching that, who knows how many downloads I have missed cause of that :(

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.