http://google.com/search?q=phpmyadmin
phpmyadmin has all the functionality you are trying to build - and it
implements it securely - even if you are writing the code/tool mentioned below
as a learning exercise (as opposed to writing it because you need to
be able to execute arbitrary queries easily) then the source of the
phpmyadmin project is a good resource.
WILLEMS Wim (BMB) wrote:
> Dear all,
>
> I am trying to pass variables from one php-file to another but that
> doesn't seem to work. Anyone an idea what I am doing wrong?
>
> The first file shows a dropdown with all the databases on the server
> (only 1 for me). You have to select a database and put an SQL query in
> the textarea.
> Pushing "Execute query!" then calls the second file test2.php which
> should put all the variables on the screen (first there was another
> routine but that did not work, so I created this simple output to test
> the veriables).
>
> <html>
> <head>
> <title> PHP SQL Code Tester </title>
> </head>
> <body>
> <!--query.php-->
> <?php
> $host="localhost";
> $user="some_user";
> $password="some password";
> ?>
> <form action="test2.php" method=post>
> Please select the database for the query:<br><br>
> <select name=database size=1>
> <?php
> $wim = 5; /* this is added to test the passing of the variables -
> doesn't work either */
> $link = mysql_connect($host, $user, $password)
> or die(" Cannot connect : " . mysql_error());
> $db_table = mysql_list_dbs();
>
> for ($i = 0; $i < mysql_num_rows($db_table); $i++) {
> echo("<option>" . mysql_tablename($db_table, $i));
> }
> ?>
> </select>
> Please input the SQL query to be executed:<br><br>
> <textarea name=query cols=50 rows=10></textarea>
> <br><br>
> <input type=submit value="Execute query!">
> </form>
> </body>
> </html>
>
>
> This routine which is called with the routine above should print all
> variables but it doesn't. Well, the routine itself works but the
> variables are empty.
> <html>
> <head>
> <title>PHP SQL code tester</title>
> </head>
> <body>
> <!-- test2.php-->
> <?php
> echo "Dit is een test<br>"; /* this is printed to the screen */
> echo "$wim"; /* this is NOT printed to the screen */
> echo "$host<br>"; /* only the <BR> is printed */
> echo "$database<br>"; /* only the <BR> is printed */
> echo "query: $query<br>"; /* only the <BR> is printed */
> echo "Dit is test 2"; /* this is printed to the screen */
> ?>
> </body>
> </html>
>
>
> Thanks for your help,
> Wim.
>
> **** DISCLAIMER****
> http://www.proximus.be/maildisclaimer
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
