note 31789 added to ref.mysql
| From: | leader at k2wrpg dot org | Date: | Sat, 03 May 2003 21:27:52 +0000 |
| Subject: | note 31789 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-47470@lists.php.net to get a copy of this message | ||
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
--
http://www.php.net/manual/en/ref.mysql.php
http://master.php.net/manage/user-notes.php?action=edit+31789
http://master.php.net/manage/user-notes.php?action=delete+31789
http://master.php.net/manage/user-notes.php?action=reject+31789