import text files to sql via php

Anon

hi there.

i need to find a way to import txt files to a sql database. People should be able to browse their harddisk by a form, select a file and upload this file.
Unfortunately i cannot use phpmyadmin itself cuz it has to many options i dont want to offer everybody using the db.

thx for advance

bunny

d-woo

phpMyAdmin may, in fact, be the easiest solution.

You can setup a generic user profile (username and password) which will prevent the generic user from seeing all of the options that you see.

In fact I have it setup on one account where all they see is the command box and go button.

Anon

first of all: thx for your help.

obviously you did this kind of setup.
could you tell me how to do this respectively which files of phpmyadmin i got to change.

thx for advance again.

bunny

Anon

hi bunny

okay,
the first thing I did was set up a username and password with limited permissions. This was done on the server side.

Secondly,
In phpMyAdmin, I created a special folder, e.g. www.mydomain.com/updates. This folder is identical to the folder you use to access e.g. www.yourdomain.com/phpMyAdmin with the following exceptions:

the config.php file has the limited permission username and password entries.
the index file, index.php, forwards to
www.yourdomain.com/updates/db_details.php3?server=1&lang=en&db=yourdbname

What this does is prevents them from seeing your other databases on the left menu and takes them directly to the database that you want them to see. Exactly what is seen is dependent on the permissions for the database (view, edit, read, etc) that you setup on the server side (independent of phpMyAdmin).

Anon

d-woo you out there ?

thx again.

your advice helped me a lot. I solved the
the user/pass problem a little different.
i got a subdomain admin.server.com which protected by a .htaccess file. Now i want the index to go straight forward to ldi_table.php3?lang=eng&server=1&...&table=..
as soon as sobody entered the correct login.
As i´m really new to php i dont know how forward automatically.
Of course i could use a simple html link.
But i know there must be a better solution and something in my mind tells me you know it.;-)

thx again.
bunny

Anon

Hi Bunny,

At the bottom of this file is the syntax for your new index.htm or index.php3 file.

Recap:

Let's say people click your link. If they remove/delete the db_details.php3?server=1&lang=en&db=yourdbname portion from the URL, then voila...they see the very thing that you didn't want them to see...which is the left frame giving them access to your other files.

Solution: Give them their own folder, identical to yours. Exception: different name and different .htaccess password. Sounds as though you've done this...great.

I did forget to mention password protecting that phpMyAdmin directory...great idea. What I was suggesting regarding username and password was not access to the folder, but rather the database itself. Many servers are configured where you can have multiple users...each user having different permission levels (some can view only or edit only, but not delete). If you have this, by all means do it. It will save you many headaches in the future.

To prevent them from accessing the left menu overwrite the index.php3 file to this below. This will automatically forward them to where you want them to be...even if they remove the portion of the URL discussed above, they will be redirected immediately (in 00 seconds).

Hope this helps you!!!

Syntax: for index.php3

<head>
<title>Transferring</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta HTTP-EQUIV="refresh" CONTENT="00;
URL=http://www.yourdomain.com/updates/db_details.php3?server=1&lang=en&db=yourdbname/">
</head>

Anon

PHP solution is better than the HTML...

index.php3 syntax:

<?php
include "http://www.yourdomain.com/updates/db_details.php3?server=1&lang=en&db=yourdbname/";

?>

It's superior in that it will hide the dbase name and URL portion: "details.php3?server=1&lang=en&db=yourdbname"

Enjoy!

Anon

Hi d-woo!
If you read this - Its not another
of my little problems with php. Its just thx, man.

Finally i got everything i want.
i use .htaccess to protect the admin area and
i overwrote that index.php3 as you suggested.
Its a much better solution then the one with that link. (although "they" could see every db on that server and do what they want with it it´s better they know less. Its their ftp&sql as they pay for it :-) The solution that offers the min amount of options will be the best and most comfortable for them.
And those guys just want to import txt files.
So i want to give them nothing else.)

Anyway you helped someone from the other end of the world - thx!
bunny