[Phpmyadmin-devel] suggestion for reloading of left.php
Right now, if you use the form on the db_details.php page to create either a new database or a new table, it knows to update the left.php frame since either new tables or new databases are there...oh, and same thing with drop. However, if either of these queries are executed from the SQL query box....the frame is not reloaded and the new tables/databases or the lack thereof are not updated for the rest of the session (without of course a force reload or other action which would cause it already). Anyway, long story short, we should run ereg on the query and search for CREATE or DROP at the beginning ereg("^CREATE|^DROP",$query) and then reload the left.php if either of those are found. Dan Allen __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
On Tue, 14 Aug 2001, Dan Allen wrote:
Anyway, long story short, we should run ereg on the query and search for CREATE or DROP at the beginning
ereg("^CREATE|^DROP",$query) Actually, if the user feeds a long set of queries in, it could be anywhere in the list. so ereg("CREATE TABLE|CREATE DATABASE|DROP TABLE|DROP DATABASE",$query);
and then reload the left.php if either of those are found. Anybody got some suggestions on how to do this?
-- Robin Hugh Johnson QTOD: "I used to be an idealist, but I got mugged by reality." E-Mail : robbat2@orbis-terrarum.net ICQ# : 30269588 or 41961639 Home Page : http://www.orbis-terrarum.net/ Time Zone : Pacific Daylight (GMT - 8) -----BEGIN GEEK CODE----- geekcode.com ebb.org/ungeek GCS/M/IT d-(+) s+:- a--- C++++ U++++ L++++ P--(+) W++ K++ PS+ N++ w--- O E---- M-(+) V-- Y++ PE++ PGP++ t-- 5 X+ R tv- b+++ D++ G++ e(*) h! r-- !y+ ------END GEEK CODE------ -----PGP INFO---- Key ID:0x7E20DFA1 FingerPrint: 5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1 ----PGP INFO-----
On Tue, 14 Aug 2001, Robin Johnson wrote:
On Tue, 14 Aug 2001, Dan Allen wrote:
Anyway, long story short, we should run ereg on the query and search for CREATE or DROP at the beginning
ereg("^CREATE|^DROP",$query) Actually, if the user feeds a long set of queries in, it could be anywhere in the list. so ereg("CREATE TABLE|CREATE DATABASE|DROP TABLE|DROP DATABASE",$query);
and then reload the left.php if either of those are found. Anybody got some suggestions on how to do this?
File 1: ------- $refreshnav=ereg(...); header("Location: ...&r=$refreshnav"); File 2: ------- <body ... <?php if ($HTTP_GET_VARS['r']) { ?> onLoad="top.nav.location.refresh(true)"<?php }; ?>> -- Ignacio Vazquez-Abrams <ignacio@openservices.net>
participants (4)
-
Dan Allen -
Ignacio Vazquez-Abrams -
Marc Delisle -
Robin Johnson