fastsol Posted July 17, 2014 Share Posted July 17, 2014 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 Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/ Share on other sites More sharing options...
fastsol Posted July 18, 2014 Author Share Posted July 18, 2014 I have attached the zip file here Screen Shots sql.zip Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/#findComment-1485636 Share on other sites More sharing options...
QuickOldCar Posted July 20, 2014 Share Posted July 20, 2014 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. Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/#findComment-1485729 Share on other sites More sharing options...
fastsol Posted July 20, 2014 Author Share Posted July 20, 2014 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? Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/#findComment-1485740 Share on other sites More sharing options...
QuickOldCar Posted July 20, 2014 Share Posted July 20, 2014 It was the link on your download page up top for version 2.0.9 http://amecms.com/dlupd.php?file=amewebcms.zip&t=V9C9wfwtawsqH7dgIY1igXpAmO9xV8HQgmYNAwjL2KbKSq2Cq3TGZjgo9oU6 Now it appears as it's working. There was a message box that kept appearing stating the file was not available. Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/#findComment-1485761 Share on other sites More sharing options...
fastsol Posted July 20, 2014 Author Share Posted July 20, 2014 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 Quote Link to comment https://forums.phpfreaks.com/topic/289966-sql-string-testing-tool/#findComment-1485765 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.