note 31789 deleted from ref.mysql by aidan
| From: | aidan@php.net | Date: | Sat, 11 Sep 2004 09:14:14 +0000 |
| Subject: | note 31789 deleted from ref.mysql by aidan | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-76465@lists.php.net to get a copy of this message | ||
Note Submitter: leader at k2wrpg dot org
----
While doing lots of mysql work remotely I got tired of having to upload my files over and over again
to find problems in my sql queries. I was also having a hard time checking the data in the DB itself
(especially when behind a firewall, ugh.) anyway I present to you a single file query analyzer. So I
made an easier way. Its not persistent so some complex statements using temp tables and such
probably won't work, but for simple Selects, Updates, Inserts and Deletes, it works just fine.
I would say it handles about 95% of the queries I want to run. Anyway I found it useful so I'll
share. Just save the following code into a file named sqlquery.php, and put it on your server If you
name it something else you'll have to change the target of the form. Also its totally insecure
so if youre worried about eavesdroppers don't use it.
Enjoy!
rather than post the code, here is a download:
http://k2wrpg.org/~leader/sqlquery.php.zip