Which the user then fills in, which in turn logs him/her into phpmyadmin according to the details they have filled in.

How would I do this? Any Ideas?!?

Justin4WebHelp Addict

Joined: 07 Jan 2002
Posts: 1060

Posted:
Mon Feb 17, 2003 4:24 pm (15 years, 1 month ago)

Right, have worked out how to do this, by switching the authentication to cookie, and listing the servers in config.php, I get a login screen showing the following fields :

Language :
Username :
Password :

Server :

What I also need is one for a table, as in the site I linked to above, if I leave the table field blank in the config.php, the left bar is just simply blank and does not show up a list of DB's, is there any way I can specify the table on login as I can the username, password and server?

Thanks!

Justin4WebHelp Addict

Joined: 07 Jan 2002
Posts: 1060

Posted:
Mon Feb 17, 2003 5:52 pm (15 years, 1 month ago)

Some Weird Firewall here, if I don't specify the table name in phpmyadmin's config file, it does not display the left hand frame, so a user can't select their db on login..

Justin4WebHelp Addict

Joined: 07 Jan 2002
Posts: 1060

Posted:
Mon Feb 17, 2003 7:03 pm (15 years, 1 month ago)

Justin wrote:

Some Weird Firewall here, if I don't specify the table name in phpmyadmin's config file, it does not display the left hand frame, so a user can't select their db on login..

LOL - I found out why it did that, it was not a firewall problem, it was a timeout, have a guess how many databases are on server0038.freedom2surf.net? 1500(!!!)

Talk about seriously overloaded servers!!!

Justin4WebHelp Addict

Joined: 07 Jan 2002
Posts: 1060

Posted:
Fri Feb 21, 2003 10:52 am (15 years, 1 month ago)

Unfortunatley, on further investigation it appears that the information Freedom2Surf have supplied is is WRONG.

Freedom2Surf have not disabled uploading .csv files in phpmyadmin, what they have gone and done is disable the LOAD DATA LOCAL INFILE command in mysql. So Basically, I'm afraid to say, as this is off, there is no way of uploading a .csv file at all.

F2S have disabled this command in mysql, making the whole process impossible. Complaints should be fired to chris@freedom2surf.net, make your feelings known.

DanielTeam Member

Joined: 06 Jan 2002
Posts: 2564

Posted:
Sat Feb 22, 2003 9:19 am (15 years ago)

Seems like the typical "it doesn't work, so we'll just disable it. No matter how it's done, as long as it can't work"

________________________________

Justin4WebHelp Addict

Joined: 07 Jan 2002
Posts: 1060

Posted:
Sat Feb 22, 2003 10:30 am (15 years ago)

Yeah, but whats the hell the point of turning it off in MySQL? Thats really stupid. All they need to do is upgrade phpmyadmin then turn it back on, upgrading phpmyadmin took me about 3 minutes max here, surely they could do that?!?

jayantTeam Member

Joined: 07 Jan 2002
Posts: 262
Location: New Delhi, India

Posted:
Mon Feb 24, 2003 2:37 am (15 years ago)

There are a few PHP scripts which do CSV import without using "load data into" query, but instead read the file line by line and query the database with the "insert into" query

You cannot post new topics in this forum.You cannot reply to topics in this forum.You cannot edit your posts in this forum.You cannot delete your posts in this forum.You cannot vote in polls in this forum.