note 31789 added to ref.mysql

From: 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. It’s 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 you’re 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

« previous php.notes (#47470) next »