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?
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 }; ?>>
-
Dan Allen -
Ignacio Vazquez-Abrams -
Marc Delisle -
Robin Johnson